9 views
Excel Hacks day 2
The word excel means to be very good at doing something. And MS-Excel proves this. One can not imagine what magic can excel does to your data from organisation and calculation to analysis and presentation.
Some new tricks for the day
If you have finished writing in a cell but want to remain in that cell only then don’t press the tab or enter. As tab will shift you on the right cell and enter will shift you on the downward cell. So what to do?
Use Control+enter this will help you to stay in that cell only.
If by mistake you delete the contents of the cell then press the Escape key to recover back the content.
If you want to continue typing in a cell already containing data then use F2(Fn+F2) to continue your typing without disturbing what you have written earlier.
Some shortcuts for the day
Control+B or Control+2: For making the content bold.
Control+I or Control+3: For making the data Italic.
Control+U or Control+4: For underlining the cell content.
Control+C: To copy the data
Control+V: To paste the copied data
Control+Z: Undo
Control+Y: Redo
Control+Mouse scroll button: Zoom in and zoom out
Control+T: To insert table
Control+D: D stands for duplicate. So this shortcut will help you to copy the data of the immediate preceding cell.
Control+Shift+1: To convert the cell formatting to number format.
Control+Shift+2: To convert the cell formatting to time format.
Control+Shift+3: To convert the cell formatting to date format.
Control+Shift+4: To convert the cell formatting to currency format.
Control+Shift+5: To convert the cell formatting to percentage format.
Control+Shift+6: To convert the cell formatting to scientific format.
Control+Shift+7: To insert borders.
To find these options directly in excel go to the home tab and visit the numbers group there.
By the way, excel is itself a teacher if you want to learn. Just move the cursor on a particular option and excel will explain what that function does along with its shortcut keys. Isn’t it great? So what are you waiting for? Just start your excel journey today.
© All Rights Reserved
Some new tricks for the day
If you have finished writing in a cell but want to remain in that cell only then don’t press the tab or enter. As tab will shift you on the right cell and enter will shift you on the downward cell. So what to do?
Use Control+enter this will help you to stay in that cell only.
If by mistake you delete the contents of the cell then press the Escape key to recover back the content.
If you want to continue typing in a cell already containing data then use F2(Fn+F2) to continue your typing without disturbing what you have written earlier.
Some shortcuts for the day
Control+B or Control+2: For making the content bold.
Control+I or Control+3: For making the data Italic.
Control+U or Control+4: For underlining the cell content.
Control+C: To copy the data
Control+V: To paste the copied data
Control+Z: Undo
Control+Y: Redo
Control+Mouse scroll button: Zoom in and zoom out
Control+T: To insert table
Control+D: D stands for duplicate. So this shortcut will help you to copy the data of the immediate preceding cell.
Control+Shift+1: To convert the cell formatting to number format.
Control+Shift+2: To convert the cell formatting to time format.
Control+Shift+3: To convert the cell formatting to date format.
Control+Shift+4: To convert the cell formatting to currency format.
Control+Shift+5: To convert the cell formatting to percentage format.
Control+Shift+6: To convert the cell formatting to scientific format.
Control+Shift+7: To insert borders.
To find these options directly in excel go to the home tab and visit the numbers group there.
By the way, excel is itself a teacher if you want to learn. Just move the cursor on a particular option and excel will explain what that function does along with its shortcut keys. Isn’t it great? So what are you waiting for? Just start your excel journey today.
© All Rights Reserved
