Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hiding rows
is there a way to hide rows that have a certain character in that row.
example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other than "-" later it would unhide the row. a guy at work said this wasn't possible. without programing. I don't know that much about VBA. So if that is the only way I guess I will have to learn Thanks in advance |
#2
|
|||
|
|||
It is very clunky but, you can highlight the Column then select Data
Filter Autofilter click on the arrowhead and then select (Custom ...) Click on the arrowhead of the top left box and select does not equal and put a dash in the other top box then click OK. To unhide the row after entering data you have to re-apply the Custom Autofilter again, (I said that it was clukky!) This will not work if the "-" is being entered because the cell is formatted as Currency Otherwise get a good book on VBA. -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Lee" wrote in message ... is there a way to hide rows that have a certain character in that row. example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other than "-" later it would unhide the row. a guy at work said this wasn't possible. without programing. I don't know that much about VBA. So if that is the only way I guess I will have to learn Thanks in advance |
#3
|
|||
|
|||
You could apply data|filter|Autofilter to that column.
Then filter by that column (click the downarrow) and choose custom (scroll down the list) does not contain - And you'll see just the cells that don't have dashes. Then to see everything: data|filter|show all (or click the arrow and choose (all)) The autofilter stuff is really a nice way to see your data. I'd select the whole range and apply to all the columns. Lee wrote: is there a way to hide rows that have a certain character in that row. example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other than "-" later it would unhide the row. a guy at work said this wasn't possible. without programing. I don't know that much about VBA. So if that is the only way I guess I will have to learn Thanks in advance -- Dave Peterson |
#4
|
|||
|
|||
You could use an AutoFilter to hide the rows with hyphens. However, you would
have to reapply the AutoFilter to update the results -- it doesn't automatically adjust if the list items change. There's information on AutoFilter in Excel's Help, and he http://www.contextures.com/xlautofilter01.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Lee" wrote: is there a way to hide rows that have a certain character in that row. example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other than "-" later it would unhide the row. a guy at work said this wasn't possible. without programing. I don't know that much about VBA. So if that is the only way I guess I will have to learn Thanks in advance |
#5
|
|||
|
|||
I what to hide the entire row not the column.
"Lee" wrote: is there a way to hide rows that have a certain character in that row. example B1 1 - - 4 5 The rows with a "-" gets hidden and if the cell gets data other than "-" later it would unhide the row. a guy at work said this wasn't possible. without programing. I don't know that much about VBA. So if that is the only way I guess I will have to learn Thanks in advance |
#6
|
|||
|
|||
Lee" wrote in message
... I what to hide the entire row not the column. All three answers will hide the row not the column. Did you try them? -- Rrgards Sandy Replace@mailinator with @tiscali.co.uk |
#7
|
|||
|
|||
I haven't tried them yet, I printed them out and will try them Monday at work.
"Sandy Mann" wrote: Lee" wrote in message ... I what to hide the entire row not the column. All three answers will hide the row not the column. Did you try them? -- Rrgards Sandy Replace@mailinator with @tiscali.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Hiding rows before printing | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |