Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i make it so i can always see the first 2 rows?
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
|
|||
|
|||
How can i make it so i can always see the first 2 rows?
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 | |
|
|
Similar Threads | ||||
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) |