By Mahima Sharan19, Aug 2023 03:26 PMjagranjosh.com
SELECT A ROW AND A COLUMN
Many times, while selecting columns, we tend to delete data in the cell. Use this shortcut to convince. ROW: SHIFT + SPACE , COLUMN: CTRL + SPACE
TO GET THE SUM OF A COLUMN
After entering the data, use the below-mentioned shortcut key to sum it all up. ALT + E
EXTRACT NAMES FROM EMAILS
Use this shortcut to extract the first and second names from Excel. Extract and write the first one yourself, and then select the column to do it for the rest. CTRL + E
TO INSERT A ROW AND DELETE A ROW
Insert or delete a row after you have entered the data in the range with these shortcuts. INSERT ROW: CTRL + SHIFT + PLUS(+) ,DELETE ROW: CTRL + SHIFT + MINUS(-)
TO INSERT A COLUMN AND DELETE A COLUMN
Insert or delete a column easily with these 2 shortcuts. INSERT - CTRL + PLUS (+) ,DELETE- CTRL + MINUS (-)
TO SWITCH SHEET
You can easily go back and forth between different sheets with these keyboard shortcuts. CTRL + PAGE DOWN CTRL + PAGE UP
INSERT A NOTE
Add extra information to the cell with this shortcut key. SHIFT + F2
आज की नौकरियों में क्यों जरूरी है क्रिएटिव थिंकिंग? जानें