My data is in five thousand rows and columns A to M.
In column A, I have names and in the next columns, I have their corresponding data.
My problem is that lot of the corresponding data is not in the adjoining column.
How do I take out the blank cells to make so all of the columns have data in the adjoining column without doing all of the blank cells individually?
I would like to have all of the data in five thousand rows and columns A to F.
Thanks!
Try these following steps.
1) Do a Ctrl + A to select all the data
2) Ctrl + G to open the Go To window > Click Special
3) On the Go To Special window, check Blanks. This will allow you to select all the blank cells
4) Right click your mouse to bring up the menus and select Delete
5) Pick Delete - Shift Cells Left then hit ok
Thank you!! That did it.
I discovered now, that I need to move only the cells that have the data in font size 16 from column B to column C. The other font sizes in column B are 11 and 12.
How do I do that in a couple moves?
That...might requires VBA. I suggest you create a new post for your new question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks