Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select cell A3
Goto the menu WindowFreeze Panes Rows 1 & 2 will always be visible To undo it, WindowUnfeeze Panes -- Biff Microsoft Excel MVP "WalMatt23" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make it 12 rows from 1 row | Excel Worksheet Functions | |||
how can i make spreadsheet have fewer rows | Excel Discussion (Misc queries) | |||
How can I make the rows go into a random order? | Excel Worksheet Functions | |||
how do I make the first three rows repeat on top of every page? | New Users to Excel | |||
Make a Macro take out rows and add it to new worksheet | Excel Discussion (Misc queries) |