Column titles

  • Thread starter Thread starter James Silverton
  • Start date Start date
J

James Silverton

Hello, All!

Perhaps I have not woken up properly yet but I have a sheet that
is updated daily and there are several sets of columns derived
from the input values. I sometimes forget which columns are
which and have to go to the top of the page to find the
headings. Is there a simple way to do this? Should I perhaps
best write a macro and assign it to a button? Ideally,I would
like to see the values and the headings at the same time?

Thanks in advance.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 
Hi James,

Have you tried splitting the window or freezing the panes? See Window|Split and Window|Freeze Panes.

Cheers
 
David wrote on Sat, 25 Aug 2007 08:55:31 -0400:

DM> Select cell B2 then use Window (menu), Freeze

DM> For printing: file, Page setup, sheets
DM> rows to repeat at top $1:$1
DM> Columns to repeat at left $A:$A

DM> There is more information on the above page, including
DM> variation for the Excel 2007.
DM> --
DM> HTH,
DM> David McRitchie, Microsoft MVP -- Excel
DM> My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm

DM> message ??>> Hello, All!
??>>
??>> Perhaps I have not woken up properly yet but I have a
??>> sheet that is updated daily and there are several sets of
??>> columns derived from the input values. I sometimes forget
??>> which columns are which and have to go to the top of the
??>> page to find the headings. Is there a simple way to do
??>> this? Should I perhaps best write a macro and assign it to
??>> a button? Ideally,I would like to see the values and the
??>> headings at the same time?
??>>

Thanks to you and macropod! I had no idea that Freeze did that!
As I have said before, no matter how long you've been using a
program, you can always live and learn.

Thanks again!
James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 
Back
Top