Is it possible to unhide row based on cell content?

**Rutgerson** · 05-10-2012, 01:23 PM

Hello!

Im creating a balance sheet for my little company, and i was wondering if its possible to unhide a row based on a cells content?

In Norway, you're allowed to use Excel for official financial statements if you don't have more than 300 annual transactions.

Needless to say, displaying 200+ empty rows at any given time before the summary will only cause mousewheel fatigue

I've already created lots of formula, and column A will autogenerate a transaction reference number as soon as you fill in the date in column B.

What I want is for the next row to display (unhide) as soon as the previous row contains a value in column A. I.E, you fill in the transaction info in row 3, row 4 will automatically be unhidden.

This way, I'll be able to hide 290 of the 300 content rows at the beginning of each year, and the sheet will expand on demand.

Any help will be appreciated, even if it requires macros (though, i was hoping to avoid that for compatibility reasons).

**arlu1201** · 05-10-2012, 01:44 PM

I guess macro is the only solution you have for this kind of request. Do you have a sample file that you can upload?

**Rutgerson** · 05-10-2012, 01:55 PM

That i do, check the attached item here

**arlu1201** · 05-10-2012, 02:03 PM

Since you have already hidden the required rows at the beginning, this is easy. Just right click on the sheet where you need this functionality and paste this code. It will unhide as soon as a date is entered. I used column B, since column A automatically gets a value based on column B.

Please Login or Register  to view this content.

**Rutgerson** · 05-10-2012, 02:19 PM

Okay, this is why I wanted to avoid macros, because I don't feel comfortable in how to add them

Care to help me along? Or re-upload the sample file so i can reverse engineer it?

**arlu1201** · 05-10-2012, 02:22 PM

Its very simple. If you want to add the code to the 2012 sheet, just right click on it and copy and paste the above code into the blank screen on the right hand side. Then save your file and go back to your 2012 sheet. Just start entering data in the last visible row for e.g. row 32 and row 33 will be visible.