Moving from one cell to another one by one could be a tiring thing, especially when you have a larger dataset. Today, you will get to know how to skip a line in Excel by using multiple methods. Skipping a line in Excel lets you save time and it also boosts productivity. Apart from the typical methods used in Excel, you will also find a shortcut key combination that lets you save time while skipping a line.
Skipping Lines in Microsoft Excel?
Excel data always needs to be organized and for a better understanding of data, you have to take help from different approaches. By using a skipping line feature, you can divide data into many groups so that it makes your data easy to read.
Let’s dive in to see how to skip a line in Excel:
How to Skip a Line in Excel with Excel Formula?
Suppose you are having a list of some students with IDs and you need to set this data apart into two columns. Below you will see how to handle several cases.
Skip Every Other Row
Here you may use a formula based on a combo of Excel INDEX and ROWS functions. Below are some easy-to-follow steps:
- First, you have to add two new columns Names and IDs. You may divide the list into two columns.
- Put the following formula in the cell D5:
=INDEX($B$5:$B$16, ROWS($E$5:E5)*2-1)
- Now, you need to fill the cells with the same formula by dragging the Fill Handle down.
- Put the following formula in cell E5:
=INDEX($B$5:$B$16, ROWS($E$5:E5)*2)
- Now, drag the Fill Handle down so that you can fill the cells with the same formula.
Here’s the final range you will see.
How to Skip a Line in Excel with a Keyboard Shortcut?
Using a keyboard shortcut for any function is an all-time favorite method for Excel users. Here we have an effective working keyboard shortcut to skip a line in Excel. For this:
- Choose a row or column that is needed to be skipped.
- Press CTRL + SHIFT + + keys from the keyboard.
- You will instantly see a new row or column has been added in the area you have selected.
Isn’t it a simple trick?
How to Skip a Line in Excel with Insert Option?
With the help of the Insert option, you can skip a line as well. For this:
- Choose a row or column that is needed to be skipped.
- Click on the Insert option given at the upper side of the screen.
- Click on the Insert Sheet Rows, and Insert Sheet Columns options from the given list.
- You will see a blank row or column added in the selected area.
All done!
How to Skip a Line in Excel with Right-Click Option?
Here comes another simple method to skip a line in Excel. With a right-click on the row or column, you can skip a line. For this:
- Choose the Insert option from the given menu and then click on the Insert Sheet Rows or Insert Sheet Columns option.
- You will see an empty row or column added in the selected area.
All set!
Skipping Multiple Lines in Excel:
What would you do if multiple lines need to be skipped?
Other than the above methods that assist you in skipping a line in Excel, you can use another method. For this:
- Choose a cell range you need to skip.
- Right-click on that cell range and choose the Insert option given in the drop-down menu.
- You will see a new dialog box appears.
- Now, choose the Entire row option.
- A new blank row will be added here and you can repeat this step as much as you need to skip multiple lines.
Summary:
Today, you have learned how to skip a line in Excel by using multiple methods. Along with a shortcut combination, this post covers multiple methods for this function. Try any of the methods given above and polish your Excel skills.
