How do I make the 1st column constant in viewing a wide spreadshee

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2002. Created a very wide spreadsheet and I can't see the row
headings when I scroll to the right.
 
Place your cursor just to the right of the column you want to be visible and
just below the row that should always remain visible. Now select Window ->
Freeze Panes
 
Select column 2, then go to Windows--Freeze pane and this will freeze the 1st
column on the left.

Dave
 
Perfect! Simple but sweet - thanks!

Jim Thomlinson said:
Place your cursor just to the right of the column you want to be visible and
just below the row that should always remain visible. Now select Window ->
Freeze Panes
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I set column headings up and down rather than across 1
Vertical page breaks - one per column 1
Excel 2007 Is it possible to vary the column width between rows? 3
print spreadsheet 1
AutoFit not working properly 2
Combo Boxes Calculations 4
Freeze Two Columns 3
Spreadsheet 1

Back
Top