Want more room when editing or viewing your Excel spreadsheet? Try this handy tip!

By default, row and column headings are always displayed. Row and column headings have their purpose, one of which is for reference when creating formulas. However, the problem is that these headings take up space when you’re trying to edit the data or simply view the spreadsheet.

If you want more space for editing and viewing, you can hide the column and row headings from view. To accomplish this in Excel 2007:

  1. Within your spreadsheet, click the View tab.
  2. In the Show/Hide section, remove the check beside Headings.

Excel - Hide Rows And Columns

When the column and row headings are hidden from view, you can easily find the column/heading value by clicking a specific cell. The column/heading value is displayed in the Name Box.

To show the column and row headings, simply repeat the steps above again.