No video

Moving and Copying Columns in Excel

  Рет қаралды 247,639

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

If you like this video, here's my entire playlist of Excel tutorials: bit.ly/tech4excel
Learn how to easily move or copy Excel columns. If you're used to cutting and then pasting columns, this tutorial will help you learn a much better way. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... #exceltutorial #excel

Пікірлер: 28
@SmellLies
@SmellLies 3 ай бұрын
You’re my favorite KZfaq channel for learning technology because you know how to teach!!! Great job!!!!! 👍
@mirabbosusmonov5631
@mirabbosusmonov5631 5 жыл бұрын
Amazing! I’ve always used the “cut and paste” option but the ones that you showed here are much faster. Thanks for the tips 🙌🏻
@LinsonJames
@LinsonJames 5 жыл бұрын
Keyboard shortcut(s) may make it easier for some. Especially when you want to move it between two other. To move column A between columns C and D, Ctrl-X (Cut) column A, select column D and press Ctrl-+ (Ctrl and Plus) to 'Insert Cut Cells'. This is particularly useful if you have a wider range of columns and then it's practically difficult to drag the selected column all along. The same applies for rows, and also, consecutive columns/rows, too. Ctrl-+ can also be used for adding a blank column/row between any two other if the clipboard doesn't paste in anything. Similarly, Ctrl and - (minus/dash) deletes a column/row.
@erikthysell
@erikthysell Жыл бұрын
Awesome, this is MUCH better than slow mouse things!
@christianweyrauch4909
@christianweyrauch4909 7 ай бұрын
Use the CTRL and the SHIFT as well when you drag. SHIFT will move and insert it, CTRL will create a copy of the column and copy it.
@hopepeacecomeswithacceptan4261
@hopepeacecomeswithacceptan4261 5 жыл бұрын
So much to learn, You really present your lessons very interesting.You are great at teaching.I feel comfortable and focus while listening and learning because your voice is really soothing and relaxing.
@UmairKhan-ks3jq
@UmairKhan-ks3jq 8 ай бұрын
To move a column without copying it, one can use the Move handle with SHIFT key pressed. That will enable you to move the column anywhere you want, even between other columns
@SuperBBetty
@SuperBBetty 2 жыл бұрын
You saved me tonight. Amazing video ! Thank you so much!!! 🥰😍
@mrblack299
@mrblack299 2 жыл бұрын
saved me a lot of time thanks
@firozahmed5749
@firozahmed5749 5 жыл бұрын
your are great, All video are really awesome.
@byDsign
@byDsign 5 жыл бұрын
Great tip!
@Nassim-obsr
@Nassim-obsr 2 жыл бұрын
thank you for the whole tutorial you really helped me
@RivanAlAyubbi
@RivanAlAyubbi 6 ай бұрын
should you click left when you use cntrl?
@brianc9036
@brianc9036 4 жыл бұрын
Thank you!
@maquebella
@maquebella 3 жыл бұрын
Amazing!!! It helps me a lot. Thank you ^^
@narasimha22
@narasimha22 3 жыл бұрын
Your videos are amazing very clear to understand. In this video only the thing I didnt understood is the ctrl one what you have said at last
@toneranger
@toneranger 3 жыл бұрын
Thanks but does not work for me, it says "can't do this with multiple ranges selected, select a single range and try again" ? I only have one column selected, filter is switched on and some coilumns are hidden but that should not matter surely, thanks in advance
@blendamane
@blendamane 3 жыл бұрын
Thank you for making this video!! Very helpful!!
@caroljolly208
@caroljolly208 3 жыл бұрын
Please could you tell me if you have a video about printing multiple tab pages (new page??) in an Excel file? I copied a formatted page onto several new pages (Tab) but when printing it's printing double sided even though ttbomk ALL my settings are set to single side printing?? Tyia 😁
@kathyreese9373
@kathyreese9373 5 жыл бұрын
I cannot seem to get this to work using my Macbook mousepad.
@songnation2023
@songnation2023 Жыл бұрын
I want to copy column from sheet and paste it into another sheet. But data to be pasted is 600, but iam only able to paste 263 elements into another why ?? Please help me..
@dumebinwachukwu7553
@dumebinwachukwu7553 3 жыл бұрын
hello, is it possible to copy an entire column to a fresh new column however the copied items do not start from the first cell?
@orthodoxall3715
@orthodoxall3715 3 жыл бұрын
can you tell me why my excel reads the dot as a comma and says invalid, it happens while using the excel 2013 files in excel 2016
@romeobodano9360
@romeobodano9360 5 жыл бұрын
amazing bro! thanks!
@theuglypaulus
@theuglypaulus 4 жыл бұрын
How to: 1. Make a page break so there will be no other rows and columns except our own work we want to print it out? 2. Merger several Worksheets become 1 (different files excels to be in one worksheet)?
@ut561
@ut561 4 жыл бұрын
great video, makes perfect sense, good presentation style, thanks :)
@muchammadandreprasetya8799
@muchammadandreprasetya8799 5 жыл бұрын
Thanksss
@stanleylafond4650
@stanleylafond4650 4 ай бұрын
A lot of fake comments. I need to copy a column to another sheet.
Fixing Improper Capitalization in Excel Using the Proper Function
5:02
Technology for Teachers and Students
Рет қаралды 106 М.
Beginners Guide to Excel Macros - Create Excel Shortcuts
14:35
Technology for Teachers and Students
Рет қаралды 506 М.
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 34 МЛН
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Бискас
Рет қаралды 6 МЛН
Paste Data into Filtered Columns in Excel (Clever Tricks)
10:02
TrumpExcel
Рет қаралды 31 М.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Technology for Teachers and Students
Рет қаралды 2,5 МЛН
10 *SURPRISING* Copy Paste Secrets for Excel PROs
8:27
Chandoo
Рет қаралды 244 М.
Excel Print Options, Tips and Tricks Tutorial
18:30
Technology for Teachers and Students
Рет қаралды 699 М.
Most important tools in Excel -  Malayalam Tutorial
17:04
XL n CAD Malayalam
Рет қаралды 667 М.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 244 М.
Using Find and Replace and Wildcards in Excel
4:27
Technology for Teachers and Students
Рет қаралды 45 М.