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

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!
[email protected]
 
T

T. Valko

Select cell A3
Goto the menu Window>Freeze Panes

Rows 1 & 2 will always be visible

To undo it, Window>Unfeeze Panes
 
Top