How to make money by Microsoft Excel report by using shortcut keys
There are always demand of MIS report and DashBoard Report in office.MS Excel is best tools for generating various type of storing data and report generation.You can manipulate your report just like your own choice there are no restriction or validation.There are many demand for MS Excel experts in various office with high salary package.If you are expert in generating various MIS report in Excel Sheet then you can get job in office easily and earn handsome salary package.
How to Become Master in Excel Worksheet by using shortcut keys and earn money.When you use mouse for select command it take too much time and it reduce your productivity,for very fast working in excel sheet and generating report always use shortcut keys.I am working in Excel Sheet for generating various types of MIS reports.I remember the shortcut keys it saved valuable time and Improved my working efficiency.
Here I am explaining about shortcut keys for your ready reference and remember these shortcut keys and use in excel sheet.These shortcut keys are working in all version of Microsoft Excel.
These Shortcut Keys apply in the following version of MS Excel:
MS Excel2003,
MS Excel2007,
MS Excel2010,
MS Excel2013.
These Shortcut Keys and details for Remembering:
Excel Shortcut Keys and its function keys, always open this site when you work on excel sheet:
| ShortCut Keys | ShortCut Keys Function |
| Ctrl+ A | Select all content of Worksheet |
| Ctrl+ B | Bold all letter and sentence |
| Ctrl +C | For copy the content |
| Ctrl +D | Fill the content from Top to Button |
| Ctrl +F | Search the current sheet Find command |
| Ctrl+ G | Go To select a range, cell reference of special cell |
| Ctrl+ H | Find and select |
| Ctrl+ I | Convert character to italics font. |
| Ctrl+ K | For selecting address of Hyperlink |
| Ctrl+ P | Print command for direct printing to printer |
| Ctrl+ R | when your left cell is filled with yellow color then your current cell all filled with the same colour(Left to Right filled) |
| Ctrl+ S | For Save worksheet |
| Ctrl+ U | For underline the text |
| Ctrl+ V | For pest the selected word in current cell where cursor click |
| Ctrl+ W | For closing the current worksheet it ask for save. |
| Ctrl+ X | Cuts the selecte word from cell |
| Ctrl+ Y | Repeat the last entry,when by mistake deleted or reversed |
| Ctrl+ Z | Undo the last action or last command |
When you start any new formula then always use = (Equal to)sign and select column range.
We can give command also from number Keys but use Toggle Key pad for number, never use only number key pad it will not work.For using Shortcut Key always select the cell or worksheet,these command only work on selected cell range of worksheet.
Remember the Following Numeric Shortcut Keys for speedy work:
Ctrl+0 For Hide columns
Ctrl+1 For cell Format
Ctrl+2 For Bold letter
Ctrl+3 For Italic words
Ctrl+4 For Underline words
Ctrl+5 For Strike the letter.
Ctrl+6 For show or Hide the object.
Ctrl+7 For show of Hide ToolBar.
Ctrl+8 For create or hide outline symbol.
Ctrl+9 For hiding selected Row.