hide a row

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

if I have a worksheet with two columns A and B. and there is no information
in Column B I would like to leave it. If there is information in Column B,
I would like to hide the row.

Column A Column B

ABC
DEF CCC I would like to hide this row.

Is this possable. thanks for any help.
 
Hi
only possible with VBA but not with formulas. But why not use a filter
'Data - Filter - Autofilter' for this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
How to write a macro to hide an entire row 9
Paste in column B using Last row of either column B, C or D. 10
Macro to hide colums with value of zero or blank 3
hiding blank rows 3
Hiding rows where text not entered to right of colums A and B 1
Rearrange sheet data 3
convert columns to rows 6

Back
Top