Questions

How to delete rows and columns only if rows &/columns are entirely blank?

+
0 Votes
Locked

How to delete rows and columns only if rows &/columns are entirely blank?

financetech
if i am using "go to special" and select "blank" even the rows & / columns which are having data except in 1 cells are also deleted. so i am in trouble. so i want an option which deletes any rows/column only if they are completely blank.
+
0 Votes
john.a.wills

Excel? Works? Something on Apple? I probably can't help with either, but I am sure no-one can while you do not describe your immediate environment.

+
0 Votes
financetech

i am using microsoft excel 2007.

+
0 Votes
financetech

i am using excel file 2007 version. can u pls help me in this case?

+
0 Votes
buck-rabbit

Just select the rows and columns by drawing the pointer to select them and click on Delete either ( ALL ) or if asked, the selected row or column.

+
0 Votes
financetech

oh friends come on! if i have to work on a excel sheet which is having atleast 1000 of rows, how can i select manually all the blank rows? pls tell me the excel shortcut way of deleting such rows n or columns.