A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Floating Column



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2010, 10:48 AM posted to microsoft.public.excel.newusers
Smiffie72
external usenet poster
 
Posts: 5
Default 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  
Old March 6th, 2010, 10:52 AM posted to microsoft.public.excel.newusers
Ben M. Schorr, MVP
external usenet poster
 
Posts: 681
Default 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  
Old March 6th, 2010, 11:00 AM posted to microsoft.public.excel.newusers
Smiffie72
external usenet poster
 
Posts: 5
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:46 PM.


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