How to Delete Empty Pages with Page Break Preview You will see a dotted line appears that splits up the extra pages when you are printing.Click on the Print Selection from the menu given in the print Settings group.The File tab will open up the other alternative options.By default, the File tab contains basic options that let you make changes in the Excel sheet as per your needs.įor this reason, the File tab option is used in the process of deleting extra or empty pages in the sheet. Using the File tab option, you can get rid of the unwanted or extra pages from the sheet. How to Delete Extra Pages in Excel with File Tab option It will delete the other pages on the sheet. Place the mouse cursor on the dotted line and drag it down. You will see some dotted lines that split up the pages.Click on Set Print Area from the Print Area menu.Open the Page Layout option given in the ribbon.Select the whole sheet from where you need to delete pages that are no more needed. You can print only the selected area once you have specified the print area on the sheet. The print Area option here will not be used for printing the full worksheet. You can use the Print Area feature to delete unwanted pages. Removing unwanted pages in Excel sometimes need you to use multiple options from Excel. Let’s dive into it: How to Delete Pages in Excel with Print Area Option So, how would you delete pages in Excel that are no more needed? Here in this post, you will get to know the actual strategy you can use to remove unwanted or empty pages from the sheet. However, other pages will remain open and you often never know about them. Furthermore, you can even use this tool to execute different operations using the given dataset.Īs you know that Excel has many pages to work on, but usually one page is enough in most cases. It helps in organizing your data in whatever format you want. Well, Excel is a superb tool containing multiple sheets with rows and columns. Have you ever wanted to delete pages in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |