Show Active Part Of Sheet Only

[robertwms]

I have a worksheet that has 5 columns and 32 rows. How do I get rid of all the other cells so all I have is what I want to see?

[Palmetto]

To hide all unused rows

1. Click the row header (not cell) of the first row to hide (row 33)
2. Press Ctl + Shift + down arrow
3. Right-click row header and choose "Hide"

To hide all unused columns
1. Click the first column header to hide ( G )
2. Press Ctrl + Shift + right arrow
3. Right-click column header and choose hide