| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear excess formats in Excel 2007
My old version of Excel (97) had a option (clear excess formats in
"bookname") on the "File" menu that would reduce the size of a worksheet by removing all the excess rows & columns. I can't seem to find how to do this in Excel Enterprise 2007. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Clear excess formats in Excel 2007
Home tab click on the eraser icon and choose one of the options.
"Don" wrote: My old version of Excel (97) had a option (clear excess formats in "bookname") on the "File" menu that would reduce the size of a worksheet by removing all the excess rows & columns. I can't seem to find how to do this in Excel Enterprise 2007. Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Clear excess formats in Excel 2007
I believe you are referring to an add-in that Microsoft provided.
This site seems to answer your question "How to reset the last cell in Excel" at http://support.microsoft.com/kb/244435 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Don" wrote in message ... My old version of Excel (97) had a option (clear excess formats in "bookname") on the "File" menu that would reduce the size of a worksheet by removing all the excess rows & columns. I can't seem to find how to do this in Excel Enterprise 2007. Can anyone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Clear excess formats in Excel 2007
Sorry TM but that did not work
"Teethless mama" wrote: Home tab click on the eraser icon and choose one of the options. "Don" wrote: My old version of Excel (97) had a option (clear excess formats in "bookname") on the "File" menu that would reduce the size of a worksheet by removing all the excess rows & columns. I can't seem to find how to do this in Excel Enterprise 2007. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear empty space inside every cell in excel 2003 and 2007 | Excel Worksheet Functions | |||
| Built in excel 2007 formats via VBA | Charts and Charting in Excel | |||
| Excel 2007: All of my formats disappeared | Excel Worksheet Functions | |||
| How do you get a cell to show hours in excess of 24 in excel 2007 | Excel Worksheet Functions | |||
| how do i clear the recents documents dropdown bar in excel 2007 | New Users to Excel | |||
Linear Mode
