| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how to print cells based on "Yes".
If the first cell in row 1 of Column "A" is "Yes", how do I get preselected
contiguous or non contiguous cells in the same row to print? If the answer is "no", I do not want cells in that row to print. Thanks for anyones help! Francis Knight |
|
#2
|
|||
|
|||
|
how to print cells based on "Yes".
Hi Francis
You can use DataAutoFilter to filter on that column and print. Only the visible cells will print -- Regards Ron de Bruin http://www.rondebruin.nl "Francis Knight" <Francis wrote in message ... If the first cell in row 1 of Column "A" is "Yes", how do I get preselected contiguous or non contiguous cells in the same row to print? If the answer is "no", I do not want cells in that row to print. Thanks for anyones help! Francis Knight |
|
#3
|
|||
|
|||
|
how to print cells based on "Yes".
check out the conditional formatting
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| can I print selected cells only within a worksheet | New Users to Excel | |||
| Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
| how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
Hybrid Mode
