banner



How To Delete Unused Rows In Excel App

  • You can remove blank rows in Excel by first doing a "Find & Select" of blank rows in the document. You can then delete them all at once using the "Delete" button on the Home tab.
  • Double check that you're only deleting the rows that you want, as selecting and deleting individual cells will move the data below it up, potentially disrupting the workflow of your Excel sheet.
  • Visit Business Insider's homepage for more stories.

Though having blank rows in an Excel worksheet isn't necessarily a bad thing, sometimes they're unnecessary, as they can make a document take up much more space than intended.

Removing blank spaces and rows in Excel is easy and can be done by using "Find & Select" for all of the blank spaces.

Here's how to do it on a Mac or PC.

Check out the products mentioned in this article:

Microsoft Office (From $149.99 at Best Buy)

MackBook Pro (From 1,299.99 at Best Buy)

Lenovo IdeaPad (From 299.99 at Best Buy)

How to remove blank rows in Excel

1. Click the Home tab in the top menu bar in Excel, and click "Find & Select" on the right side.

2. Select "Go to Special."

Click "Go To Special..."
Kelly Laffey/Business Insider

3. A pop-up box will appear. Select "Blanks," and then hit "OK."

Check "Blanks" in the list.
Kelly Laffey/Business Insider

4. Excel will then highlight all of the blank cells. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. If you just want to remove rows and not individual blank cells, you can always select a cell with "control + click" on a PC, or  "command + click" on a Mac, to deselect it. Note that when you delete cells, the data below it will be moved up.

5. Once all the blank rows are highlighted, go to the Home tab and find the "Delete" button on the right-hand side. Select "Delete Sheet Rows." This will remove the blank rows.

The last step is to select "Delete Sheet Rows."
Kelly Laffey/Business Insider

Related coverage from How To Do Everything: Tech:

  • How to make a line graph in Microsoft Excel in 4 simple steps using data in your spreadsheet

  • How to add a column in Microsoft Excel in 2 different ways

  • How to insert multiple rows in Microsoft Excel on your Mac or PC

  • How to make a pie chart from your spreadsheet data in Microsoft Excel in 5 easy steps

  • How to lock cells in Microsoft Excel, so people you send spreadsheets to can't change certain cells or data

Insider Inc. receives a commission when you buy through our links.

How To Delete Unused Rows In Excel App

Source: https://www.businessinsider.com/how-to-remove-blank-rows-in-excel

Posted by: yearbywartime.blogspot.com

0 Response to "How To Delete Unused Rows In Excel App"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel