Menu
excel
how to remove blank cells in excel
Replies (2)
Click on the triangle icon between column A and row 1 -> F5 -> Special -> Blanks -> Ok -> Home Tab -> Delete -> Delete Cells -> Shift Cells Up -> Ok
After selecting the data range, continue as follows:
Press [F5].
In the resulting Go To dialog box, click Special.
Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected range.
Now you're ready to delete the selected cells. On the Home tab, click the Delete dropdown in the Cells group and choose Delete Cells. Excel will display the Delete dialog box, with the Delete Cells Up option selected. Click OK. Or, press [Ctrl]+-. Excel will delete the blank cells from the selected data range.
Press [F5].
In the resulting Go To dialog box, click Special.
Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected range.
Now you're ready to delete the selected cells. On the Home tab, click the Delete dropdown in the Cells group and choose Delete Cells. Excel will display the Delete dialog box, with the Delete Cells Up option selected. Click OK. Or, press [Ctrl]+-. Excel will delete the blank cells from the selected data range.
Recent Topic
- Due date of ITR for Option Trader
- Cancelled invoice entry
- Debt Mutual Fund Tax in New Regime
- Amount distributed by a Co-op. Hsg Society to its
- Delayed reported invoice in GSTR1
- Kusumgar IPO Listing Date: Shares Debut on BSE, NS
- When is Diwali in 2026? Date, Muhurat Timing and D
- Amount received by son from PPF closure proceeds o
- Clarification on Nature of Payment Code for NRI Pr
- Fee received as Independent Director
Related Topics
CAclubindia
