Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Freeze Column

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ManhattanRebel - 03 May 2008 17:46 GMT
Other than the first column, is there a way to freeze other columns in my
excel spread sheet?
cmart02 - 03 May 2008 18:07 GMT
Please, see follow up here:
http://www.msofficegurus.com/forum/forum_posts.asp?TID=1
Signature

Regards
Robert
Find me at  http://www.msofficegurus.com - be part of it!

Rick Rothstein (MVP - VB) - 03 May 2008 18:10 GMT
Your question is not clear to me. Are you asking if you can freeze more than
one column starting with column 1; for example columns 1 through 4? Or are
you asking if you can freeze multiple columns starting with a column number
other than 1; for example columns 4 through 7? Let's answer the last
question first... the answer is no (think about it... what would the screen
look like around the frozen columns as the columns were scrolled... columns
after the frozen columns would be shown to the left of the frozen ones?). As
for the first question, select the first cell you want to still be able to
scroll (both horizontally and vertically) and click Window/Freeze Panes from
the menu bar. The columns to the left and above that cell will be frozen.

Rick

> Other than the first column, is there a way to freeze other columns in my
> excel spread sheet?
ManhattanRebel - 03 May 2008 18:45 GMT
Thank you for the help. I would like to freeze themone column at a time. I
know how to freeze the first column, but I'd like to know how to freeze
others columns one column at a time.

> Your question is not clear to me. Are you asking if you can freeze more than
> one column starting with column 1; for example columns 1 through 4? Or are
[quoted text clipped - 11 lines]
> > Other than the first column, is there a way to freeze other columns in my
> > excel spread sheet?
Rick Rothstein (MVP - VB) - 03 May 2008 18:59 GMT
Maybe this idea will satisfy what you are trying to do. Look at the
horizontal scroll bar at the bottom of your worksheet. To the very right of
the scroll bar is a small (taller than wide) "button" looking thing. Click
and drag it to the left until a vertical bar appears from top to bottom on
your worksheet. You can release the mouse button as soon as you see the
vertical bar. This splits the worksheet into two sections. You can click
drag the vertical bar wherever you want... drag it to the left so that only
one column shows to the left of it. At the bottom of this single column is a
horizontal scroll bar just for that split off pane... scroll it to the
column you want. Now, click in the "main" part of the worksheet to the right
of the vertical bar and work in it as you normally would. When you scroll
the "main" part of the worksheet, the single column section to the left of
the vertical bar won't move. Does that do what you want?

Rick

> Thank you for the help. I would like to freeze themone column at a time. I
> know how to freeze the first column, but I'd like to know how to freeze
[quoted text clipped - 24 lines]
>> > my
>> > excel spread sheet?
Gord Dibben - 03 May 2008 18:10 GMT
No

Freeze Panes works only at top and/or left side of sheet.

Gord Dibben  MS Excel MVP

>Other than the first column, is there a way to freeze other columns in my
>excel spread sheet?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.