Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When printing in Excel, I get 5 extra blank pages.
They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Go to File | Page Setup | Sheet tab and you can see the print area
defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you Pete
What I did was highlight the area I wanted to print, then right clicked and selected print area and it got rid of the extra pages. "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you can see the print area defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for feeding back.
Pete On Jul 25, 8:52 pm, Ricochet wrote: Thank you Pete What I did was highlight the area I wanted to print, then right clicked and selected print area and it got rid of the extra pages. "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you can see the print area defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages?- Hide quoted text - - Show quoted text - |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
Apparently this thread is old but I do have an issue which is realted to this and of highg importance. I think this should be able to fix in a simple way. I'm creating a template which could be used of colegues of mine. In this template I'm currently not sure wich pages that will be empty (no data, lines or colour at all). This pages should automaticly not be printed. I hope this could be fixed by a simple setting under "Print settings" such as "do not print empty pages in the priniting range" but I can not find such choise. Happy for a solution. Regards Mathias "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you can see the print area defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What happens if you reset the print range so that excel determines what to
print? Usually excel is smart enough to only print the used area. Mathias wrote: Hi! Apparently this thread is old but I do have an issue which is realted to this and of highg importance. I think this should be able to fix in a simple way. I'm creating a template which could be used of colegues of mine. In this template I'm currently not sure wich pages that will be empty (no data, lines or colour at all). This pages should automaticly not be printed. I hope this could be fixed by a simple setting under "Print settings" such as "do not print empty pages in the priniting range" but I can not find such choise. Happy for a solution. Regards Mathias "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you can see the print area defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? -- Dave Peterson |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Mathias i have same problm..... My question is that how can we CONFIGURE
automatic page break in excel 2003, or how can we configure page break for row or column to get prineted when new data will entred in formulated fileds??? Automatic page break( Default ) is not working and manual page break is not the permnt solution... while you are handling huge data..... kindly rply soon if any excel wiz is here!!!!!!!!!!!!!!!!!!!!!!!!! :( "Dave Peterson" wrote: What happens if you reset the print range so that excel determines what to print? Usually excel is smart enough to only print the used area. Mathias wrote: Hi! Apparently this thread is old but I do have an issue which is realted to this and of highg importance. I think this should be able to fix in a simple way. I'm creating a template which could be used of colegues of mine. In this template I'm currently not sure wich pages that will be empty (no data, lines or colour at all). This pages should automaticly not be printed. I hope this could be fixed by a simple setting under "Print settings" such as "do not print empty pages in the priniting range" but I can not find such choise. Happy for a solution. Regards Mathias "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you can see the print area defined - just edit this to suit the size of your data. Hope this helps. Pete On Jul 25, 8:18 pm, Ricochet wrote: When printing in Excel, I get 5 extra blank pages. They are also in the print preview. I've tried deleting rows and columns. How do I delete the extra pages? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I delete extra (blank) pages in excel??? | Excel Discussion (Misc queries) | |||
How to prevent extra blank pages from printing? | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
How do I delete extra blank pages from an excel worksheet? | Excel Worksheet Functions | |||
How do I delete extra blank pages at end of doc...only show when. | Excel Discussion (Misc queries) |