Insert line shortcut in Excel - Shortcut insert Excel

Inserting lines into a table in Excel is an extremely basic operation, but many users don't know the keyboard shortcuts to do this faster than just using the keyboard. The following Dexterity Software will introduce readers a number of ways to add lines quickly.

Insert line shortcut in Excel - Shortcut insert Excel Picture 1

Use keyboard shortcuts to quickly insert a line

Step 1 : Select any cell in the line immediately below to be inserted. Press Shift + Space keys to select both rows.

Insert line shortcut in Excel - Shortcut insert Excel Picture 2

Step 2: Press the combination of Ctrl and +. to insert a blank line before the selected line.

Insert line shortcut in Excel - Shortcut insert Excel Picture 3

Alternatively you can use the key combination Ctrl + Y to add lines.

Use keyboard shortcuts to quickly insert multiple lines

To add n lines, follow these steps:

Step 1 : You highlight the lines before the line to be inserted, the number of lines highlighted is the number of lines you need to add, for example you need to add 3 lines before the line number 4, you highlight the lines with the number 4, 5,6.

Insert line shortcut in Excel - Shortcut insert Excel Picture 4

Step 2: Press the key combination Ctrl and + to add lines.

Insert line shortcut in Excel - Shortcut insert Excel Picture 5

Add rows in a column

If you only need to add a row in a column, follow these steps:

Step 1 : Select the cell where you want to add the line immediately above it.

Insert line shortcut in Excel - Shortcut insert Excel Picture 6

Step 2: Press the key combination Ctrl and + (add on the numeric keypad).

A selection window will appear, select Shift cells down to move the lines down and create a blank cell.

Insert line shortcut in Excel - Shortcut insert Excel Picture 7

And this is the result:

Insert line shortcut in Excel - Shortcut insert Excel Picture 8

Use special keyboard shortcuts to insert rows in Excel if there is data to the right of the table

You only want to insert a few columns of rows, so as not to affect other tables in the same sheet. You do the same as inserting cells for a column.

Step 1: You highlight the cells to be inserted.

Insert line shortcut in Excel - Shortcut insert Excel Picture 9

Step 2: Press the key combination Ctrl and + (the plus sign on the numeric keypad).

A selection window will appear, select Shift cells down to move the lines down and create a blank cell.

Insert line shortcut in Excel - Shortcut insert Excel Picture 10

Add blank lines below each line

You need to add alternating blank rows to the rows in the data table below. Instead of creating one line at a time, you can follow these steps:

Step 1: You use the column to fill in the row number from 1 to the end.

Insert line shortcut in Excel - Shortcut insert Excel Picture 11

Step 2: Copy the line number you just created down below.

Insert line shortcut in Excel - Shortcut insert Excel Picture 12

Step 3: Arrange the position of the rows in column C order by Sort tool .

The result will be as follows:

Insert line shortcut in Excel - Shortcut insert Excel Picture 13

Now adjust the format of the worksheet and delete the extra column.

Insert line shortcut in Excel - Shortcut insert Excel Picture 14

Above Software Tips showed you how to add lines in Excel with keyboard shortcuts. Good luck!

4 ★ | 1 Vote

May be interested

  • How to use the Hyperlink function in ExcelPhoto of How to use the Hyperlink function in Excel
    there are many ways to create hyperlink links, but if you want to create more identical or similar links, the best and fastest way that software tips introduces you is to use the hyperlink function.
  • Coloring shortcuts in ExcelPhoto of Coloring shortcuts in Excel
    coloring shortcuts in excel. in this article, dexterity software will introduce readers to coloring shortcuts in excel.
  • Newline shortcut in ExcelPhoto of Newline shortcut in Excel
    most excel users can perform line breaks and breaks in excel. however, putting down the line so that it is reasonable and beautiful without taking too much time is not a simple matter. in this article, let's take a look at software tips to learn about shortcut keys and line breaks in excel.
  • How to rotate a PDF file in Foxit Reader when reversed is simplePhoto of How to rotate a PDF file in Foxit Reader when reversed is simple
    how to rotate a pdf file in foxit reader when reversed is simple. with its size and security advantages, pdf has become one of the most popular document formats today. however, like an image, the pdf file can also be rotated, and how will you handle it after opening a pdf file to see all the words in it are reversed?
  • Hello PowerPoint wallpaperPhoto of Hello PowerPoint wallpaper
    tipsmake.com presents readers beautiful and unique powerpoint backgrounds to help you have a polite and attractive powerpoint prologue.
  • How to create drop down lists in ExcelPhoto of How to create drop down lists in Excel
    how to create drop down lists in excel. to limit the typing of misspelled data and the same information but the data is not identical due to the person entering at uppercase, sometimes lowercase or extra spaces that make the statistics error, therefore, when designing a data entry, every employe