[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Collapse]Worksheets
     How to: Access a Worksheet
     How to: Set an Active Worksheet
     How to: Add a New Worksheet
     How to: Delete a Worksheet
     How to: Rename a Worksheet
     How to: Copy Worksheets within a Workbook
     How to: Copy Worksheets between Workbooks
     How to: Move a Worksheet to another Location
     How to: Show and Hide a Worksheet
     How to: Show and Hide Gridlines
     How to: Show and Hide Row and Column Headings
     How to: Set Page Orientation
     How to: Set Page Margins
     How to: Set Paper Size
     How to: Zoom In and Out of a Worksheet
   [Expand]Rows and Columns
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Expand]Pivot Tables
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Show and Hide Row and Column Headings

Important

You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use these examples in production code. Refer to the DevExpress Subscription page for pricing information.

Cells in a worksheet are arranged in rows (Worksheet.Rows) and columns (Worksheet.Columns). Each row and column has a unique name (rows use numbers "1", "2", "3",..., "1048576", and columns use letters "A", "B", "C",...,"XFD"). Row and column names are displayed on a worksheet's left and top side, respectively. Use the Worksheet.ActiveView.ShowHeadings (WorksheetView.ShowHeadings) property to control row and column headings' visibility in a worksheet.

Note

Use the WorksheetPrintOptions.PrintHeadings property to specify whether row and column headings should appear in a printout. Refer to the How to: Specify Print Settings document for details on how to specify print options for a worksheet.

The image below shows a worksheet's appearance with visible and hidden row and column headings (the workbook is opened in Microsoft® Excel®).

Is this topic helpful?​​​​​​​