Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all formats from a spreadsheet
In one of my busy spreadsheets I have too many formats and I want to get rid
of/remove them. I have cleared out the formats as best as I can but as soon as I try to sort the spreadsheet it comes back with too many formats. Any ideas on how to remove all formats from a spreadsheet completely and return it to the default state? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all formats from a spreadsheet
Try it through VBA Immediate window:
Alt+F11 to open VBA Ctrl+G to open Immediate window Type in cells.ClearFormats and press Enter Regards, Stefi €žAnnie1904€ť ezt Ă*rta: In one of my busy spreadsheets I have too many formats and I want to get rid of/remove them. I have cleared out the formats as best as I can but as soon as I try to sort the spreadsheet it comes back with too many formats. Any ideas on how to remove all formats from a spreadsheet completely and return it to the default state? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all formats from a spreadsheet
HI,
Go to menubar EditClearFormatsDone Save it if you dont then the formats will reappear when you reopen your file. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Annie1904" wrote: In one of my busy spreadsheets I have too many formats and I want to get rid of/remove them. I have cleared out the formats as best as I can but as soon as I try to sort the spreadsheet it comes back with too many formats. Any ideas on how to remove all formats from a spreadsheet completely and return it to the default state? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all formats from a spreadsheet
Hi Annie,
Depends on your version of xl. For xl2007 Select the entire worksheet. (To do this, click in the square at the top left of the worksheet where the column headers and row numbers meet.) Click the drop down arrow against the Clear button in the Editing block (far right of the Home ribbon). Select Clear formats. Previous versions. Select worksheet as above. Click menu item Edit - Clear - Formats. -- Regards, OssieMac "Annie1904" wrote: In one of my busy spreadsheets I have too many formats and I want to get rid of/remove them. I have cleared out the formats as best as I can but as soon as I try to sort the spreadsheet it comes back with too many formats. Any ideas on how to remove all formats from a spreadsheet completely and return it to the default state? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove all formats from a spreadsheet
You may not want to clear all the formats.
If you have dates, times, phone numbers, or currency, you may want to be more selective and remove the formatting that you don't care about. Select all the cells Ctrl-1 Change as much as you want (borders/fonts/borders/...) And you may want to remove conditional formatting, too. Annie1904 wrote: In one of my busy spreadsheets I have too many formats and I want to get rid of/remove them. I have cleared out the formats as best as I can but as soon as I try to sort the spreadsheet it comes back with too many formats. Any ideas on how to remove all formats from a spreadsheet completely and return it to the default state? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unifying different date formats in a spreadsheet | Excel Discussion (Misc queries) | |||
how dio i copy page setup formats from 1 spreadsheet to another? | New Users to Excel | |||
Can I disply Euro and Dollar Formats in the same spreadsheet | Excel Discussion (Misc queries) | |||
Using external data with differing formats in a spreadsheet | Excel Discussion (Misc queries) | |||
How do I resolve too many different formats in a spreadsheet? | Excel Discussion (Misc queries) |