Bạn đang xem bài viết How To Delete A Page In Excel được cập nhật mới nhất trên website Hoisinhvienqnam.edu.vn. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất.
What to Know
Go to the View tab, select Page Break Preview, then drag the dotted blue line to adjust the area you want to print.
If you only want to print part of the worksheet, highlight the area you want to print, then go to the File tab and select Print.
To set a print area for the document permanently, go to the Page Layout tab, highlight the area you want to print, then select Print Area.
This article explains how to delete pages in Excel. Instructions apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.
How to Delete Unwanted Pages in Excel
Page breaks are the boundaries in a worksheet that decide what content goes on your printed document page. Excel chooses these for you automatically, using your default paper size and margin settings. You can also adjust the automatic page breaks by scaling your print job smaller (less than 100 percent) or larger (more than 100 percent) than your working document.
Insert, delete, or move page breaks in Excel to make sure pages print as expected.
Open the worksheet in which you want to delete a page and select the View tab.
Select Page Break Preview in the Workbook Views group.
You can adjust page breaks in the Normal view in Excel, but it’s easier to use Page Break Preview to work on the page break layout. The preview mode shows how any change you make to columns or rows impacts the automatic page breaks.
With Page Break Preview enabled, you can see a dotted line representing the automatic page break, with each page numbered.
You can select any of the blue lines (both dotted and solid) to adjust the print areas.
Select and drag the dotted blue line (an automated print break) to adjust the area you would like to print. The line turns solid, converting it to a manual page break.
When you finish adjusting the page breaks, select Normal in the Workbook Views group.
How to Set Your Print Area in Excel
Creating page breaks is a great way to manage larger documents, but what if you want to print a snapshot of the content and not the whole worksheet? You can use printer options to print a selected area by following these steps.
For one-time printing:
Select and drag to highlight the area of the worksheet that you want to print.
Select the File tab.
Choose Print Selection in the list under Settings.
Change Print Settings Permanently
If you’ll print the selected area more than once and want to set a print area for the document permanently, you can do it this way.
Go to the Page Layout tab.
Highlight the area that you want to print, then select Print Area in the Page Setup group.
Choose Set Print Area.
How To Quickly Delete All Autoshapes In Excel?
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.
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.
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.
How To Delete A Pivot Table In Excel
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.
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.
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
How To Delete A Pivot Table In Excel (Easy Step
Pivot Table is one of the best features in Excel.
You don’t need to know any formula or coding to quickly crunch thousands of rows of data and create quick summaries out of it. All you need to know is how to drag and drop and a little bit of knowledge of how to create a Pivot Table.
In this tutorial, I will show you various ways to delete a Pivot Table from Excel.
How to Delete a Pivot Table in Excel
Since you’re reading a tutorial about removing or deleting a Pivot Table, I am assuming you already have a Pivot Table(s) in place that you want to remove.
When it comes to deleting a Pivot Table, there are a few different ways you can do this.
The method you choose will depend on how you want to delete the Pivot Table.
Below are some scenarios that I will be covering in this tutorial:
Delete the Pivot Table & the resulting data (the summary created using the Pivot Table)
Delete the Pivot Table but keep the resulting data
Delete the resulting data but keep the Pivot Table
Delete all the Pivot Tables in one go
Let’s dive in and see each of these methods.
Delete the Pivot Table and the Resulting Data
Below is an example where I have created a Pivot table and used it to get the Sum of Revenue for different regions (to which I will be referring to as Pivot Table summary data in this tutorial).
Below are the steps to delete the Pivot table as well as any summary data:
Select any cell in the Pivot Table
Hit the Delete key.
The above steps would delete the Pivot Table.
Note that you can also select the entire Pivot Table by selecting any cell and then using the keyboard shortcut ‘ Control + A ‘. In case you have filters applied in the Pivot table, Control A will not select the entire Pivot Table. You need to use the method shown above (or select the Pivot Table manually)
Another quick way to delete the Pivot Table is to simply delete the worksheet that has the Pivot Table. Of course, you wouldn’t want to do this if you have any other data in the worksheet.
Delete the Pivot Table but Keep the Resulting Data
There may be cases when you want to delete the Pivot table, but not the resulting data that you have got after using the Pivot table. This could be the case when you have used the Pivot Table and then want to send to your manager/client only the resulting data.
Another case where this may be needed is when your Pivot Table is too heavy and is bloating your worksheet. Deleting such a Pivot table can drastically reduce the Excel file size.
For example, in the below example, I want to remove the Pivot Table, but I still want to keep the data in cell A3:B8
Below are the steps to do this:
Select any cell in the Pivot Table
The above steps would delete the Pivot Table but still keep the resulting data.
Some Keyboard Shortcuts you can use:
Select any cell in the Pivot Table and use the Keyboard ‘Control + A’ to select the entire Pivot Table
Once you have selected the entire Pivot table and copied the data, you can use the following keyboard shortcut to paste as values – ALT+E+S+V+Enter (one key after the other)
You can also use the same steps shown above to copy the data from the Pivot Table and pasting it as values at some other location (somewhere in the same worksheet or some other worksheet/workbook). Once you have the data, you can then delete the Pivot Table.
Note: When you copy data (Control C) from a Pivot Table and paste it (Control V) anywhere in the worksheet, it simply creates another Pivot Table. If you want to keep the resulting data only, and not the Pivot Table, make sure you paste as values.
Delete the Resulting Data but Keep the Pivot Table
Suppose you have created a Pivot Table and summarized the data (using filter and columns/rows headers to get the data you want) as shown below.
If you want to only remove the data that you have got while keeping the Pivot Table (so that you can rearrange and create another summary), you can do that as well.
If you select the data and hit the delete key, it will delete the Pivot Table as well.
Below are the steps to keep the Pivot table and remove the resulting data only:
Select any cell in the Pivot Table
Delete All Pivot Tables in One Go
In case you have multiple Pivot tables and you want to delete all of these at one go, you can do that using a simple VBA code.
Caution: Once you delete these Pivot Tables with the VBA code, you’ll not be able to get these back. So be absolutely sure when you do this, and if needed, create a backup copy to avoid losing these.
Below is the VBA code that will delete all Pivot Tables in one go:Sub DeleteAllPivotTables() Dim Ws As Worksheet, Pt As PivotTable On Error Resume Next For Each Ws In ActiveWorkbook.Worksheets For Each Pt In Ws.PivotTables Ws.Range(Pt.TableRange2.Address).Delete Shift:=xlUp Next Pt Next Ws End Sub
The above coded uses the For-Each-Next loop to go through each worksheet in the active workbook. In each worksheet, it checks if there is a Pivot table or not and deletes it (if there is).
Where to Put this VBA code?
This code needs to be placed in the regular module in the VB Editor
Below are the steps to put this code in the module:
Open a workbook from which you want to remove the Pivot Tables.
Use the shortcut ALT + F11 (this opens the VBA Editor window).
Hover the cursor on Insert.
In the module window (that will appear on the right), copy and paste the above code.
Here is an article where I cover different ways to run a VBA macro in Excel.
As soon as you run this code, it will remove all the Pivot tables from all the worksheets in the workbook.
You May Also like the following articles:
Cập nhật thông tin chi tiết về How To Delete A Page In Excel trên website Hoisinhvienqnam.edu.vn. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Chúc bạn một ngày tốt lành!