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
(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.
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
- Avoiding tax audit in case of intraday equity loss
- Form 3CEAB
- Form 3CEAA and Form 3CEAB
- DIR 3 Web KYC
- Can i declare LTCG income as business income if I
- Stock entry in new software
- I have an EMI collection shop, what is its SAC cod
- Making payment once in quarter possible under QRMP
- Master File Documentation related
- Applicability of 44AD needs clarification
Related Threads
CAclubindia
