deleting blank cells scattered throughout BIG range

bebermanii

New Member
Joined
Sep 25, 2002
Messages
6
I need an easy way to get rid of MANY blank cells that are scattered throughout the range (M2:CI132). Each row has at least one cell that contains data, but that one cell may be in column AA and the cells from column M to Z in that row would need to be deleted. Most rows have multiple cells containing data that also have blank cells inbetween them and all of those need to be deleted as well. The goal is to have all of the data lined up on the left starting in column M and continuing to the right with no blanks inbetween the data.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Welcome.

I am new to this board as well ...so entrying your question multiple times does not accelerate the reply, it probabaly slows it down. It may have been an error to post yr request 5 times...that is not necessary. This board have very capable people to reply in due time....I have found the replies to be very fast. Give the board monitors and users a chance to reply. I am sure you will get this done.

pll
 

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
Select cell M1, to C132, from the Edit menu, select Go To, click on the special button, then slect the blanks radio button. This will select all your blank cells. Then select delete from the Edit menu and choose Shift cells left.

HTH

Richard
 

Forum statistics

Threads
1,144,734
Messages
5,725,983
Members
422,652
Latest member
Elnene1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top