moving data

kendel

Board Regular
Joined
Mar 2, 2010
Messages
133
Hello, I'm using XP & excel 2007 pretty much just learning. I would like to move data from many cells in the same column at the same time. The cells are separated by other data or blank cells. There are many cells in the column to move at the same time, so moving them 1 at a time takes too long. An example would be to move both 3s at the same time 1 cell to the right (the cell is empty).
3
5
2

3

thanks for any help!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Select your range to copy.

Edit, Copy

Select the cell you want to Paste to

Edit, Paste
 

kirkjtommy

New Member
Joined
Nov 11, 2009
Messages
21
Why do you not filter your selection, and then choose the number you want to move from the filter list. You can then select only visibly cells by highlighting all the 3s that now now appear in the filtered list and then going to
edit
go to
special
click on visible cells only and ok
ctrl c
click in the cell you wish to copy to
and ctrl v

This works in excel 2003, not sure which menu you will use in 2007 for the 'go to' thing.
 

kendel

Board Regular
Joined
Mar 2, 2010
Messages
133
Thank you for the response but I guess I didn't explain what I would like to do clearly. Please reread my post. Is there a way to move just the 3s at the same time one cell to the right? There are times when I would like to move the data in 40 or 50 unconnected cells in the same column, 1 cell to the right and there could be 6-7 sheets. Moving a 3 in 300 cells 1 cell to the right one at a time would take very long.
Thanks again!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,664
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top