How to remove blank cells

D

DestinySky

I have a spreadsheet with A LOT of blank cells. Is there any type of formula
I can use to automatically delete them?
 
S

Shane Devenshire

Hi,

Select the entire range and press F5, Special, Blanks, OK.
The press Ctrl+- (Control Minus) and choose shift cells...
 
K

kparag11

Hi,

Select the entire range and press F5, Special, Blanks, OK.
The press Ctrl+- (Control Minus) and choose shift cells...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
Click to expand...

thanx shane..............ur gr8

parag
 
Top