Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headers
I have 7 columns with different titles, when I scroll down the page how do I
keep the titles on top of each column so you can see what you are looking at. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headers
Hi
Select the first cell under your headings, in column A. Go to Window/Freeze Panes. Andy. "Tommy" wrote in message ... I have 7 columns with different titles, when I scroll down the page how do I keep the titles on top of each column so you can see what you are looking at. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headers
"Tommy" wrote in message
... I have 7 columns with different titles, when I scroll down the page how do I keep the titles on top of each column so you can see what you are looking at. Select the row below your titles, Window menu, Freeze panes. You can do the same with rows, columns, or both, just select the top left-hand cell of the scrolling region before you freeze panes. -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headers
I know how to freeze but I need to scroll both the top and bottom
window. Is there a way to change the name on the column tabs A, B, C to Jan. Feb,Mar etc.? ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop column headers from being sorted in a row? | Excel Discussion (Misc queries) | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |