Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing of cells in Excel with conditional equations?
How do I suppress printing of cells in Excel that have a conditional equation
in the cell and appear as blanks in the worksheet, but when I print I get a blank label. I am setting this up for a user and I don't want them to have to highlight the cells and then use SELECTION in the print parameters? |
#2
|
|||
|
|||
Can you pick out a column that always has data when the row should be
printed--and is always blank when the row should not be printed? If yes, then I'd apply Data|Filter|Autofilter to that range/column. Filter to show just the non-blanks and then print, then data|filter|showall to get it back to show all the data. ====== Saved from a previous post: Another approach... Insert|Name|Define Names in workbook: Sheet1!LastRow Use this formula Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) ) (Make that 1000 big enough to extend past the last possible row.) Then once mo Insert|Name|Define Names in workbook: Sheet1!Print_Area Use this formula Refers to: =OFFSET(Sheet1!$A$1,0,0,lastRow,3) That last 3 represents the last column to print (A:C in my example). And change the worksheet (sheet1) if necessary (in all the places). Mic Kenney wrote: How do I suppress printing of cells in Excel that have a conditional equation in the cell and appear as blanks in the worksheet, but when I print I get a blank label. I am setting this up for a user and I don't want them to have to highlight the cells and then use SELECTION in the print parameters? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Printing in Excel | New Users to Excel | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |