In order to participate in the GunBroker Member forums, you must be logged in with your GunBroker.com account. Click the sign-in button at the top right of the forums page to get connected.
Excel Question
cbxjeff
Member Posts: 17,642 ✭✭✭✭
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,
It's too late for me, save yourself.
Comments
You can do a split screen
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.
gtpony, how do I show them again if necessary?
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.
Thanks for the replies guys. I should have mentioned that I'm running Office 365.
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.