Subsheets in excel, is this possible?

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Hi All,

I am trying to create subsheets in excel like I can in
access. I am looking at having an expand/collapse feature
for each row in my spreadsheet to display additional
information.

Is this possible in excel?

Thanks, Karen
 
Hi karen

Sort of. Select some rows, go menu Data > Group and Outline > Group.

But Excel isn't relational like a database, so you have to keep "what belongs where" in
order yourself.
 
Back
Top