#REMOVE BLANK ROWS IN EXCEL FOR MAC 2011 HOW TO#
Choose it carefully when using this option to delete blank rows in Excel, when you want to remove just the blank cells. If you choose Delete Sheet Rows in step 4, you could potentially destroy data (often unseen) to the right.
#REMOVE BLANK ROWS IN EXCEL FOR MAC 2011 PRO#
For example, in Mac Office 2011, the hotkey shortcut is Ctrl+G.Īlso Read: Top 14 Best ePub Readers for Windows to Read eBooks on Windows The Pro Review From TechReviewProĬhoosing Delete Cells deletes only the blank cells in the previously selected range. You can repeat a similar process to remove blank columns from your spreadsheet.Ĭlick “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.Įven if you’re not running Excel 2013, a quick Google search for “Find and Select” in your version of Excel will turn up a keyboard shortcut that’ll do the same for you. Click the “Home” tab again, navigate to the “Cells” section, and click “Delete Sheet Rows” from the drop-down menu. If you’re running Excel 2013, navigate to the “Home” tab, then the “Editing” section, and click “Find & Select.” Click “Go To Special…” on the drop-down menu, and select “Blanks.” Click “OK.” Now, only the blank cells should be highlighted. This method for deleting blank rows and columns is quicker, especially if you have a large workbook containing large and multiple worksheets. The blank columns are deleted, and the remaining columns are contiguous, just as the rows are. Be sure to include the column to the left of the leftmost column to be removed and the column to the right of the rightmost column to be deleted in your selection. This time, since there are no blank rows selected, only blank columns are selected.Ĭlick “Delete” in the “Cells” section of the “Home” tab and then select “Delete Sheet Columns” from the drop-down menu. Select “Blanks” again on the “Go To Special” dialog box and click “OK.”Īgain, all the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. To do so, select the area containing the blank columns to be deleted. You can also delete blank columns using this feature. All the blank rows are removed, and the remaining rows are now contiguous.
Select “Blanks” again on the “Go To Special” dialog box and click “OK.” In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu. 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 removed in your selection.Īgain, click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” from the drop-down menu. To do so, select the area containing the blank columns to be removed. On the “Go To Special” dialog box, select “Blanks” and click “OK.”Īll 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.Īll the blank rows are removed, and the remaining rows are now contiguous. Be sure to include the row just above the first blank row and the row just below the last blank row.Ĭlick “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” on the drop-down menu. Highlight the area of your spreadsheet in which you want to delete the blank rows. Deleting blank columns is a similar process that we’ll show you later in this article.
0 kommentar(er)
