#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Maybe formatting the data as a TABLE? Then the print range would reflect the table, rather than cell references.
|
Tags |
dynamic print range |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Take String of numbers, expand ranges, sort, then compress back into ranges | AustinBrister | Word VBA | 19 | 08-22-2016 05:18 PM |
Populating ranking depending upon ranges of previous cell's data | sryder | Excel | 5 | 04-07-2016 03:37 PM |
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 |
Problem with have a chart with different data ranges | expert4knowledge | Excel | 2 | 09-09-2014 06:27 AM |