How to only print cells where there is data entered, as in a sched

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please does anyone know if it is possible to print selective cells
automatically as in schedule employees for a certain day? I have an employee
list of about 65 and would like an enlarged printout showing just the
scheduled employees each day and their hours. Any ideas? I'm using Excel
2003. I'd rather not have to buy another or add-in program.
 
Cel

Have you tried to see what an Autofilter can do for you?

Perhaps filter just for that particular day.

You can print the results then remove the filter.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Lock cells conditionally formatted in 2007 1
extracting names 7
Best way to pull data from several different sheets into a summary sheet 2
How do I sum color filled cells in Excel with no values or text? 2
Ensure data entered where required - how, please? 3
How can I make Excel recognize a time period 3
How To Clear Previous Selection From a Drop Down 2
Possible to make certain cells default to 0? 6

Back
Top