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
|
|||
|
|||
Freeze Column
Other than the first column, is there a way to freeze other columns in my
excel spread sheet? |
#2
|
|||
|
|||
Freeze Column
Please, see follow up he
http://www.msofficegurus.com/forum/f...osts.asp?TID=1 -- Regards Robert Find me at http://www.msofficegurus.com - be part of it! |
#3
|
|||
|
|||
Freeze Column
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 "ManhattanRebel" wrote in message ... Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
#4
|
|||
|
|||
Freeze Column
No
Freeze Panes works only at top and/or left side of sheet. Gord Dibben MS Excel MVP On Sat, 3 May 2008 09:46:01 -0700, ManhattanRebel wrote: Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
#5
|
|||
|
|||
Freeze Column
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. "Rick Rothstein (MVP - VB)" wrote: 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 "ManhattanRebel" wrote in message ... Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
#6
|
|||
|
|||
Freeze Column
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 "ManhattanRebel" wrote in message ... 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. "Rick Rothstein (MVP - VB)" wrote: 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 "ManhattanRebel" wrote in message ... Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
#7
|
|||
|
|||
Freeze Column
In Microsoft 2007,
I usually do this. In the 'View' tab, select "Split." A bar will appear in the middle which can be moved left or right. This will create a duplicate of your spreadsheet. BUT WAIT! It's not a regular copy. If you make an edit on one side, the edit automatically edits the other side. So you don't have to worry about more than one document. Now you can drag the split where you want. This will allow the right side to be scrollable while the left side of the split stays visible. Say you want to hide a column, select it, and right click hide. Hope that helps! "ManhattanRebel" wrote: Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
#8
|
|||
|
|||
Freeze Column
To the OP
You can use Freeze Panes wherever you like on a sheet. Place the cursor in the cell below the first row you wish to freeze, and to the right of the first column you want to freeze, before selecting Freeze panes. -- Regards Roger Govier Ric in Tx wrote: In Microsoft 2007, I usually do this. In the 'View' tab, select "Split." A bar will appear in the middle which can be moved left or right. This will create a duplicate of your spreadsheet. BUT WAIT! It's not a regular copy. If you make an edit on one side, the edit automatically edits the other side. So you don't have to worry about more than one document. Now you can drag the split where you want. This will allow the right side to be scrollable while the left side of the split stays visible. Say you want to hide a column, select it, and right click hide. Hope that helps! "ManhattanRebel" wrote: Other than the first column, is there a way to freeze other columns in my excel spread sheet? |
Thread Tools | |
Display Modes | |
|
|