Delete Styles Trong Excel 2007 / TOP 10 # Xem Nhiều Nhất & Mới Nhất 3/2023 # Top View

Các bạn tải file Excel trên mạng sẽ rất nhiều khi gặp phải trường hợp trong Formating Style có rất nhiều Style không mong muốn. Vì vậy các bạn muốn xóa Style nhưng có nhiều Formating Style cứng đầu không thể xóa được.

Cách 1: Xóa Style thủ công

Cách này chỉ áp dụng cho số lượng Style cần xóa nhỏ, các bạn thực hiện như sau:

Xuất hiện các Formating Style, các bạn muốn xóa Style nào thì nhấn chuột phải vào Style đó và chọn Delete.

Cách 2: Xóa Style sử dụng code VBA

Với file Excel có nhiều Formating Style thì cách này sẽ giúp các bạn xóa tự động tất cả các Style trên file Excel, các bạn thực hiện như sau:

Visual Basic. Sub StyleKill() Dim styT As Style Dim intRet As Integer On Error Resume Next For Each styT In ActiveWorkbook.Styles If Not styT.BuiltIn Then End If Next styT End Sub

Bước 5: Nhấp đúp chuột trái vào StyleKill để chạy Module xóa Formating Style.

Cách 3: Xóa Style bằng cách xóa trên file Style.xml

Xuất hiện hộp thoại Folders Options các bạn chọn thẻ View, trong phần Advanced settings các bạn bỏ chọn trong ô vuông trước dòng Hide extensions for known file types và nhấn OK.

Bước 1: Mở file Excel .xlsx (hoặc .xls) sau đó các bạn nhấn phím F12 để mở cửa sổ Save As, lưu thành bản mới với định dạng .xlsm như hình dưới.

Bước 2: Vào thư mục chứa file .xlsm mà bạn vừa lưu, sửa định dạng .xlsm thành định dạng .zip. Xuất hiện thông báo Rename các bạn chọn Yes.

Bước 3: Nhấp đúp chuột để mở file zip, tiếp theo chọn thư mục xl.

Bước 4: Mở file chúng tôi bằng Notepad.

Bước 7: Ngay khi các bạn lưu và đóng file chúng tôi thì trên thư mục winrar của file Excel mà bạn đang mở sẽ xuất hiện thông báo file chúng tôi đã sửa đổi, các bạn chọn Yes và đóng file .zip.

Bước 8: Đổi lại file từ định dạng .zip thành .xlsm

Các bạn mở file Excel, xuất hiện thông báo We found a problem with some content… các bạn chọn Yes. Như vậy các bạn hãy xem kết quả, sau đó lưu lại định dạng .xlsx hoặc .xls tùy ý.

How to quickly delete all autoshapes in Excel?

Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.

More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.

Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.

Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.

Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.

More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Delete all autoshapes in active worksheet with Go To function in Excel

If there are only one kind of objects-autoshapes in a worksheet, you can delete all autoshapes with Go To function.

Note: Objects contain autoshapes, pictures, clip arts and so on. Applying this method will remove other objects besides auto shapes if there are not only autoshapes object in the worksheet.

Delete all autoshapes in active worksheet with VBA

Using VBA macro can help you delete all auto shapes in active worksheet quickly.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

VBA: delete all shapes in active worksheet.

Step 3: Press the F5 key to run this macro.

Then you will see all shapes in active worksheet are deleted quickly.

Notes:

1. This VBA macro can only delete all shapes in active worksheet.

2. This VBA macro can delete all kinds of shapes in active worksheet, including pictures, ClipArt, Shapes, SmartArt, charts, Text boxes, etc.

Delete all autoshapes in worksheet or workbook with Kutools for Excel

Step 2: In Delete Tools dialog box, please check Auto shapes option, and check one of option in look in section. See the following screen shot:

If you check the Active sheet option, it will delete all auto shapes in active worksheet;

If you check the Selected sheets option, it will delete all auto shapes in selected worksheets;

If you check the All sheets option, it will delete all auto shapes in the whole workbook.

Relative articles:

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails…

More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.

Open and create multiple documents in new tabs of the same window, rather than in new windows.

Delete a Pivot Table in a Microsoft Excel Workbook

Applies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook, Excel creates a pivot cache in the background. If you delete a pivot table or a source worksheet with the original data, Excel still retains the cache.

Recommended article: 10 Great Excel Pivot Table Shortcuts

Deleting a pivot table

To delete a pivot table:

Select a cell in the pivot table.

Press Delete.

Below is the Select All command in the Ribbon:

You can also delete a pivot table by deleting the worksheet on which it appears (assuming there is no other data on the sheet) or by deleting all of the rows on which the pivot table appears.

Deleting a pivot table and converting it to values

You can delete a pivot table and convert it to values. This can be useful if you want to share the pivot table summary information with clients or colleagues.

To delete a pivot table and convert it to values:

Select a cell in the pivot table.

Below is the Paste drop-down menu in Excel:

Deleting pivot table filters, labels, values and formatting

You also have the option of resetting a pivot table by deleting pivot table filters, labels, values and formatting but retaining the pivot table.

To delete pivot table data:

Select a cell in the pivot table.

Add or remove fields in the Pivot Table Fields task pane.

Below is the Clear All command in the Ribbon in Excel:

If pivot tables are sharing a data connection or if you are using the same data between two or more pivot tables, then if you select Clear All for one pivot table, you could also remove the grouping, calculated fields or items and custom items in shared pivot tables. A dialog box should appear if Excel is going to remove items in shared pivot tables and you can cancel the operation.

Did you find this article helpful? If you would like to receive new articles, join our email list.

More resources

How to Remove Blanks in a Pivot Table in Excel (6 Ways) How to Change Commas to Decimal Points in Excel and Vice Versa (5 Ways) How to Convert Seconds to Minutes and Seconds in Excel Worksheets

Related courses

How to delete hidden worksheets in Excel?

Perhaps you have a workbook contains many hidden worksheets which aren’t useful, and they take up so many bits, now you want to delete all of the trashy hidden worksheets. How could you quickly delete them?

Delete hidden worksheets with VBA code Delete hidden worksheets with Inspect Document function Delete hidden worksheets with Kutools for Excel

Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.

More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.

Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.

Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.

Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.

More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Delete hidden worksheets with VBA code

The following VBA code will delete all hidden worksheets within a workbook.

1. Open the workbook you want to delete the hidden worksheet.

Delete hidden worksheets with Inspect Document function

With the Inspect Document function of Excel, you can delete the hidden worksheets quickly and easily.

Delete hidden worksheets with Kutools for Excel

If you want to delete the hidden worksheets quickly, you can use Kutools for Excel.

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

After installing Kutools for Excel, you can do as follows:

2. Then a prompt box pops out to remind you if you really want to delete all hidden worksheets. See screenshot:

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails…

More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.

Open and create multiple documents in new tabs of the same window, rather than in new windows.