Hide rows until certain cell has value.

[FragaGeddon]

Is there a way to hide a certain amount of rows (122:136) when cell R116 has no value, but with not having to enable macros?

 

[dermie_72]

Try this if you choose not to use macro's, the only way I know is is manual.

Quickly Hide Excel Rows and Columns | Contextures Blog

 

[Yahya]

i don't think that
you should use code to do this
becuse you need to check the your cell if it is empty hide, not empty UnHide

 

[FragaGeddon]

Try this if you choose not to use macro's, the only way I know is is manual.

Quickly Hide Excel Rows and Columns | Contextures Blog

Thanks, but I would have liked this to be done manually. It's not for me , but for numerous people.

 

[dermie_72]

if it needs to be done manually, right click on the column, and choose hide.
That's the quickest, non macro way I know how to hide a column,