info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help on how to automatically un-hide Rows
17 views
Skip to first unread message
Andy McNicol
Jan 19, 2021, 8:06:53 AM1/19/21
to
Hoping one of you Excel Guru's will be able to help with the following problem;
I have a spreadsheet with around 500 rows of that can over time be populated with data. Each row contains a mix of formulas, lists and free text. What I want to do is only show those rows that have data in them and maybe an additional 10 empty rows. Now I can hide the excess rows by using the Hide function which is easy enough, however want the 10 empty rows to be a constant as such how do i get it to automatically un-hide the next row once data is entered into the first of the 10 so that I keep the formulas and such intact.
Anyway any help would be appreciated as having a mind melt here.
Andy
I have a spreadsheet with around 500 rows of that can over time be populated with data. Each row contains a mix of formulas, lists and free text. What I want to do is only show those rows that have data in them and maybe an additional 10 empty rows. Now I can hide the excess rows by using the Hide function which is easy enough, however want the 10 empty rows to be a constant as such how do i get it to automatically un-hide the next row once data is entered into the first of the 10 so that I keep the formulas and such intact.
Anyway any help would be appreciated as having a mind melt here.
Andy
0 new messages