Ad-Free CAclubindia and Daily Updates on your mobile. Subscribe Now!

excel

Divya Vidhani (42 Points)

30 August 2018

how to remove blank cells in excel

Reply
Follow
Share

2 Replies

Deepak Gupta (CA Student) (15922 Points)
Replied 30 August 2018

Click on the triangle icon between column A and row 1 -> F5 -> Special -> Blanks -> Ok -> Home Tab -> Delete -> Delete Cells -> Shift Cells Up -> Ok

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Vinod Babu (24191 Points)
Replied 30 August 2018

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.