Hiding unused cells

  • Thread starter Thread starter Rachael
  • Start date Start date
R

Rachael

A friend has asked me is there a way he can send a
spreadsheet to a client and only display
cells/rows/columns on the worksheet that contain
information. i.e. similar to defining the print area
e.g. if cells a1:r34 contain information, hide rows 35 to
65536 and columns S to IV.
I've tried hiding rows and columns though it is time
consuming to get to the 65000th row!!
 
Rachael

Select Row 36(not A36, ROW 36) then SHIFT + END + DownArrow to select from 36
to 65536 in an instant. Then Right-click>Hide.

Same for column S. SHIFT + END + RightArrow.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding blank rows 3
hiding unued rows and column 3
Hide rows issue 3
Excel EXCEL - using a date dependant formula to hide rows 3
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Help: Find Matching Cells, If - Then Move Cell With Self 2
Locating the row that has no values. Selecting that row till the last row after that and deleting it 2
Excel spreadsheet to Word document 1

Back
Top