Microsoft Office Forums

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: 7
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, 5 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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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's Avatar
p45cal p45cal is offline 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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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: 7
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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 PM.


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