In this tutorial, you will get 5 easy ways to shift cells down in excel in a simple language including the illustration of a few real-life examples of its application.
How to Shift Cells Down (5 Easy Ways)
i. The Keyboard Shortcut
If you need an efficient and time-saving way, this shortcut will match your demand perfectly. It varies whether you’re on Windows or Mac. For Mac, hold down the option key while pressing the return key. The following steps are for windows:
-
- Select the cell or cell range
- Press the shortcut ALT+ENTER
- The result is shown
ii. Right-Clicking
Right-clicking, also called secondary clicking, refers to pressing the right button of the mouse. It makes workflow faster and reduces the time spent looking over a tab or ribbon. The following steps for shifting cells down using right-clicking should be followed:
- Select the cell or a collection of cells (cell range)
- Click the right mouse button
- Choose the Insert option
- Now pick the Shift Cells Down option
- At last press Ok
iii. Using the Insert Option from Home Tab
Here, you may proceed with the following steps:
- Select the cell or cell range
- Pick the Insert option from the ‘Home’ ribbon
- Choose the option Shift Cells Down
- Enter Ok option
- You will get the result
iv. Copy a Cell and Insert Copied File
The following steps are required to carry out this way:
- Select the cell or cell range and copy the selected cell by pressing CTRL+C
- Pick the option Insert Copied Cells from the ‘Home’ tab
- Choose Shift Cells Down
- Click Ok
- The result is shown
v. Shifting Horizontal Cells Downward
Sometimes you may require to shift a collection of horizontal cells (also called row) down in a row. For this you have to follow the following procedures:
- Select the row
- Click the right button of the mouse and choose the Insert option
- Pick the Entire Row option
- Then enter the Ok button
- The result is found.
Conclusion
It’s crucial to shift cells down in an efficient way. Now you have these ways, you’ll have no trouble shifting cells down. Thank you for reading this article and stay tuned for our next post. If you have any queries or opinion, please share in the comments section below.