D DestinySky Jun 23, 2009 #1 I have a spreadsheet with A LOT of blank cells. Is there any type of formula I can use to automatically delete them?
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 Jun 23, 2009 #2 Hi, Select the entire range and press F5, Special, Blanks, OK. The press Ctrl+- (Control Minus) and choose shift cells...
Hi, Select the entire range and press F5, Special, Blanks, OK. The press Ctrl+- (Control Minus) and choose shift cells...
K kparag11 Jun 24, 2009 #3 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
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
