Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2016, 12:17 PM
TheThack TheThack is offline Ranges that Grow Based on Data Windows 7 32bit Ranges that Grow Based on Data Office 2013
Novice
Ranges that Grow Based on Data
 
Join Date: Jul 2016
Posts: 1
TheThack is on a distinguished road
Post Ranges that Grow Based on Data


I previously created a spreadsheet in Excel 2010 that allowed me create a default range for printing. This range grew as I added new rows of data into the spreadsheet so that each time I added new data and clicked the print icon, only rows through the last row plus one additional blank row are printed. Unfortunately, I cannot figure out how I created this dynamic range. Any help would be appreciated.
Reply With Quote
  #2  
Old 07-27-2016, 11:36 AM
candybg candybg is offline Ranges that Grow Based on Data Windows 7 64bit Ranges that Grow Based on Data Office 2010 64bit
Novice
 
Join Date: May 2016
Posts: 9
candybg is on a distinguished road
Default

Maybe formatting the data as a TABLE? Then the print range would reflect the table, rather than cell references.
Reply With Quote
Reply

Tags
dynamic print range



Similar Threads
Thread Thread Starter Forum Replies Last Post
Ranges that Grow Based on Data Take String of numbers, expand ranges, sort, then compress back into ranges AustinBrister Word VBA 19 08-22-2016 05:18 PM
Ranges that Grow Based on Data Populating ranking depending upon ranges of previous cell's data sryder Excel 5 04-07-2016 03:37 PM
Ranges that Grow Based on Data Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM
Retrieving data from data base based on text selection capitala PowerPoint 0 12-10-2014 08:10 AM
Ranges that Grow Based on Data Problem with have a chart with different data ranges expert4knowledge Excel 2 09-09-2014 06:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 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