| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing second page if data overruns, otherwise print first page
I have a layout on a spreadsheet which pulls data from other source
depending on the user's input, and then needs to be printed. Most of the time this data will fit on to one print page, howeve occasionally the data will overrun to a second page. The question is, how do I get the second page to print only when ther is data in a specific cell? Thanks playdohstu (Windows 2000, Excel 2000 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing second page if data overruns, otherwise print first page
Why not use fit to print and fit it to one page.
-- Regards, Tom Ogilvy "playdohstu " wrote in message ... I have a layout on a spreadsheet which pulls data from other sources depending on the user's input, and then needs to be printed. Most of the time this data will fit on to one print page, however occasionally the data will overrun to a second page. The question is, how do I get the second page to print only when there is data in a specific cell? Thanks playdohstu (Windows 2000, Excel 2000) --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does text on page 3 not display in print preview and printing | Excel Discussion (Misc queries) | |||
| Printing On One Page Using Print-Area | Excel Discussion (Misc queries) | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| Printing Page Numbers: 1 Spreadsheet print pg #'s on several copie | Excel Worksheet Functions | |||
| How can I print repeating rows on every page when printing? | Excel Discussion (Misc queries) | |||
Linear Mode
