Need to print the second sheet only if it is active

L

Lori Mae

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.
 
M

Ms-Exl-Learner

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top