Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the Data Range and give Cntrl+P and check the [Selection] Option
Button Under the [Print What] heading and give Ok... While selecting the data range and printing the selection only will let excel to print the sheets which is having the data. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Lori Mae" wrote: I have a two page excel worksheet, I always want the first page to print, but if there is a lot of information and the second sheet becomes active, I want that to print as well. But only if it is active. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill out worksheet and only print active sheet | Excel Worksheet Functions | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
print and print preview not active in file drop down | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
automatically PRINT only active cells? | Excel Discussion (Misc queries) |