
- How to delete multiple pages in word 2013 how to#
- How to delete multiple pages in word 2013 free#
Then click on the thumb button on your Vertical Scroll bar at the right of your Word window and drag it until you see it is on page 40. Another way to quickly select the text on a range of pages you would like to delete is jump to the beginning of page 25 and be certain you place your cursor there. It’s a lot to read but very little to actually do! As above, if the dialog box does not disappear, click Esc and it will so. That means that you now have all text on pages 25 through 40 selected. Word will now jump to the start of, but will select everything from the last insertion point location because you are using Extend mode. Key in 40 into the Enter a Page Number box and click Enter. Click F5 and Word will again display the Go To tab of the Find and Replace dialog box. If the Find and Replace dialog box doesn’t disappear, click Esc to make it do so. Word wil jump to the beginning of page 25. Key in 25 into the Enter a Page Number box and click Enter. The Pages option should be selected by default. Click F5 to display the Go To tab of the Find and Replace Dialog box. There is, of course, an easy way to delete pages 25 through 40. The reason for that is that Word doesn’t know squat about pages because all pages are different, depending on the text, formatting, etc. Can you do it with a single action? The answer is No. Now suppose, as an example, you need to delete pages 25 through 40. How to delete multiple pages in word 2013 free#
Feel free to ask anything or suggest any new methods.Say you have a rather large document in Word – say a Contract or something like that with about 50 to 75 pages. Finally, we can see the selected sheets with the selected text strings are deleted.īy following these methods, we can easily delete multiple sheets in Excel.
A dialogue box will pop up for the confirmation and select OK. If spreadsheet.Name Like "*" & "Sales1" & "*" Then Then copy the following codes and paste them into your VBA module. Now Right-click on the mouse and select View Code. We can easily delete all the sheets with a specific text string. How to delete multiple pages in word 2013 how to#
Read More: How to Delete Excel Sheet Using VBA (10 VBA Macros)Ĥ.2 Deleting Sheets with Specific Text String
Hit the Run option and we’ll see that all the sheets are deleted except the active one.
If spreadsheet.Name ActiveSheet.Name Then
Now copy the following codes and paste them into your VBA module. We just need to select the sheets, Right-click on the. From the sheet tab, select the active sheet, Right-click on the mouse, and select View Code. Deleting multiple worksheets in Excel by pressing the keyboard is one of the easiest and fastest ways. VBA is one of the most suitable methods to delete all sheets except the active sheet. Insert VBA Codes to Delete Multiple Excel Sheets 4.1 Delete All Sheets Keeping the Active Sheet We just need to select the sheets, Right-click on the Sheet tab, and press D from the keyboard. Delete Multiple Worksheets by Hybrid Keyboardĭeleting multiple worksheets in Excel by pressing the keyboard is one of the easiest and fastest ways. Now on the Sheet tab, Right-click on the mouse and select Delete.ģ.
Select the cells we want to delete by pressing the Ctrl key.We can also delete the non-adjacent worksheets. Right-click your mouse button on the Sheet tab and select Delete.By pressing and holding the Shift key, select the first sheet and the last one with the mouse we want to delete.We need to follow the steps below to delete multiple worksheets that are adjacent. Use Sheet Option to Delete Multiple Sheets in Excel 2.1 For Adjacent Worksheet Then we can see that the selected sheets are deleted.Ģ.Now go to the Home tab and select Delete > Delete Sheet.Select the Sheets we want to delete by pressing and holding the Shift key.You can use page breaks if you are writing an article with a title page or a directory ( reference book reference ) to make sure it starts on a new page. Page break allows you to move the text to the next page before the end of a page. Use Ribbon Option to Delete Multiple Sheets in Excelįrom the Ribbon option, we can delete multiple sheets. Please see the video How to break pages, paragraph breaks in Word 2013 below: Page break - page break. 4 Easy Ways to Delete Multiple Sheets in Excel 1.