Microsoft Office Forums Locking the bottom couple rows on a screen

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2019, 05:03 AM
taholmes160 taholmes160 is offline Locking the bottom couple rows on a screen Windows 10 Locking the bottom couple rows on a screen Office 2019
Novice
Locking the bottom couple rows on a screen
 
Join Date: Jan 2019
Location: Lester Ohio
Posts: 5
taholmes160 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Blank Budget book.xlsx (17.8 KB, 1 views)
Reply With Quote
  #2  
Old 11-26-2019, 07:52 AM
ArviLaanemets ArviLaanemets is offline Locking the bottom couple rows on a screen Windows 8 Locking the bottom couple rows on a screen Office 2016
Expert
 
Join Date: May 2017
Posts: 508
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about
Default

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?)
Reply With Quote
  #3  
Old 11-26-2019, 08:07 AM
p45cal p45cal is online now Locking the bottom couple rows on a screen Windows 10 Locking the bottom couple rows on a screen Office 2019
Expert
 
Join Date: Apr 2014
Posts: 313
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

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:
Reply With Quote
  #4  
Old 11-26-2019, 05:02 PM
taholmes160 taholmes160 is offline Locking the bottom couple rows on a screen Windows 10 Locking the bottom couple rows on a screen Office 2019
Novice
Locking the bottom couple rows on a screen
 
Join Date: Jan 2019
Location: Lester Ohio
Posts: 5
taholmes160 is on a distinguished road
Default

Thanks folks, I set that up and it works great
TIM
Reply With Quote
Reply

Thread Tools
Display Modes


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
Locking the bottom couple rows on a screen Word Issue, bottom of document is showing on the screen several times. TerryBlevins Word 1 12-21-2011 12:58 AM
Locking the bottom couple rows on a screen 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


All times are GMT -7. The time now is 12:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft