Skip to main content
Help Center Community Shop

Excel Question

cbxjeff

I have a spreadsheet that is approaching 80 line entries. Is there a way that I can pre-select what group of entries are shown when I startup? Yes, I could break this down into multiple excel files but would prefer just to hide selected groups as I can when printing.


Thanks guys,

0

Comments

6 comments

Date Votes
  • mogley98

    You can do a split screen

    0
  • gtpony

    To Hide/Unhide rows or columns just select the row or column, right click within that row and select 'Hide'. When you save this document it will now open with the rows hidden.

    9
  • cbxjeff

    gtpony, how do I show them again if necessary?

    0
  • gtpony

    When you 'hide' the row, you will actually still see a thin box where the row # was. It's really like you flattened the row to a very, very thin line. So if you hide row 16, you will see what looks like a thicker line/flattened box between rows 15 and 17. Right click between 15 and 17 and select 'Unhide' and it will reappear.

    6
  • cbxjeff

    Thanks for the replies guys. I should have mentioned that I'm running Office 365.

    0
  • love2shoot

    I am using excel

    To hide: Select the rows or columns, RC, then LC hide

    To unhide: Click with ctrl on either side of the hidden rows or columns. RC then LC unhide

    You can find the hidden parts by looking at the letters across the top or numbers down the side.

    0

Please sign in to leave a comment.

Recent Activity