Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Need help guy
 
Posts: n/a
Default 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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Need Help guy
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add a column to a pivot table that would show the difference between 2 other Columns [email protected] Excel Worksheet Functions 7 January 30th 05 05:21 PM
Renaming a column or heading? notanexpertinexcel Excel Worksheet Functions 1 January 25th 05 01:20 AM
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 09:49 AM
How do I set up a column with a heading and a subheading? Chelle21 Excel Discussion (Misc queries) 1 November 29th 04 09:08 PM
Formula to reference column heading JimDandy Excel Worksheet Functions 1 November 17th 04 04:06 PM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"