How to copy and paste multiple non adjacent cells/rows/columns in Excel?
- Copy and paste multiple non adjacent cells/rows/columns
- Copy and paste multiple non adjacent cells/rows/columns with Kutools for Excel
When you attempt to copy multiple non-adjacent cells in Excel, you might encounter a warning dialog box that complicates the process. While one approach might be to copy and paste each cell individually, there are more efficient methods available. In this article, we'll explore two straightforward techniques that enable you to copy and paste multiple non-adjacent cells, rows, or columns simultaneously, bypassing the need for tedious, one-by-one operations.
Copy and paste multiple non adjacent cells/rows/columns
Although Microsoft Excel does not support copying and pasting multiple non-adjacent cells/cells/columns, but it allows users to copy and paste multiple non-adjacent cells/rows/column in specified conditions.
(1) Copy and paste multiple non-adjacent cells in the same column/rows
1. Holding the Ctrl key, and select multiple non-adjacent cells in the same column/rows one by one.
2. Press the Ctrl + C keys simultaneously to copy these non-adjacent cells; select the first cell of destination range, and press the Ctrl + V keys simultaneously to paste these non-adjacent cells. See below screenshots:
(2) Copy and paste multiple non adjacent rows (or columns) which contain the same columns (or rows)
1. Holding the Ctrl key, and select multiple non-adjacent rows (or columns) which contain the same columns (or rows).
2. Press the Ctrl + C keys to copy these non-adjacent rows or columns, next select the first cell of destination range, and press the Ctrl + V keys to paste these rows or columns. See screenshots:
Copy and paste multiple non adjacent cells/rows/columns with Kutools for Excel
When you need to manage complex data sets in Excel, such as copying and pasting multiple non-adjacent cells across various rows and columns, or handling disjointed rows and columns, Kutools for Excel's Copy Ranges utility is an indispensable tool. This feature streamlines the process, enabling you to efficiently transfer data between different parts of your spreadsheet with precision and ease.
1. Select multiple non-adjacent cells/rows/columns with holding the Ctrl key, and click Kutools > Range > Copy Ranges. See screenshot:
2. In the opening Copy Multiple Ranges dialog box, please check the All option, and click the Ok button. See screenshot:
3. And then in the second Copy Multiple Ranges dialog box, please specify the first cell of destination range, and click the OK button. 
So far all selected non-adjacent cells/rows/columns have been copied and pasted into a new range. See screenshot:
Demo: copy and paste multiple non adjacent cells/rows/columns in Excel
Related articles:
Copy formulas from one workbook to another without link
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
