ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i omit rows for printing based on column value (https://www.excelbanter.com/excel-discussion-misc-queries/81549-how-do-i-omit-rows-printing-based-column-value.html)

haloprod

how do i omit rows for printing based on column value
 
excel 2003 how do i omit a row from printing based on a value i put in a
column?

Peo Sjoblom

how do i omit rows for printing based on column value
 
You can't, the closest you would get would be to use a filter, otherwise you
would need VBA
There is another way using conditional formatting but it will still print
that row albeit with invisible
text

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"haloprod" wrote in message
...
excel 2003 how do i omit a row from printing based on a value i put in a
column?




All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com