Highlight the area of your spreadsheet in which you want to delete the blank rows. Be sure to include the row just above the first blank row and the row just below the last blank row. Click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special” on the drop-down menu. On the “Go To Special” dialog box, select “Blanks” and click “OK.” All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu. All the blank rows are removed and the remaining rows are now contiguous. You can also delete blank columns using this feature. To do so, select the area containing the blank columns to be deleted. Be sure to include the column to the left of the leftmost column to be deleted and the column to the right of the rightmost column to be deleted in your selection. Again, click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special” from the drop-down menu. Select “Blanks” again on the “Go To Special” dialog box and click “OK.” Again, all the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. This time, since there are no blank rows selected, only blank columns are selected. Click “Delete” in the “Cells” section of the “Home” tab and then select “Delete Sheet Columns” from the drop-down menu. ![]() The blank columns are deleted and the remaining columns are contiguous, just as the rows are. This method for deleting blank rows and columns is quicker, especially if you have a large workbook containing large and multiple worksheets. Tip: Click anywhere in the page you want to delete, press Ctrl+G (Option+⌘+G on Mac), and in the Enter page number box, type page. Press Enter on your keyboard, and then click Close. Verify that a page of content is selected, and then press Delete on your keyboard. Aug 17, 2007 Support Communities / iWork / Pages for Mac. Question: Q: Question: Q: Can't get rid of blank page. In word processing mode, Pages 08 created a blank page. Usually a blank page at the end of a Pages document is cause by extra paragraph returns after the last line or an image with wrap turned on 'pushing' the last return to. When you create a table that ends at the bottom margin, Word automatically inserts a new blank page. If you turn on the Show/Hide button, it reveals a paragraph mark after the table. If you don't need the extra page, your first instinct may be to delete the paragraph mark, but Word prevents you from doing so because the mark is part of the document's table format. Windows movie maker 2.6 for windows 8.1. Your next step may be to reformat the page so the paragraph mark fits on the page, but there is a third solution. Follow these steps to eliminate the extra page: • Select the paragraph mark on the second page. • Click in the Font size box in the Formatting toolbar. (In Word 2007, click in the Font size box in the Font group in the Home tab.) • Replace the font size with 1. Press [Enter]. If the paragraph mark is still on the blank page, follow these steps.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Простой обзор без лишних прикрас. АрхивыКатегории |