ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I copy or cut multiple rows to move to new sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/110060-how-do-i-copy-cut-multiple-rows-move-new-sheet.html)

rodneynoah

How do I copy or cut multiple rows to move to new sheet?
 
My question is just that...how do I copy or cut multiple rows to move to new
sheet?

Anthony D

How do I copy or cut multiple rows to move to new sheet?
 
Hi,

Clicking on a row number at the left of the sheet selects the row. Holding
down the left mouse button while dragging the mouse pointer (arrow) down
selects multiple rows. You can use the right mouse button when it is within
the highlighted row numbers (or the Edit menu, or Ctrl-c/Ctrl-x) to copy/cut
the highlighted rows.
Selecting another sheet and a row number with left mouse button then
clicking the right mouse button enables you to Insert Copied Cells.
It is also opssible to select non-adjacent rows using the Ctrl key when
clicking on row numbers with left mouse button, although they paste into
another sheet as adjacent rows.

"rodneynoah" wrote:

My question is just that...how do I copy or cut multiple rows to move to new
sheet?



All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com