In this article we will learn about basic shortcuts of excel which will help you in preparing various reports. we will use only keyboard for this shortcuts.
How to select anything in excel.
In order to select anything in excel, you just need to press shift key and respective arrow key. For example, if you want to select few numbers then just press shift key on your keyboard. Then press arrow key like up arrow for selecting upward portion and down arrow for selecting downward portion, same way you can press left arrow for left side and right arrow for right side depending upon the area which you want to select.
In order to select anything in excel, you just need to press shift key and respective arrow key. For example, if you want to select few numbers then just press shift key on your keyboard. Then press arrow key like up arrow for selecting upward portion and down arrow for selecting downward portion, same way you can press left arrow for left side and right arrow for right side depending upon the area which you want to select.
How to Delete and Add entire row.
If you want to delete entire row in excel sheet, then press shift key plus space-bar key on your keyboard. so that entire row will be selected, now press control key and (-)minus sign key on your keyboard so that entire row will be deleted. In order to add the row, same way select the entire row by pressing shift and space-bar key together. Then press control and (+) plus sign on your keyboard.
If you want to delete entire row in excel sheet, then press shift key plus space-bar key on your keyboard. so that entire row will be selected, now press control key and (-)minus sign key on your keyboard so that entire row will be deleted. In order to add the row, same way select the entire row by pressing shift and space-bar key together. Then press control and (+) plus sign on your keyboard.
How to Delete and Add entire column.
In order to delete the entire column. we first need select the entire column, so for that just press control and then space-bar key on your keyboard. So it will select the entire column. Now press control and then (-)minus sign on your keyboard for deleting the entire column. Same way for adding the entire column, Just select the column next to which you want to add entire column. So pressing control and space-bar key select the column and then press control and (+) plus sign on keyboard in order to add the column.
In order to delete the entire column. we first need select the entire column, so for that just press control and then space-bar key on your keyboard. So it will select the entire column. Now press control and then (-)minus sign on your keyboard for deleting the entire column. Same way for adding the entire column, Just select the column next to which you want to add entire column. So pressing control and space-bar key select the column and then press control and (+) plus sign on keyboard in order to add the column.
How to delete any cells or cells to left.
For deleting any cells just go to that particular cell and press control and (-) minus sign on keyboard. A small dialog box will appear with name "Delete". So press shift cells up option if you want move the data typed below to the selected cell or press shift cell left. If you want the data to the left to be replace with select cell.You can even delete entire row as well as column using this option.
For deleting any cells just go to that particular cell and press control and (-) minus sign on keyboard. A small dialog box will appear with name "Delete". So press shift cells up option if you want move the data typed below to the selected cell or press shift cell left. If you want the data to the left to be replace with select cell.You can even delete entire row as well as column using this option.
How to Auto-sum (Total ).
Select the number of which want add total. For selecting the number just go to that particular number and shift key. Then press down arrow key (select from top only) and press Alt and (=) equal to sign key. so that total will be automatically calculated.
For more details you can watch our video
Select the number of which want add total. For selecting the number just go to that particular number and shift key. Then press down arrow key (select from top only) and press Alt and (=) equal to sign key. so that total will be automatically calculated.
0 Comments