Tuesday, 3 September 2013

Microsoft Excel 2007 shortcut keys

I will show you very easy formula for sum
Type your values
Select the value with one extra row and press "Alt+"

Multiply or product
Type value 
 20          20        
Press “=” key, move cursor by using arrow keys on column and then Press “*” key and again move cursor to next column n press enter.  See below video to how its work.

List of all major shortcut keys  in Microsoft Excel 2007.  
Ctrl+9                             Hide rows.
CTRL+0                         Hide columns.
CTRL+B                        Bold formatting.
CTRL+D                        Fill Down command to copy the content
CTRL+F                         Find and Replace
CTRL+I                          Italic formatting.
CTRL+N                        Creates a new
CTRL+O                        Open
CTRL+P                         Print
CTRL+S                         Save file
CTRL+U                        Underline
CTRL+PgUp                  Switches between worksheet left to right.
CTRL+PgDn                  Switches between worksheet right to right.
CTRL+SHIFT+(            Unhides rows
CTRL+SHIFT+)            Unhides columns
Ctrl + shift +                   Insert the column & row
F2                                  Edit cell
F7                                  Check spelling
F11                                Creates a chart of selected data
F12                                Display save as

See my video for more shortcuts


the impossible quiz said...

Thank you for sharing this helpful guide. I need such information

The Impossible Game said...

If you are looking for a solution to relax then The Impossible Game will be the best choice today! This is a website with hundreds of games to satisfy your passion, and will satisfy the most demanding players!

Unknown said...

Everything is unguarded with a wary clarification of the troubles. It was really instructive. Your site is significant. Thankful for sharing!Utsav7fun