Excel 2007 has several features to help you enhance your workbooks. These features can remove unnecessary data and spaces from your final spreadsheet. Removing blank rows can be done by applying a filter to your data. When the filter is applied, drop-down icons appear in the column headers of your data. Once this is done, you can customise the filter to display rows that have data. The blank rows will be hidden by using this feature.
- Skill level:
Other People Are Reading
Open Excel 2007 and select a workbook. Select the "Office" button and click "Open." Search your network for the workbook. Click the workbook and select "Open." The workbook opens.
Select the first column header in your workbook. Select the "Home" tab and click "Filter" from the "Sort & Filter" button in the "Editing" group. Notice the drop-down icons that appear in your column headers.
Select a column header that may contain blank data. Click the drop-down icon. Scroll down in the list and locate "Blanks." Remove the check. The blank rows from this column are removed.
Repeat this step for each column that may contain blank data. Once you have done this for each affected column, all of the blank rows will be removed from your Excel 2007 workbook.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for