How to shift cells in Excel

How to shift cells in Excel

Sometimes, when working on MS Excel, there may be a need to shift cells in different places according to our needs. The process of moving cells in Excel is mandatory for Excel beginner users. In this article, I am going to show you how to shift cells right in Excel.

Table of Contents hide
6 shortcuts of copying the formula of shifting cells in Excel

6 shortcuts of copying the formula of shifting cells in Excel

1. Cells Shifting by using Copy and Paste

Let’s assume we have a dataset of employees about their joining date and salary.  But only the Name and joining date are given in the first table. For entering the names in the salary table, we want to shift or copy the name column from the joining date table.  We want to copy the whole column from A to E using a copy and paste process. Follow the steps below.

Cells Shifting by using Copy and Paste

Step 1: Select the cells that you want to shift.

Select the cells that you want to shift.

Step 2: Select Copy or type Ctrl+C

Select Copy or type Ctrl+C

Step 3: Select the cells where you want to paste.

Select the cells where you want to paste.

Step 4: Select Paste option or use keyboard shortcut Ctrl+v

Select Paste option or use keyboard shortcut Ctrl+v

2. Shifting Cells by Dragging and Dropping

Here I will show the same cells proper shifting process for the above problem using the drag and dropping procedure. 

Step 1: Select the cell(s) that you want to shift.

Select the cell(s) that you want to shift.

Step 2: Move your mouse to the border (any side), and you will find your mouse like this.

Move your mouse to the border (any side), and you will find your mouse like this.

 Step 3: Drag the cells to the desired location.

Drag the cells to the desired location

3. Shifting Cells in Excel Using the Insert Option. 

Another way of shifting the cells in Excel is using the insert option. If we consider the same example above, and if we want any specific cell to the right, then we can use the insert option. Let’s assume we want to shift the Salary column cells to another location for any reason. So I will show you how to change F column cells to G column using the insert option.

Shifting cells in Excel using the insert option

Step 1: Select the column (F) or row heading ( Salary).

Select the column (F) or row heading ( Salary).

Step 2: Find the Insert option on the top right corner and click on it.

Find the Insert option on the top right corner and click on it.

Step 3: Select the Insert Cells option.

Select the Insert Cells option.

Step 4: Select-Shift cells right.

Select Shift cells right.

Step 5: After that, the next column will be like this. Then click on any cell and press Enter.

Then just click on any cell and press Enter

Step 6: Finally, the whole Salary will be shifted.

Finally the whole Salary will be shifted


Similar Readings:


4. How to Shift Cells Down a Column.

There are several ways of shifting any cells down a column. I have shown one example below. Let’s have some Name lists. I will move the name list down using the insert option.

How to Shift Cells Down a Column

Step 1: Select the cell that you want to shit.

Select the cell that you want to shit

Step 2: Right-click on it, and you will find the Insert option. Click on it.

Right-click on it and you will find the Insert option. Click on it.

Step 3: Select the Shift cells down option. 

Select the Shift cells down option

Step 4: Then, your selected cell will be shifted down.

Then your selected cell will be shifted down

5. How to Shift Cells Bottom or Left using Drag and Drop in Excel

Using the dragging, we can shift the cells at any location in Excel. Let’s do this using the same example mentioned in the 4th process. Now we will move the name column (E) up, bottom, left using this concept.

Step1: Select the desired column or cells.

Select the desired column or cells.

For Shifting Left:

Step 2: Point the mouse at the border of the selected cells, then you will sell the mouse icon will be turned into this picture. Drag the selected columns and drop them to the left column (D)

Drag the selected columns and drop them to the left column (D)

Step 3: Then it will be shifted from column E to column D

Then it will be shifted from column E to column D

For Shifting Up:

Step 4: For upshifting, drag the selected file to the upper side and drop it. 

For upshifting just drag the selected file to the upper side and drop it.

Step 5: Then, the selected cells will be shifted up.

Then the selected cells will be shifted up

6. How to shift cell across row in Excel.

Sometimes we may need to shift cells across rows in Excel for different purposes. Here I will show how to shift cells across rows.

Let’s have a dataset of some fruits and their price and after discount price. Now we need to shift the discount price row down from the current position. For this, we need to follow the steps.

How to shift cell across row in Excel

Step 1: Select the Price After Discount row.

Select the Price After Discount row

Step 2: Right-click on it and select the Insert option.

Right click on it and select the Insert option.

Step 3: Select the Shift Cells Down option.

Select the Shift Cells Down option

Step 4: The whole row will be shifted after that.

The whole row will be shifted after that

Conclusion

Thus we can easily shift any cell from one cell to any other cell. In this article, I have shown some different ways for shifting cells in Excel. These methods are shown depending on various purposes. All of the ways are effective in different ways. You can use those methods according to your needs.

Further Readings

Tags:

Md. Abdullah Al Murad

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo