You'll need to watch the cursor carefully to understand where the inserted cells will go. Just hold down the shift key and then drag the selection. Just like a normal copy, relative cell references will change.ĭrag and drop also allows you to insert cells. ![]() When you release the selection, you'll have a copy of cell contents. ![]() The cursor will change to show a plus symbol (+) to let you know you are copying the selection. To copy with drag and drop, use the Control key in Windows and Option Key on a Mac while you drag. As with Cut, cell references in formulas won't change. The contents of the cells are moved from one location to another. When you select cells and drag the selection, this is equivalent to cut and paste. You can also use drag and drop for cut copy and paste, with some interesting options When you use cut, relative cell references will not change. The shortcut is Control + X on Windows, and Command + X on the Mac. Use cut when you want to actually move data or formulas from one location to another. ![]() Note that when formulas are copied, relative cell references will update automatically. To paste, use Control + V on Windows and Command + V on the Mac. ![]() To copy cells to the clipboard, use the shortcut Control + C on Windows, and Command C on the Mac. In this video, we'll look at shortcuts for the operations Cut, Copy, and Paste, and related Drag and Drop commands.
0 Comments
Leave a Reply. |