{"id":3835,"date":"2023-02-03T16:44:56","date_gmt":"2023-02-03T16:44:56","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3835"},"modified":"2024-03-13T19:16:56","modified_gmt":"2024-03-13T19:16:56","slug":"how-to-copy-and-paste-multiple-cells-in-exce","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-copy-and-paste-multiple-cells-in-exce\/","title":{"rendered":"How to Copy and Paste Multiple Cells in Excel?"},"content":{"rendered":"

Copy and Paste Multiple Cells in Excel to streamline your data management and enhance productivity in your spreadsheets. This fundamental skill is crucial for efficient data transfer, formatting consistency, and scenario analysis, enabling you to handle large datasets with ease. By becoming proficient in copying and pasting multiple cells, you can save time, reduce errors, and ensure your Excel documents are both accurate and visually appealing. Embrace this essential technique to elevate your Excel capabilities and transform your approach to spreadsheet management.<\/p>\n

This Content Covers:<\/strong><\/p>\n

    \n
  1. Copy and Paste Multiple Adjacent Cells<\/strong><\/a><\/li>\n<\/ol>\n

    1.1 <\/strong>Using<\/strong> Keyboard Shortcut<\/strong><\/p>\n

    1.2 <\/strong>Using<\/strong> Right Click<\/strong><\/p>\n

    1.3 Mouse Shortcut<\/strong><\/p>\n

    1.4 Using Fill Handle<\/strong><\/p>\n

      \n
    1. Copy and Paste Multiple Non-Adjacent Cells<\/strong><\/a><\/li>\n<\/ol>\n

      2.1 <\/strong>Copy and Paste Multiple Non-Adjacent Cells that are in the same row\/column<\/strong><\/p>\n

      2.2 <\/strong>Copy and Paste Multiple Non-Adjacent Rows\/Columns (but adjacent cells)<\/strong><\/p>\n

      1. Copy and Paste Multiple Adjacent Cells<\/strong><\/h2>\n

      1.1 <\/strong>Using<\/strong> Keyboard Shortcut<\/strong><\/p>\n

      Step 1: <\/strong>Select the adjacent cells you want to copy and use the keyboard shortcut CTRL+C<\/strong> to copy.<\/p>\n

      \"Copy<\/p>\n

      Step 2:<\/strong> Select any cell where you want to paste the copied cells and use CTRL+V<\/strong> shortcut to paste.<\/p>\n

      \"Copy<\/p>\n

      1.2 <\/strong>Using<\/strong> Right Click<\/strong><\/p>\n

      Step 1: <\/strong>Select the cells for copying and right click on your mouse. Click on Copy.<\/strong><\/p>\n

      \"Copy<\/p>\n

      Step 2: <\/strong>Right click on the cell you want to paste the copied cells and select Paste(P).<\/strong><\/p>\n

      \"Copy<\/p>\n

      Step 3: <\/strong>The multiple selected cells are copied and pasted.<\/p>\n

      \"Copy<\/p>\n

      1.3 Mouse Shortcut<\/strong><\/p>\n

      Step 1: <\/strong>Select the cells. Hold CTRL<\/strong> key and take your mouse cursor at the right edge of the selection and you will notice your cursor icon changed into a (+)<\/strong> icon.<\/p>\n

      \"Copy<\/p>\n

      Step 2: <\/strong>Click and hold the left button on your mouse and drag it to a cell where you want to paste the selection. Now leave the mouse and the selected cells will be copied and pasted there.<\/p>\n

      \"Copy<\/p>\n

      1.4 Using Fill Handle<\/strong><\/p>\n

      Step 1: Make selection of your desired adjacent cells you want to copy and take the mouse cursor at the bottom right corner of your selection.<\/p>\n

      \"Copy<\/p>\n

      Step 2: <\/strong>The cursor will change into (+) <\/strong>icon. Now click and drag it downwards or to any direction where there are blank cells to copy and paste the selection of these multiple cells.<\/p>\n

      \"Copy<\/p>\n

      2. Copy and Paste Multiple Non-Adjacent Cells<\/strong><\/h2>\n

      If you select multiple cells that are non-adjacent to each other and try to copy them using any of the methods above, this dialogue box will pop up on your screen saying \u201cThis action won\u2019t work on multiple selections\u201d. <\/strong>There is no method of techniques for copying multiple non-adjacent cells from different rows and columns. However, you can copy multiple non-adjacent cells if they are located in same row or in same column.<\/p>\n

      \"Copy<\/p>\n

      2.1 <\/strong>Copy and Paste Multiple Non-Adjacent Cells that are in the same row\/column<\/strong><\/p>\n

      Same Row<\/strong><\/p>\n

      Step 1: <\/strong>Hold CTRL<\/strong> key and select multiple non-adjacent cells which are in same row. Use CTRL+C<\/strong> to copy these cells.<\/p>\n

      \"Copy<\/p>\n

      Step 2: <\/strong>Select a cell where you want to paste and click CTRL+V.<\/strong><\/p>\n

      \"Copy<\/p>\n

      Same Column<\/strong><\/p>\n

      Step 1: <\/strong>Hold CTRL <\/strong>and select non-adjacent cells from a column. Use CTRL+C<\/strong> to copy and CTRL+V <\/strong>to paste them anywhere.<\/p>\n

      \"Copy<\/p>\n

      2.2 <\/strong>Copy and Paste Multiple Non-Adjacent Rows\/Columns (but adjacent cells)<\/strong><\/p>\n

      You can copy and paste multiple non-adjacent rows\/columns if the cells are adjacent.<\/p>\n

      Step 1:<\/strong> Select all the adjacent cells from non-adjacent row\/columns and copy them using CTRL+C.<\/strong><\/p>\n

      \"Copy<\/p>\n

      Step 2:<\/strong> Select a cell and paste them using CTRL+V.<\/strong><\/p>\n

      \"Copy<\/p>\n

      Copy and Paste Multiple Cells in Excel<\/p>\n

      Application of Copy and Paste Multiple Cells in Excel<\/strong><\/h2>\n