1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel copying all cells between two selected cells (selecting those cells wit ctrl + c). It was fine last week and it now started to do this. Onlinee/app/offline versions.

Our take

If you’re experiencing an issue where copying non-contiguous cells in Excel results in all cells between them being pasted instead, you’re not alone. For instance, when selecting cells A1 and A8 using CTRL + C, and then pasting with CTRL + V, Excel unexpectedly includes all cells from A1 to A8 in the paste operation. This behavior can occur across various versions, including online, app, and offline. Understanding this change in functionality is essential for maintaining your productivity and ensuring your data management remains efficient.

Say I want to copy A1 and A8 and paste it. I select A1 and A8 with CTRL + copy, I paste with CTRL + V, and it pastes all cells from A1 to A8 instead of A1 and A8.

submitted by /u/marimeia
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article