#1
|
|||
|
|||
Locking the bottom couple rows on a screen
HI folks:
I have a budget spreadsheet that has the top rows frozen using the built in command, as it turns out, I need more rows than fit between the top edge of the screen, and bottom row which has totals. I would love to be able to freeze the bottom row like the top row is so that the cells between the 2 scroll, but the top and bottom stay put. Is this possible? Attached is a blank copy of the workbook Thanks TIM |
#2
|
|||
|
|||
Why anybody wants totals at bottom?
Put them above table headers, and lock both totals and headers! And add new rows to table as much as you want. When you want to get them at bottom for printout, create a footer, read totals into footer from totals in top of sheet, and define print area which excludes totals row at top of sheet. (I don't remember, was there an option to print footer at last sheet. Or can you define the print area which includes 2 ranges of cells or not?) |
#3
|
||||
|
||||
I found no easy way to do this, trying a combination of splitting and freezing - no go.
A cumbersome solution is to add a new window of the same sheet and position it below as a thin strip and work on the top window. Couldn't upload a picture successfully to this site so a link instead: Box I'll try embedding too: |
#4
|
|||
|
|||
Thanks folks, I set that up and it works great
TIM |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need with couple things | Moot70 | Excel | 0 | 11-14-2019 08:12 PM |
New Monitor: Print Preview Screen On Left Side of Screen, Not Centered | tatihulot | Word | 1 | 09-11-2013 02:47 AM |
Word Issue, bottom of document is showing on the screen several times. | TerryBlevins | Word | 1 | 12-21-2011 12:58 AM |
A couple of questions | Huge | Excel | 2 | 06-07-2011 07:51 AM |
Semi-flexible templates (couple of questions) | mshanks | Word | 1 | 07-29-2009 06:35 AM |