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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920