 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007hiding rows
I want to find a quick way to hide various rows in a spreadsheet that contain zero values. i.e. below example i want to hide the whole row 'oranges' sales apples 100 pears 200 oranges 0 bananas 30 I have quite a lot of rows that may need hiding and any help would be appreciated, thanks. data>filter>autofilter  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I want to find a quick way to hide various rows in a spreadsheet that >contain [quoted text clipped - 9 lines] > I have quite a lot of rows that may need hiding and any help would be > appreciated, thanks. Thanks for that Don, but what if you have multiple areas in a spreadsheet for instance sales, costs, and overheads. You cannot filer multiple selections in a sheet. > I want to find a quick way to hide various rows in a spreadsheet that contain > zero values. i.e. below example i want to hide the whole row 'oranges' [quoted text clipped - 8 lines] > I have quite a lot of rows that may need hiding and any help would be > appreciated, thanks. Another example perhaps or send me a workbook. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Thanks for that Don, but what if you have multiple areas in a spreadsheet > for [quoted text clipped - 15 lines] >> I have quite a lot of rows that may need hiding and any help would be >> appreciated, thanks. example. . . sales apples 100 bananas 50 pears 0 oranges 10 (another section of sheet - few rows down from the above) costs staff 75 materials 10 phone costs 0 light cost 5 i am after hiding the zero values for sales aswell as the costs, thanks Don. > Another example perhaps or send me a workbook. > [quoted text clipped - 17 lines] > >> I have quite a lot of rows that may need hiding and any help would be > >> appreciated, thanks. Then why can't you just filter by 0 and sales?? SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > example. . . > [quoted text clipped - 37 lines] >> >> I have quite a lot of rows that may need hiding and any help would be >> >> appreciated, thanks. If you still can't get it, send me a workbook with an explanation. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > > Then why can't you just filter by 0 and sales?? [quoted text clipped - 40 lines] >>> >> I have quite a lot of rows that may need hiding and any help would be >>> >> appreciated, thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.