Excel Copy and Paste Problem for Multiple Selections

You can run into problems if you try to copy multiple ranges, and paste them to a new location.

--You might see an error, "This action won't work on multiple selections"

--Or, Excel might paste values, instead of formulas.

To get the free workbook for this video, go to my Contextures website:

Video Timeline:

0:00 Introduction
0:15 Copy Error Message
0:42 Avoid the Error Message
1:54 Paste Problem
2:40 Copy 2 Ranges
3:23 Paste With Formulas
4:13 Get the Workbook

Instructor: Debra Dalgleish, Contextures Inc.
#ContexturesExcelTips

[dawnmcmannama]

Thanks so much. I did have a filter on. When I removed it the copy worked. You have such a clear voice and you're easy to follow.

[abuusman]

i have a workbook and need to print sheet 2 always two copies, how can I fix for always

[DougHExcel]

Thanks for the video. Good to know on the paste all for the formulas

[IMWiseGuyu]

How can we paste a column of data into a column that has been filtered and now has multiple ranges?

[wayneedmondson]

Hi Debra.. thanks for the video. I had not previously experimented with copying and pasting multiple regions simultaneously.. interesting. Thanks for the tips. Thumbs up!

[ruthreyes]

this is very helpful thank you so much

[thomasfergusen]

hello Debra, i cant paste to any range after savings workbook . How to fix that problem. Thanks!