Excel - Copy and Move Data - Excel Essentials

preview_player
Показать описание
Part of Excel Essentials is moving and copying data. There are multiple ways to move and copy, and I included a few tips in this video.

Chapters:
00:00 Introduction
00:45 Two ways to move data
01:51 Copy data
02:19 Copy non-adjacent cells
03:06 Moving a range
03:56 Closing remarks

Move a Column
1) Right-click and click Cut
2) Right-click the column where you want to paste, and click Insert Cut Cells.

Method 2
1) Left-click the column to move
2) Hold down SHIFT
3) Put your mouse on the border (four large arrows) and drag and drop where you want to column
note: Let go of the mouse before letting go of the SHIFT key

Select non-adjacent cells with the CTRL key. 02:19 in the video

Menard's Blog Post

#exceltraining #chrismenard #chrismenardtraining #excelessentials

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Рекомендации по теме
Комментарии
Автор

I haven't used the Copy non-adjacent cells before - what a handy tip!

bethkoch