"Cleaning Up" Spreadsheet

  • Thread starter SharePoint Newbie
  • Start date
S

SharePoint Newbie

I have a spreadsheet that goes over to column G and down to row 65. I'd like
to delete the rest of the rows and columns so that all the user sees are the
fields I've populated and there's no H column or row 66.

Is this possible and if so can you tell me how?

THanks.
 
P

Pete_UK

Click on the column identifier for column H, hold down <shift>, press
<end>, then <right-arrow>, then release <shift> - this will have
highlighted all the columns from H to IV. Then click on Format |
Columns | Hide OK.

Then click on the row identifier for row 66, hold down <shift>, press
<end>, then <down-arrow>, then release <shift>. All the rows from 66 to
65536 will have been highlighted, so then it's Format | Row | Hide OK.

Hope this helps.

Pete
 
E

Elkar

You can't actually delete the extra columns/rows. When you do, they will
just be replaced with new ones. What you could do, is Hide them.

Select your rows/columns (holding down Ctrl-Shift-Down or Ctrl-Shift-Right
may be faster). Right-click the selected area, then select "Hide".

Users will be able to manually Unhide these areas if they wish, unless you
protect the sheet.

HTH,
Elkar
 
Top