How can i make it so i can always see the first 2 rows?

  • Thread starter Thread starter WalMatt23
  • Start date Start date
W

WalMatt23

I am creating a huge database, with 10,000+ entries. There are 7 columns and
it is easy to mistake which column is which because only the first 2 rows of
the data base are labeled.

Is there a setting that I can change to make it so that as I am entering
data, i can see what these labels are without having to scroll to the very
top?

Any help is appreciated!

Thanks!
(e-mail address removed)
 
Select cell A3
Goto the menu Window>Freeze Panes

Rows 1 & 2 will always be visible

To undo it, Window>Unfeeze Panes
 
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

Editing a list of names that have numbers- Can i take out the numb 7
Deleting rows containing zeros 2
Excel Help to copy information from one row at a time to another sheet 1
printing mailing labels when data is in rows 3
Conditional SUBTOTAL in XL210 Table 7
Making first row Fixed/Static 2
Office 2007 Pivot Table Display format - Show row headings in each 1
Finding the next record in a column 2

Back
Top