Keeping hidden rows hidden...

A

Amy Beryl

Board Regular
Joined
May 5, 2011
Messages
54
Hi All,

I have several spreadsheets that contain a lot of history that could be important some time down the road. But for now I would like to keep the rows hidden while I create formulas and add new data. It seems that for unknown reasons the hidden rows keep unhiding and i have to run through the file yet again and hide them. If I want them visible I'll unhiden them.

Any suggestions to keep these rows hidden while I work on the file - other than grouping or VBA.

Thanks!

Amy
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
You must log in or register to reply here.

Similar threads

M
  • Question
Need multiple buttons to hide/show rows on another tab
Replies
8
Views
391
skillilea
S
N
  • Question
Hiding rows based on cell value
Replies
2
Views
99
smozgur
smozgur
Y
  • Question
Adjust column width when column header is hidden
Replies
7
Views
247
Peter_SSs
Peter_SSs
A
  • Question
Copy a sheet with hidden rows and past to another sheet keeping formula at some cells
Replies
1
Views
243
Candyman8019
C
G
  • Solved
Hidden rows reappear when opening the file.
Replies
8
Views
293
getravelman
G

Forum statistics

Threads
1,214,951
Messages
6,122,449
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top