How to Quickly Insert New Cells in Excel

There isn’t any trickery involved in this post. I just want to give you a quick and simple way to insert new cells in excel.

First, let’s see the usual way of doing it. Suppose, you have a data set as shown below and you want to insert blank cells in C2:C4, in such a way that the data in C2:C4 should shift one column to the right

Insert New Cells in Excel

The usual way of doing this is to first select C2:C4, then right click and Select Insert. In the Insert dialogue box, select Shift Cells Right.

While this isn’t exactly a very long way to do this, there is a better and quicker way to do it. Here is the trick:

  1. Select B2:B4.
  2. Bring your mouse pointer to the bottom right of the selection. You will see the autofill icon (a black square).
  3. Press Shift (you will notice that the shape of the mouse pointer has changed).
  4. Shift the selected data to the right.
  5. That’s it!!.

Insert New cells in Excel

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

1 thought on “How to Quickly Insert New Cells in Excel”

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster