............ Have a nice day............

Thursday 31 July 2014

How to Set Row Label Width in Excel 2010

Follow the steps below to learn how:
  1. Click File | Options.
  2. At the left of the resulting dialog box, click Advanced.
  3. Scroll down until you see the Display Options for this Worksheet section.
Excel 2010 options

  1. Make certain the Show Row and Column Headers box is selected. If it is clear, then the header area will not be displayed.
  2. Click OK.
It is now a non-issue because Excel will not display the row headers at the left of her screen. If you really want to have an indication as to the row number, you could always insert a blank column A and then insert numbers to represent your row numbers. You column can be as wide as you need so there will not be any redrawing when you scroll.

No comments:

Post a Comment