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
Vinod Babu
(24196 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.
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 Topics
- Account type error
- I am 35 What to do
- GSTR-3B Sales & Tax Liability Correction
- Full Exemption on Capital gain
- CRedit Note to suspended GSTN
- ITR 2 utility error
- GST Registration for Postal Agent
- COMMUNICATION ON GST PORTAL BETWEEN DEALER
- ERROR IN ITR 3 and ITR 2
- Error in jason file itr 3 pls guide
Related Threads
Trending Online Classes
-
Certification Course on GSTR-3B Reconciliation with GSTR-2B through AI Tools
CA Deepak Gupta15 July 2025
CAclubindia
