Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a column heading to show up at the top and not move .
How do I get a column heading to show up at the top and not move? I've seen
this before. The row did not move as i scrolled down the page and it printed on each page as if it was a header. Please note that nothing was entered into to header and footer window. Thanks!!!!!!!!!!!!! |
#2
|
|||
|
|||
Hi Need help guy
You can use window -Freeze Panes in the menubar Example : To freeze the first column and Row. Select cell b2 and do window -Freeze Panes If you want to print the first row on each page then go to FilePage Setup, on the sheet tab you can fill in $1:$1 -- Regards Ron de Bruin http://www.rondebruin.nl "Need help guy" <Need help wrote in message ... How do I get a column heading to show up at the top and not move? I've seen this before. The row did not move as i scrolled down the page and it printed on each page as if it was a header. Please note that nothing was entered into to header and footer window. Thanks!!!!!!!!!!!!! |
#3
|
|||
|
|||
Worked great. I had forgoted about having to get one cell below before you
used the freeze pane. I was getting all kind of of blocked panes when I tried it without chooseing a cell. Many thanks from Need a job Guy.......... "Ron de Bruin" wrote: Hi Need help guy You can use window -Freeze Panes in the menubar Example : To freeze the first column and Row. Select cell b2 and do window -Freeze Panes If you want to print the first row on each page then go to FilePage Setup, on the sheet tab you can fill in $1:$1 -- Regards Ron de Bruin http://www.rondebruin.nl "Need help guy" <Need help wrote in message ... How do I get a column heading to show up at the top and not move? I've seen this before. The row did not move as i scrolled down the page and it printed on each page as if it was a header. Please note that nothing was entered into to header and footer window. Thanks!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Renaming a column or heading? | Excel Worksheet Functions | |||
hide column but show chart | Charts and Charting in Excel | |||
How do I set up a column with a heading and a subheading? | Excel Discussion (Misc queries) | |||
Formula to reference column heading | Excel Worksheet Functions |