Hide and unhided based on the above cell value

[cairo95]

Hello,

I am working on an excel spreadsheet that i would like to automatically unhide the row below if text is entered in the previous row (specific cell). i have up to 12 rows max that i need to unhide when there is a value in the previous row (specified cell). they would unhide as text is placed in the previous specified cell. for example. row 1 would always be visible and when text is entered in the specified cell in row 1, row 2 would unhide and if row 2 (specified cell) has text entered, row 3 will unhide and so on... up to a max of 12 rows....and if the text is removed the row below will hide.

I appreciate any help!

thanks in advance!

Cairo95

 

[Fluff]

Have a look at Centre Across Selection under format cells > Alignment > Horizontal

 

[cairo95]

i found a solution by just changing the reference point to column A which is not merged. when the user enters a number the row below unhides.

thanks again for your help!

Cairo95

 

[Fluff]

You're welcome