Excel Efficiency Boost: Ctrl+Click to Insert Columns - Episode 2166

2,457 views · Published 2 November 2017 · 7:20 · Indexed 29 October 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Insert blank column between many columns in Excel.

Welcome back to the MrExcel netcast! In this episode, we will be discussing a handy Excel shortcut that will save you time and effort when inserting multiple columns. As always, I'm your host Bill Jelen and I was recently at Florida Southern College where I was reminded of the fact that there are always multiple ways to do things in Excel.

One common task that can be time-consuming is inserting tiny columns between existing columns. This often involves a series of keystrokes and can become tedious if you have to do it repeatedly. However, there is a faster way to achieve this using the F4 key. This key is usually used to add dollar signs in a reference, but when not editing a formula, it will repeat the last command you performed. So, by breaking the task into two steps - inserting the columns and adjusting their width - you can quickly insert multiple columns by simply pressing the F4 key.

But wait, there's an even faster way! During my seminar, a student named Lacie from Middleburg, Florida shared a trick that I had never heard of before. By holding down the CONTROL key and clicking on each individual column, you can insert a column between every existing column with just one click. This is a game-changer and Lacie even won an Excel Guru Mission Patch for this amazing tip. And of course, this trick can also be used to insert multiple rows by holding down the CONTROL key and clicking on each row.

But what if you need to double-space your data? Well, there's a trick for that too. Simply type the numbers 1 to 9 in a new column, copy and paste them to 9 new rows, sort by that column, and delete it. Voila, your data is now double-spaced. And if you're dealing with a manager who insists on tiny columns between the columns, I have a solution for that as well. By using the SINGLE ACCOUNTING UNDERLINE option, you can achieve the desired look without the hassle of manually adding borders.

However, I must admit that I have a personal dislike for this particular task as it is often driven by a manager's obsession with how things look rather than the accuracy of the data. But fear not, I have a workaround for that too. By adding spaces in between the data, you can ensure that the entire range is selected when using the CONTROL * shortcut. This will prevent any accidental sorting of only a portion of the data. So, there you have it - multiple ways to insert columns and make your data look just the way your manager wants it. Don't forget to check out my book, Power Excel with MrExcel: 617 Excel Mysteries Solved, for more handy tips and tricks. Thanks for watching and see you next time for another netcast from MrExcel!

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/

This video answers these common search terms:
how to insert columns between multiple columns in excel
how to insert a column between columns excel
how to insert columns in excel between data
how do you insert columns in excel
easy way to insert columns in excel
how to insert many columns in excel
how to insert blank columns in excel

#exceltricks
#excelhacks
#evergreen 

Table of Contents:
(00:00) Excel shortcuts for inserting multiple columns
(00:48) Using the F4 key to repeat the last command
(01:30) Using CTRL+CLICK to insert multiple columns at once
(02:51) Double-space rows
(03:32) Clicking Like really helps the algorithm
(04:19) Using Lacie's trick to make all columns narrow at once
(05:05) Outtake: the root cause behind the need for tiny columns
(06:05) Using the SINGLE ACCOUNTING UNDERLINE option for a cleaner look
(06:50) A workaround for selecting the entire data set when using tiny columns

I was in Lakeland Florida at Florida Southern College for an Excel seminar
There are five ways to do everything in Excel.
For example: If you need tiny columns between the columns, you could do
Alt+I C Alt+O C W 1 Enter over and over and over
But the F4 key will repeat the last action. By breaking the task in to two pieces, you
can do Alt+I C once and then repeatedly hit LeftArrow F4 until all the columns are inserted
Then, do Alt+O C W 1 Enter once and repeatedly hit RightArrow RightArrow F4 until all columns are smaller
But Lacie had a faster way:
Ctrl+Click each column and Alt+I C once
That will insert a column between each column
Ctrl+Click each new column and Alt+O C W 1 once
You could turn this trick sideways and use in to double-space the rows
But a faster way is the Bob Umlas trick to double space rows
Type the numbers 1-9 in a new column. Copy those numbers and paste to 9 new rows.
Sort by that column and then delete the column
Later, in the outtake - why you should never insert tiny columns between the columns

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

More from this channel