Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to only print cells where there is data entered, as in a sched
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. |
#2
|
|||
|
|||
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 On Tue, 19 Apr 2005 13:43:02 -0700, Cel wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |