Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freeze Multiple Rows
I want to freeze my 1st row (ex:Column Headings) and last row (ex:Column
Totals) of my worksheet so they are always in view - Is this possible? Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freeze Multiple Rows
Not possible. You can freeze rows/columns only on the top and on the
left. You can't freeze on the right or bottom. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 20 Jan 2009 12:59:01 -0800, Desk_Jockey_03 wrote: I want to freeze my 1st row (ex:Column Headings) and last row (ex:Column Totals) of my worksheet so they are always in view - Is this possible? Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freeze Multiple Rows
With a little vertical thinking ! A possible workround:
Insert a blank row under your 1st row (which then becomes row 2) place a simple formula in each cell of row 2 linking to your last row (e.g. =A50) Then freeze the first two rows. Hence you will always be able to see your Headings and Totals. Hope this helps "Chip Pearson" wrote: Not possible. You can freeze rows/columns only on the top and on the left. You can't freeze on the right or bottom. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 20 Jan 2009 12:59:01 -0800, Desk_Jockey_03 wrote: I want to freeze my 1st row (ex:Column Headings) and last row (ex:Column Totals) of my worksheet so they are always in view - Is this possible? Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze multiple rows/columns in Excel 2007 | Excel Discussion (Misc queries) | |||
How to Freeze Multiple Rows/Columns | Excel Discussion (Misc queries) | |||
how to freeze rows | Excel Discussion (Misc queries) | |||
Freeze first and last rows | Excel Worksheet Functions | |||
Can I freeze multiple rows? | Excel Discussion (Misc queries) |