"Cleaning Up" Spreadsheet
 

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.

"Cleaning Up" Spreadsheet
 

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

"Cleaning Up" Spreadsheet
 

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


"SharePoint Newbie" wrote:

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.