Prev: Dynamic data ranges in pivot tables
Next: Conditional formatting
From: shebbir on 18 May 2010 06:09

From: Dave Peterson on 18 May 2010 08:00
You can either see letters or numbers or nothing as the column headers.

In xl2003 menus, you can toggle the setting here:
Tools|Options|General Tab|check/uncheck the R1C1 reference style

To hide the numbers or letters:
Tools|Options|View Tab|check/uncheck Row and column headers

======
For me, I like to see the letters at the top (for the most part). And I would
expect most excel users know how excel works and find those headers useful --
even if they like to see numbers.

I wouldn't change that view for the users.

But I would put the headers I want in row 1 and freeze the window so that those
headers are always visible:

Select A1 to make sure it's visible
select B1
Window|Freeze Panes.

Every row above the selected cell will be frozen. (And every column to the left
of the selected cell will be frozen -- even though I didn't use it in this example.)



On 05/18/2010 05:09, shebbir wrote:
>
 | 
Pages: 1
Prev: Dynamic data ranges in pivot tables
Next: Conditional formatting