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.
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.
Step 1: Select the cells that you want to shift.
Step 2: Select Copy or type Ctrl+C
Step 3: Select the cells where you want to paste.
Step 4: 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.
Step 2: 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.
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.
Step 1: Select the column (F) or row heading ( Salary).
Step 2: Find the Insert option on the top right corner and click on it.
Step 3: Select the Insert Cells option.
Step 4: Select-Shift cells right.
Step 5: After that, the next column will be like this. Then click on any cell and press Enter.
Step 6: Finally, the whole Salary will be shifted.
- Add/Remove Gridlines in Excel (5 Simple Ways)
- Data clean-up techniques in Excel: Filling blank cells
- What is an Active Cell in Excel?
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.
Step 1: Select the cell that you want to shit.
Step 2: Right-click on it, and you will find the Insert option. Click on it.
Step 3: Select the Shift cells down option.
Step 4: 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.
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)
Step 3: 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.
Step 5: 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.
Step 1: Select the Price After Discount row.
Step 2: Right-click on it and select the Insert option.
Step 3: Select the Shift Cells Down option.
Step 4: The whole row will be shifted after that.
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.