Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I skip blank cells when copying over a range of cells?
I would like to copy a column of values that have blanks between them over to
another column and skip the blanks. The skip blanks feature in paste special does not help this issue. |
#2
|
|||
|
|||
If you mean that you want to copy a column of cells, but omit the blank cells
(as if they don't exist), try this: 1)Autofilter the range......DataFilterAutofilter 2)Set the column filter to be Non-Blanks 3)Copy the range, then paste it where you want it The blank cells will be left behind. Example: A1: Amount A2: 50 A3: (blank) A4: 55 Using my suggestion, would A1:A4 would copy/paste as this A10: Amount A11: 50 A12: 55 Is that what you meant? -- Regards, Ron |
#3
|
|||
|
|||
Ron,
This is difficult to do when I have a whole spreadsheet of data and don't want to screw anything else up, right idea though. thanks "Ron Coderre" wrote: If you mean that you want to copy a column of cells, but omit the blank cells (as if they don't exist), try this: 1)Autofilter the range......DataFilterAutofilter 2)Set the column filter to be Non-Blanks 3)Copy the range, then paste it where you want it The blank cells will be left behind. Example: A1: Amount A2: 50 A3: (blank) A4: 55 Using my suggestion, would A1:A4 would copy/paste as this A10: Amount A11: 50 A12: 55 Is that what you meant? -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip blank cells in diagrams | Charts and Charting in Excel | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
copy blank cells | Excel Discussion (Misc queries) | |||
copy blank cells | Excel Discussion (Misc queries) |