Dynamically Hide Rows Without Filters or Macros

[Corim Danex]

Is there a way in Excel to have a field where you type in a number of rows desired in a field, with a maximum of say 200, and those rows exist with formulas, but all but the number of desired rows will be hidden?

Like if I choose 30, rows 31-200 would hide.

I don't want a VBA, macro, or a filter solution.

I thought I found something online for how to do this and it turned out to be for a different program, and not for Excel.

This sheet will need to be used by a lot of people with a range of Excel proficiency.
I am confident that I know how to adjust my formulas to only count the rows selected in the how many rows do you want field. But I don't know how to hide the unused rows, which is what I desire.

Currently the sheet has an extra COPY LINE that I ask users to copy and insert for as many added rows as needed beyond the default. Some users have problems with that since it is too complex for them.

Thank you.

 

[Fluff]

I'm afraid you cannot hide rows just using a formula.
You will need to use filters or a macro.

 

[Corim Danex]

Thank you for a quick response.

Is it true that if I were to use a macro, the file type would have to be different than .xlsx?

 

[Fluff]

Yes it would. Macros need to be in either .xlsm or .xlsb workbooks