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.
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.
Step 2: Press the combination of Ctrl and +. to insert a blank line before the selected line.
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.
Step 2: Press the key combination Ctrl and + to add lines.
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.
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.
And this is the result:
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.
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.
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.
Step 2: Copy the line number you just created down below.
Step 3: Arrange the position of the rows in column C order by Sort tool .
The result will be as follows:
Now adjust the format of the worksheet and delete the extra column.
Above Software Tips showed you how to add lines in Excel with keyboard shortcuts. Good luck!
You should read it
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Newline shortcut in Excel
- How to insert a Word document into an Excel file
- Shortcut switch Sheet in Excel
- How to insert watermark, logo sink into Excel
- How to insert a batch image into Excel box
- Instructions for inserting a PDF file into Excel spreadsheet
- How to mark products in Excel
- Instructions for inserting an image into an Excel spreadsheet
- Instructions for inserting delta symbols in Excel
- How to insert pictures into an Excel comment box
- 3 ways to put abbreviations in WORD, EXCEL
Maybe you are interested
Fix printer errors with blurred text and blurred lines
List of current ThinkPad lines
Shortcuts to Boot Options and BIOS of computer lines
Oppo adds a series of general AI features to the Find, Reno, F and A smartphone lines
iPhone miraculously 'survived' after falling from a height of 16,000 feet from an Alaska Airlines plane
25 years ago today, Microsoft launched one of the most successful lines of computer mice