Look Who it Was Random video

Excel - Excel Shortcuts: Insert and Delete Columns and Rows with Ease - Episode 765

1,470 views · Published 30 January 2009 · 1:36 · Indexed 6 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Excel Shortcuts: Insert and Delete Columns and Rows with Ease.

Welcome back to another MrExcel netcast! In this quick tip, I'll be showing you some handy shortcuts for inserting and deleting columns and rows in Excel. With the long holiday weekend approaching in the United States, this is the perfect time to brush up on your Excel skills and save yourself some time and effort.

First up, let's talk about inserting columns. Did you know that you can select an entire column and then press CONTROL + sign to quickly insert new columns? This is a great time-saving trick, especially if you need to insert multiple columns at once. Simply select the desired number of columns and press CONTROL + sign to insert them all at once.

But what about deleting columns or rows? Well, the same shortcut applies here as well. Just select the columns or rows you want to delete and press CONTROL – sign to quickly get rid of them. This works just as well with rows, so you can easily insert or delete rows with just a few keystrokes.

However, if you're only selecting a single cell and try to use the shortcut, you'll be prompted with a choice. Do you want to shift the cells down or insert an entire row? This is where you'll have to make a decision based on your specific needs. But either way, these shortcuts are a great way to save time and make your Excel work more efficient.

I hope you found this tip helpful and that it will come in handy during your next Excel project. Have a great weekend and be sure to tune in for more netcasts from MrExcel. Don't forget to like and subscribe for more Excel tips and tricks. Thanks for watching!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


You might already know these, but I recently was shown a few cool shortcuts for inserting rows, columns, or cells. Episode 765 will show you how.

Table of Contents:
(00:00) Introduction
(00:13) Quick tip for the holiday weekend
(00:23) Fast way to insert new columns
(00:39) Using CONTROL + sign to insert multiple columns
(00:49) Using CONTROL - sign to delete rows or columns
(00:59) Be careful when using CONTROL + with a single cell
(01:15) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
CONTROL + sign shortcut for inserting columns
How to delete multiple columns or rows at once
How to insert multiple columns at once
Next netcast from MrExcel
Quick tip for inserting new columns
Shift cells down or insert entire row when using CONTROL + sign
Shortcut for deleting columns or rows
Tips for using the CONTROL + sign shortcut efficiently
Using CONTROL – sign for deleting rows or columns
Using CONTROL + sign for inserting rows
Weekend productivity tips from MrExcel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152107/

More from this channel