Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove all formatting.
I use a third party application that exports data and really wierd
(impossible to work with) formatting to Excel. I currently remove all formatting by selecting all, copy and then paste into Notepad. Then I delete everything on the worksheet and do a select all copy from Notepad and a Paste Special, Text Only back into the worksheet. This works great but is cumbersome. Please, is there an easier way? Thanks -- Rick Wetzel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove all formatting.
Copy any single cell that has the formatting that you are looking for and
then select all of the cells on the sheet and Paste Special - Formats... -- HTH... Jim Thomlinson "Rick Wetzel" wrote: I use a third party application that exports data and really wierd (impossible to work with) formatting to Excel. I currently remove all formatting by selecting all, copy and then paste into Notepad. Then I delete everything on the worksheet and do a select all copy from Notepad and a Paste Special, Text Only back into the worksheet. This works great but is cumbersome. Please, is there an easier way? Thanks -- Rick Wetzel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove all formatting.
Rick,
Select the cells. Edit - Clear - Formats. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Rick Wetzel" wrote in message ... I use a third party application that exports data and really wierd (impossible to work with) formatting to Excel. I currently remove all formatting by selecting all, copy and then paste into Notepad. Then I delete everything on the worksheet and do a select all copy from Notepad and a Paste Special, Text Only back into the worksheet. This works great but is cumbersome. Please, is there an easier way? Thanks -- Rick Wetzel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
Remove all formatting | Excel Worksheet Functions | |||
Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
cell formatting problems | New Users to Excel | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |