3/4/11

Microsoft Excel Shortcut Keys

This time I will discuss about Microsoft Excel, a program that I use every day from 8 am to 4 pm but instead I had never even discuss it.
And in this post I will explain about the Shortcut Keys in Microsoft Excel which I can from http://komputertipstrik.blogspot.com
Just as in other Microsoft Office programs, in Microsoft Excel so that even if we wanted faster in completing a work / typing / data entry, on certain commands will be faster when using a shortcut key (shortcut),
Here is a list of shortcut keys for Ms Excel:



1 Ctrl + A :selects the entire contents of the worksheet. (Select all)
2 Ctrl + B : to Make Bold areas / selected cell
3 italic Ctrl + I : Create area / cell selected
4 Ctrl + K : Insert link.
5 Ctrl + U : Make underscore areas / selected cell
6 Ctrl + P : Displays the Print dialog box to start printing.
7 Ctrl + Z : Cancels step / last action.
8 F2 : Edit the selected cell
9 F5 : Go to a specific cell. For example, E7.
10 Shift + F5 : Bring Forth the search box
11 F7 : Checking the spelling of the selected text and / or documents
12 F11 : Create chart
13 Shift + F3 : Open the Excel formula window
14 Ctrl + Shift +; : Enter the current time.
15 Ctrl +; : inclusion of date.
16 Alt + Shift + F1 : Create a new Worksheet.
17 Ctrl + 5 : make strikethrough cells / selected area
18 Ctrl + F9 : Minimize the window
19 Ctrl + F10 : Maximize the window
20 Ctrl + F6 : Switch between the open excel file
21 Ctrl + Page up : Choosing Sheet to the left
22 Ctrl + Page Down : Select the Sheet to the right
23 Ctrl + Tab : Switch between two or more open Excel files
24 Alt + = : Create a formula for the number of all cells above
25 Ctrl + ': Enter the value above into the cells of the selected cell.
26 Ctrl + Shift +! : Format number in comma format.
27 Ctrl + Shift + $ : Format number in currency format.
28 Ctrl + Shift + # : Format number in date format.
29 Ctrl + Shift +% : Format number in percentage format.
30 Ctrl + Shift + ^ : Format number in scientific format.
31 Ctrl + Shift + @ : Format number in time format.
32 Ctrl + Arrow key : Move to next section of text.
33 Ctrl + Space : Select entire column.
34 Shift + Space : Select entire row.
Hopefully useful ..

Translated from:
http://komputertipstrik.blogspot.com

12 comments:

  1. Εvery ωeeκеnd i used to visit thіs site,
    fοг the rеason that i wish for enjoyment,
    for the reason that this this web site сonations in
    fact fastidіous funny dаta too.

    Fеel freе to surf to my blοg - secured loans online

    ReplyDelete
  2. I've been browsing for a helpful discussion on this for ages, and this has been a perfect help. I shall be getting this tweeted for defs.

    Look into my web site :: loans site

    ReplyDelete
  3. Ι'm trying to nourish a similar place to this myself, there's
    clеаrly a lοt of woгκ
    that goes into it. Really intelligent cοmmunitу hеre, not еasy to achіеve.


    Herе is mу ωeb page: fast cash payday loans uk

    ReplyDelete
  4. Right now I feеl like I сould read about this
    for agеѕ, it's absorbing. I don't even need a tеа yet.


    my weblog fast cash advance loans

    ReplyDelete
  5. We are аll a suсkеr for an octoрus.
    Ha ha ha...

    Look іnto my page: fast online loans

    ReplyDelete
  6. Neeԁ some еxtrа content on this - any recсοmenԁatіоns сovеring who I might read or whаt websites I
    might go tο??

    Alsο visit mу blog - Unsecured personal Loans

    ReplyDelete
  7. I'm trying to nourish a similar community to this myself, there's clearlу a lot
    of effort that goes іnto іt. Really vibrant community too,
    not easy to build.

    Also vіsіt my website ... personal loans bad credit

    ReplyDelete
  8. So itѕ questiοn timе, ԁo I gеt thе chance to
    аsk а challеngіng questіοn?


    Fеel free to ѕurf to my site :: bad credit fast cash loans

    ReplyDelete
  9. I've seen so many comments on this that I could not be much more confused.

    my homepage; loans site

    ReplyDelete
  10. Can't decide if I should take out a book on this myself, or just read a few articles. Can there be that much to it?

    Here is my web page; bad credit personal loans

    ReplyDelete
  11. In my view, thеre's no point getting out of bed for less than a grand, so this doesn't
    seem to be ωoгth it to me.

    mу wеblog :: fast cash loan company

    ReplyDelete

Please leave a comment here
Comment spam and other promotions will be deleted