5 Important Excel Shortcut Keys That Make You An Expert In MS Excel Select, Insert or Delete Row or Column
Learn 5 MS Excel Shortcut Keys That make Excel work Fast
2 Useful Excel shortcut keys for Fast Data Entry | Auto Fill | Fill down, Fill Right
Select, Insert or Delete Row or Column
In this article, today we are going to learn Excel shortcuts keys to select and delete row or columns of MS Excel. Perhaps you know this excel shortcuts keys, but reading this article will teach you all the things. Using these shortcuts, we can easily select the entire row column and insert or delete. This will speed up your work without using a mouse. We keep bringing more information about such shortcuts.Excel Shortcut Keys of Fill Down and Fill Right of learned data entry
1. Select Entire Column Ctrl + Space bar
To select the entire column in the cell in which you enter the cell, press and hold the Ctrl Button on the keyboard and press the Space bar button. The entire column will be selected. You can select multiple Column at one time by selecting multiple Cells.
Ctrl + Space This Excel shortcut key makes it easy to select columns. To delete a selected column or to select a column or to insert a column, the following shortcuts are used.
In the image below, the cell was on C7. On pressing Ctrl + Space, the entire column is selected. Now further shortcuts will work according to this column.
2. Insert Entire Column Ctrl + Addition Symbol (+)
Ctrl + Addition Symbol Button (+) will insert a column in the left side of the selected cell. Pressing Ctrl and pressing Addition Symbol Button (+) will insert more columns.
3. Select or Deselect Column using Excel Shortcut Key’s — Shift + Arrow
A. Select right-side columns — Shift + Right Arrow
Now the selected column is C here. If you want to select more columns on the right side of the C column, then Shift + Right Arrow will be selected with this Excel Shortcut Key.
B. Deselect Right Side Columns then Select Left Side Column — Shift + Left Arrow
Shift + Left Arrow This is the use of the Excel Shortcut Key to Deselect the selected columns.
Shift + Left Arrow is Deselecting the right-side columns from Excel Shortcut Key, the left-side columns will be selected as soon as they come to the C column.
C. Deselect Left Side Column — Shift + Right Arrow
Again Shift + Right Arrow is used to deselect the selected column on the left side.
Meaning that the first column you selected can select or deselect its right side and left side columns using Excel Shortcut Key Shift + Right & Left Arrow.
4. Delete selected column — Ctrl + Minus Symbol Button
Ctrl + Minus Symbol’s Button is used to delete all the columns that are selected.
5. Selecting the entire row of the selected cell -
Excel Shortcut Key Shift + Space Bar is used to select the entire row of the cell in which you enter. You can select Multiple Row by selecting Multiple Vertical Cells.
Insert Entire Row- Ctrl + Addition Symbol (+)
The new row will be inserted on the row selected from Ctrl + Addition Symbol. Row is inserted every time you press the shortcut.
Row was the number 5 selection in the image above. In the image below, Ctrl + Addition Symbol
After press, the new number 5 row has been inserted above the number 5 row.
3.1 Select or Deselect Row’s using Excel Shortcut Key’s — Shift + Arrow
Just as Shift + Right or Left Arrow is used to select and deselect columns, Shift + Up & Down Arrow Excel Shortcut Keys is used to select the row above and below the selected row.
A. Selecting Row at the bottom of the selected cell
In the above image, column 5 was selected. Now the image below Shift + Down Arrow has selected the row below the selected cell using Shift + Down Arrow excel shortcut key.
B. Deselect the row below the selected cell and select the row above the selected cell — Shift + Up Arrow
Shift + Up Arrow will be used to deselect the row selected below. While pressing Shift + Up Arrow, while pressing on Shift + Up Arrow, press Shift + Up Arrow, above selected Row 5 will continue to be selected.
C. Deselecting Up Row of Selected Cell — Shift + Down Arrow
Shift + Down Arrow will have to be used again to deselect the top row of the selected cell.
4.1 Deleting Selected Cells — Ctrl + Minus Symbol
Ctrl + Minus Symbol is used to delete the selected cell. In the above image there was a Blank Row 5 Select. Now the Blank cell has been deleted using Ctrl + Minus Symbol in the image below.
6. Similarly, if you do not select Row and enter only in the cell, then you can also press or press Excel Shortcut Key Ctrl + Minus Symbol and delete the entire row.
7. If you do not select the column and enter it in the cell only, then you can insert the cell or the entire column by pressing Excel Shortcut Key Ctrl + Addition Symbol.
Thanks…….