| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
scrolling columns behind previous columns
I'm able to hide rows behind the top row when scrolling a page by using the
Freeze Pane command, but can I also have columns hide behind previous columns at the same time? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
scrolling columns behind previous columns
Go one cell down, and one cell right, from where you want to freeze:
http://www.ozgrid.com/Excel/freeze-panes.htm 2007 (same thing): http://spreadsheets.about.com/od/exc...freezepane.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "gfw" wrote: I'm able to hide rows behind the top row when scrolling a page by using the Freeze Pane command, but can I also have columns hide behind previous columns at the same time? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
scrolling columns behind previous columns
Go one cell down, and one cell right, from where you want to freeze:
http://www.ozgrid.com/Excel/freeze-panes.htm 2007 (same thing): http://spreadsheets.about.com/od/exc...freezepane.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "gfw" wrote: I'm able to hide rows behind the top row when scrolling a page by using the Freeze Pane command, but can I also have columns hide behind previous columns at the same time? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
scrolling columns behind previous columns
Go one cell down, and one cell right, from where you want to freeze:
http://www.ozgrid.com/Excel/freeze-panes.htm 2007 (same thing): http://spreadsheets.about.com/od/exc...freezepane.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "gfw" wrote: I'm able to hide rows behind the top row when scrolling a page by using the Freeze Pane command, but can I also have columns hide behind previous columns at the same time? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
scrolling columns behind previous columns
The freezing rule is.............
All columns left of and all rows above the pre-selected cell will remain frozen when you WindowFreeze Panes. Select C3 to freeze columns A and B and rows 1 and 2 Gord Dibben MS Excel MVP On Fri, 23 Oct 2009 13:48:05 -0700, gfw wrote: I'm able to hide rows behind the top row when scrolling a page by using the Freeze Pane command, but can I also have columns hide behind previous columns at the same time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Losing previous highlighted columns when doing multiple column hi. | Excel Worksheet Functions | |||
| How to keep title of columns in view when scrolling | Excel Discussion (Misc queries) | |||
| keep a group of row/columns scrolling up or down? | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
Linear Mode
