Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying all rows, printing only certain rows
Hi,
I have a sheet that is printed out on a daily basis which is basically a list of tasks to do. Some of the tasks only run on certain days and not others, some tasks are done everyday. Basically what I would like to do is when the worksheet is open on screen, it displays all rows for editing etc, but when I print the worksheet out, it only prints rows relevant for that day and hides the rows not relevant. Any help would be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying all rows, printing only certain rows
I think I'd apply Data|Filter|autofilter to that range.
Then right before I print filter on the date column to show just the dates in which I'm interested. Then print those visible rows and then data|Filter|showall to see everything after the print. GLT wrote: Hi, I have a sheet that is printed out on a daily basis which is basically a list of tasks to do. Some of the tasks only run on certain days and not others, some tasks are done everyday. Basically what I would like to do is when the worksheet is open on screen, it displays all rows for editing etc, but when I print the worksheet out, it only prints rows relevant for that day and hides the rows not relevant. Any help would be greatly appreciated. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying all rows, printing only certain rows
Hi Dave,
yes thats what I wound up doing, adding an extra column and then running an auto filter - is there a way to set this up so that it hides a column, prints the document, then unhides it again? "Dave Peterson" wrote: I think I'd apply Data|Filter|autofilter to that range. Then right before I print filter on the date column to show just the dates in which I'm interested. Then print those visible rows and then data|Filter|showall to see everything after the print. GLT wrote: Hi, I have a sheet that is printed out on a daily basis which is basically a list of tasks to do. Some of the tasks only run on certain days and not others, some tasks are done everyday. Basically what I would like to do is when the worksheet is open on screen, it displays all rows for editing etc, but when I print the worksheet out, it only prints rows relevant for that day and hides the rows not relevant. Any help would be greatly appreciated. Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying all rows, printing only certain rows
How about sticking that column in Column A.
Then use file|Page setup|sheet tab to specify your range--and don't include column A. (You could also put it to the right, too) But if you want, you could have a macro that hides the column, prints the sheet, and unhides the column: Option Explicit Sub testme03() With Worksheets("sheet2") .Range("e1").EntireColumn.Hidden = True .PrintOut preview:=True .Range("e1").EntireColumn.Hidden = False End With End Sub (I used preview:=true to save a few trees while testing.) GLT wrote: Hi Dave, yes thats what I wound up doing, adding an extra column and then running an auto filter - is there a way to set this up so that it hides a column, prints the document, then unhides it again? "Dave Peterson" wrote: I think I'd apply Data|Filter|autofilter to that range. Then right before I print filter on the date column to show just the dates in which I'm interested. Then print those visible rows and then data|Filter|showall to see everything after the print. GLT wrote: Hi, I have a sheet that is printed out on a daily basis which is basically a list of tasks to do. Some of the tasks only run on certain days and not others, some tasks are done everyday. Basically what I would like to do is when the worksheet is open on screen, it displays all rows for editing etc, but when I print the worksheet out, it only prints rows relevant for that day and hides the rows not relevant. Any help would be greatly appreciated. Thanks. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Printing only certain rows | Excel Discussion (Misc queries) | |||
Printing Frozen Rows | Excel Discussion (Misc queries) |