I cant believe how hard this is. Sorry if this is a noob'ish question but i just cant figure it out.
So i have a column of values with some values coloured via conditional formatting. I want to copy the non-coloured cells to the adjoining cell. So i filter the column for non-coloured cells and select visible cells only. I deactivate the filter and paste into the adjoining cell however the results dont "retain" the location of the copied cell.
Time for some examples -
So i have a column of values with some values coloured via conditional formatting. I want to copy the non-coloured cells to the adjoining cell. So i filter the column for non-coloured cells and select visible cells only. I deactivate the filter and paste into the adjoining cell however the results dont "retain" the location of the copied cell.
Time for some examples -
Excel 2010 | ||||
---|---|---|---|---|
A | B | |||
1 | Data | Result of paste | ||
2 | 12 | 12 | ||
3 | 13 | 14 | ||
4 | 14 | 16 | ||
5 | 15 | 19 | ||
6 | 16 | |||
7 | 17 | |||
8 | 18 | |||
9 | 19 | |||
Sheet1 |
Excel 2010 | ||||
---|---|---|---|---|
A | B | |||
1 | Data | Paste results im after | ||
2 | 12 | 12 | ||
3 | 13 | |||
4 | 14 | 14 | ||
5 | 15 | |||
6 | 16 | 16 | ||
7 | 17 | |||
8 | 18 | |||
9 | 19 | 19 | ||
Sheet1 |