hidden rows

  1. A

    Pressing 'ENTER' lands me on a cell in a hidden row

    I have an Excel spreadsheet with numerous hidden rows. I find that under normal circumstances with non-merged cells, when I press enter Excel will move down to the cell in the next visible row. It works great. However, I recently discovered that under some circumstances this is not the...
  2. J

    Pivot Tables - Label Filters 'greyed out'

    I constructed a simple pivot table on sperate sheet based on info on another sheet. One problem I ma having is the 'Label Filter' is greyed out. Does this have something to do with the fact that some rows on my data sheet are hidden? As well how can I unhide these hiddne rows, since...
  3. A

    Hiding rows in multiple ranges

    I'm trying to hide rows in multiple ranges in a sheet. I can't seem to get it to work completly. Listed below is the code. I've defined the sections of what I want to hide and I want to only hide the rows that are 6(7) rows in and stop at 'Total'. I was able to get this work partially but not...

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