Topics

Apr 9, 2011

Show or hide row and column headers in Excel 2007

By default, the row and column headers are displayed. It displays letters for indicating columns and numbers for indicating the rows. It helps to enter the data into the specific cells). Also, if cell(s) are selected then the row and column headers get shaded to indicate the selected cells. If you decide to hide the row and column headers then you may do so by changing an Excel option. You may also turn on this option later. Perform the following steps to show or hide row and column headers:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, scroll down to the Display options for this worksheet: and do one of the following:
To show the row and column headers - Click to place a checkmark besides Show row and column headers.
To hide the row and column headers - Click to remove the checkmark besides Show row and column headers.
5. Click OK.

0 comments:

Post a Comment