Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
select rows to print where there's data in specific column
In the process of building a house, I developed a spreadsheet showing each
room on the Y-axis and each trade eg Electric, plumbing etc as columns, with the features for each room eg light fixtures, faucets enterd in the respective columns. I now would like to select and print for each trade, their respective part's list by room and eliminate all the blank cells in the electric column. In other words, how do I select only the rows where there is data in the electric column's cells, and print this report for the electrician? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
select rows to print where there's data in specific column
Hi,
Will selecting the electrician's column, then going Data|Filter|AutoFilter then click the Autofilter's Down arrow and selecting NonBlanks do what you want. Also, before you print, select the electrician's cells, then go File|Print Area|Set Print Area, then only those cells will print. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Select Rows dependant on certain field data | New Users to Excel | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |