Hide Rows and Cols to infinity

[Rich]

Hi,
I know how to hide Rows or Cols by selecting a range of Rows or Cols and
Right clicking and then selecting Hide. But, the others Rows and Cols show
up beyond those I have just hidden. I don't want any Rows or Cols to show
up after the hidden ones. How can I hide all Rows and Cols from a starting
point to infinity? Thanks,

Rich

(e-mail address removed) (<= remove "Z"s for valid email.)

 

[Ragdyer]

If you wanted column F to be your last visible column, select the *entire*
columnG, then,
<Ctrl> <Shift> <RightArrow>
This should select all the columns out to columnIV,
Right click in the selection, and choose <Hide>.

Do the same thing to hide the rows, using the <DownArrow> instead,
Which should bring you down to row 65536.

Is this what you're looking for?

 

[macropod]

Hi Rich,

One way:
Press F5 (Goto) and enter IV65536. This takes you to the lower right
extremity of Excel's range of available cells.
Next, use the horizontal & vertical scroll bars to scroll back to where your
last 'visible' cell appears.
Then, while holding down the Shift key, select the cell immediately below
and to the right of that cell.
Finally, choose Format|Column|Hide, followed by Format|Row|Hide.

Cheers

 

[Rich]

Perfect, thanks,
rich

If you wanted column F to be your last visible column, select the *entire*
columnG, then,
<Ctrl> <Shift> <RightArrow>
This should select all the columns out to columnIV,
Right click in the selection, and choose <Hide>.

Do the same thing to hide the rows, using the <DownArrow> instead,
Which should bring you down to row 65536.

Is this what you're looking for?

 

[Rich]

Another option. thanks,

Rich

Hi Rich,

One way:
Press F5 (Goto) and enter IV65536. This takes you to the lower right
extremity of Excel's range of available cells.
Next, use the horizontal & vertical scroll bars to scroll back to where
your
last 'visible' cell appears.
Then, while holding down the Shift key, select the cell immediately below
and to the right of that cell.
Finally, choose Format|Column|Hide, followed by Format|Row|Hide.

Cheers

 

[David McRitchie]

If you are simply trying to hide cells that look empty, then hiding cells
is not your best choice, when you have a lastcell problem.

Why do my scrollbars go to row 500 -- my data ends in cell E50?
http://www.contextures.com/xlfaqApp.html#Unused

which will go through all the worksheets in the active workbook fix the lastcell problems

When you open your file take a look at File, properties to get the size
after you run the macro, save, and check File, properties to get the file size.