Microsoft Excel - hide rows and columns numbers

Asked By Don on 07-Aug-11 01:17 PM
How can I hide the row and column numbers from showing in Excel?
Radhika roy replied to Don on 07-Aug-11 01:29 PM

How to Hide and Unhide Rows and Columns in Excel 2010

You can hide and unhide rows or columns in Excel 2010 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports — hidden rows and columns do not print.

You cannot hide selected cells; only entire columns or rows.


Select the column or row headings you want to hide.

Press the Ctrl key while selecting multiple rows or columns. If you want to unhide rows or columns, select the rows or columns both before and after the hidden rows or columns.


Click the Format button in the Cells group on the Home tab.

Notice the Visibility section of the resulting Format drop-down menu.


Point to the Hide & Unhide command under Visibility in the Format menu.

Another menu appears, containing options for hiding and unhiding rows and columns.


Make a selection from the menu.

When you hide columns or rows, the associated column letters or row numbers disappear from the worksheet frame.

Read more:
Radhika roy replied to Don on 07-Aug-11 01:34 PM

As with all things Microsoft, there is more than one way to hide rows in an Excel worksheet. These instructions show you how to hide rows by right clicking on the row header.

The row header is the gray bar along the left edge of the worksheet containing the row numbers.

Hide Rows in an Excel Worksheet

When you hide a row in a worksheet, data in that row can still be used and referenced in the worksheet.

To hide a single row

  1. Right click on the row header of the row to be hidden.
  2. Choose Hide from the menu.
  3. The selected row and the row number will be be hidden from view.

To hide adjacent rows in the worksheet

For example, you want to hide rows 4, 5, and 6.

  1. In the row header drag select to highlight all of the rows you want to hide.
  2. Right click on the selected rows.
  3. Choose Hide from the menu.
  4. The selected rows and row numbers will be hidden from view.

To hide separated rows in the worksheet

For example, you want to hide rows 3, 5, and 7.

  1. In the row header left click on the first row to be hidden.
  2. Press and hold down the CTRL key on the keyboard.
  3. Continue to hold down the CTRL key and left click on the rest of rows to be hidden.
  4. Right click on one of the selected rows.
  5. Choose Hide from the menu.
  6. The selected rows and row numbers will be hidden from view.
John D replied to Don on 07-Aug-11 02:51 PM
Hi Don
If I understand your question, you want to hide the Row and Column Headers.
That's the Row numbers and the column letters.
you're not saying what version of Excel you're using so XL2003 and older just go to menu>Tools>Options
under the View Tab uncheck  Row and column header.
Devil Scorpio replied to Don on 07-Aug-11 03:57 PM
Hi Don,

You can hide rows and column headings by following 2 ways

1. Manually
2. Programmatically

Goto Tools | Options | View | Window option -> deselect  Row & Column headers

Please follow the procedure to do the same
1. Open Excel
2. Goto Tools -> Macro -> Visual Basic Editor. It opens Microsoft Visual Basic Editor.
3. Double click ThisWorkbook placed on Left pane window.
4. Copy & paste following code
    Private Sub Workbook_Open()
     ActiveWindow.DisplayHeadings = False
    End Sub

5. Save it.
Riley K replied to Don on 07-Aug-11 09:41 PM
Do this way

Menu Tools>Options>View and uncheck Row and Column headers

IF you want to hide selected rows and columns

  1. Select the rows or columns you want to hide.
  1. On the Format menu, point to Row or Column, and then click Hide.
Jitendra Faye replied to Don on 08-Aug-11 12:03 AM
Hiding rows and columns does not just have to be for concealing data or formulas. If your spreadsheet only uses a small area of the 16,777,216 available cells in an Excel worksheet, maybe it would be nice to hide some of that vast unused region to keep users from scrolling off the edge of your working area.

Here are the simple steps to accomplish this task:

  1. Select the row header just beneath the used area of your spreadsheet, where you want to start hiding rows.

  2. Press Ctrl + Shift + Down Arrow. This will highlight everything from your selected row through the bottom of the worksheet.

  3. From the worksheet's Format menu, choose Row, then Hide.
Follow the same basic steps to hide columns. The difference will be that you should begin by selecting a column header in the first empty column to the right of your used area, then press Ctrl + Shift + Right Arrow.

Finally, from the worksheet's Format menu, choose Column, then Hide.
Ravi S replied to Don on 08-Aug-11 04:56 AM

follow this

Hiding Rows

In desired spreadsheet select the rows (for multiple non-contagious selection hold Ctrl key) you want to hide and navigate to Home tab.

select rows

From Cells group, click Format button. Now from Hide & Unhide options, click Hide Rows.


Upon click it will automatically hide the selected rows. The rows 2,3,5 and 7 numbers are now hidden.


Hiding Columns

For hiding the columns in specific sheet, select the columns you want to hide.

hide columns

Repeat the same procedure for it, from Format –> Hide & Unhide options, click Hide Columns, upon click the selected columns will be hidden.

hidden c

Hide Sheets

Now select the sheet which you want to hide.

hide data bars

Click Hide Sheet from Hide & Unhide options.

hide sheet

Upon click the whole sheet will be concealed.

sheet hidden

Unhide Rows, Columns, and Sheets

For revealing the hidden sheets, rows and columns,  click Format, and from Hide & Unhide options, click the respective option available in the menu.


You can also check out previously reviewed guides on Tracking Formula Precedents & Dependents and Show complete formula instead of Evaluated Result in Excel 2010.