How to Add Columns in Excel the Easy Way

Опубликовано: 31 Июль 2026
на канале: XcelTips
28
2

Need to add a missing column in Excel without deleting your data? This Microsoft Excel 365 on Windows tutorial shows you how to add columns in Excel the easy way, so you can place a new column exactly where you need it.

You’ll learn how Excel inserts new columns to the left of the selected column, why selecting the correct column letter matters, and how to use different beginner-friendly methods. The video demonstrates the right-click method, the Home tab method, the keyboard shortcut method, and how to add multiple columns at once. This is useful when you forgot to add a field, such as Sex or Qualification, and need to update your worksheet layout without starting over.

In this video, you’ll learn:
✅ How to add a new column between existing Excel columns
✅ Why Excel inserts columns to the left of the selected column
✅ How to use right-click and Insert
✅ How to use Home → Insert → Insert Sheet Columns
✅ How to add a column with Ctrl + Space and Ctrl + Shift + Plus
✅ How to add multiple columns at the same time
✅ What mistake to avoid when inserting a full column
✅ How to undo a column inserted in the wrong place

Full written guide:
https://xceltips.com/how-to-add-colum...

Chapters:
00:00 Add a missing column in Excel
00:11 Add one column with right-click
01:04 Add a column from the Home tab
01:38 Add a column with a keyboard shortcut
02:14 Add multiple columns with right-click
02:54 Add multiple columns from the Ribbon
03:26 Common beginner mistake
03:56 Quick recap

This tutorial is designed for absolute beginners using Microsoft Excel 365 on Windows.
Continue learning with this Excel beginner playlist:
   • Working with Data in Excel for Beginners -...  

Where would you add a new column in your worksheet: before names, phone numbers, emails, or another field?

For more simple, practical Excel lessons, subscribe to @TheXcelTips:    / @thexceltips  

#ExcelTips #ExcelForBeginners #Excel #XcelTips