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

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:

How to Insert Multiple Rows in Excel – 4 Methods. Keyboard & Mouse Tricks that will Reinvent the Way You Excel. 200+ Excel Keyboard Shortcuts. Boost Your Productivity with Excel Mouse Double Click Tricks. Unhide Columns in Excel. How to Insert Bullets in Excel Insert New Columns in Excel