| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can the title of columns be stationary?
I have a work sheet with 255 rows and 12 columns. The users have to check
certain data from the work sheet by looking up some numbers in the certain columns and rows. It is difficult to locate the correct column if the information fall in the lower rows as the users have to scroll up to see the title of column before x-checking the data on a row. Is there a macro or vba to make the title of columns stay in the same location on the screen even when we scroll down so that viewers have the titles in front of them at all time? Thanks for any comments. Dori |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can the title of columns be stationary?
click row 2 to select the entire row (assuming the title is in row 1)
click window menu and then freeze panes -- Gary "DORI" wrote in message ... I have a work sheet with 255 rows and 12 columns. The users have to check certain data from the work sheet by looking up some numbers in the certain columns and rows. It is difficult to locate the correct column if the information fall in the lower rows as the users have to scroll up to see the title of column before x-checking the data on a row. Is there a macro or vba to make the title of columns stay in the same location on the screen even when we scroll down so that viewers have the titles in front of them at all time? Thanks for any comments. Dori |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can the title of columns be stationary?
Hi Gary,
I learn some thing new every day. Thank you very much for the tip. Dori "Gary Keramidas" wrote: click row 2 to select the entire row (assuming the title is in row 1) click window menu and then freeze panes -- Gary "DORI" wrote in message ... I have a work sheet with 255 rows and 12 columns. The users have to check certain data from the work sheet by looking up some numbers in the certain columns and rows. It is difficult to locate the correct column if the information fall in the lower rows as the users have to scroll up to see the title of column before x-checking the data on a row. Is there a macro or vba to make the title of columns stay in the same location on the screen even when we scroll down so that viewers have the titles in front of them at all time? Thanks for any comments. Dori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I title columns with out them having a row number? | Excel Discussion (Misc queries) | |||
| Need title separated into 2 columns | Excel Discussion (Misc queries) | |||
| Scroll two columns on right while left is stationary | Excel Discussion (Misc queries) | |||
| columns title | Excel Discussion (Misc queries) | |||
| how do i title columns | New Users to Excel | |||
Hybrid Mode
