If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Floating Column
Hi,
I'm making a speadsheet of my shifts over the next year. I've put the days at the top but would like the column to scroll down with the page. How do you do this? Thanks |
#2
|
|||
|
|||
Floating Column
Place your cursor in the cell below that header row and then Freeze Panes.
How depends a bit on your version of Excel - you could search the Help File for Freeze Panes though. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com/outlook.html Author: The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/ol4law-amazon "Smiffie72" wrote in message ... Hi, I'm making a speadsheet of my shifts over the next year. I've put the days at the top but would like the column to scroll down with the page. How do you do this? Thanks |
#3
|
|||
|
|||
Floating Column
Can't believe how easy that was!!! Been searching for ages! Thanks
"Ben M. Schorr, MVP" wrote: Place your cursor in the cell below that header row and then Freeze Panes. How depends a bit on your version of Excel - you could search the Help File for Freeze Panes though. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com/outlook.html Author: The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/ol4law-amazon "Smiffie72" wrote in message ... Hi, I'm making a speadsheet of my shifts over the next year. I've put the days at the top but would like the column to scroll down with the page. How do you do this? Thanks |
Thread Tools | |
Display Modes | |
|
|