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

Related Post



13 komentar:

harry fall said...

Intersting and beautiful blog lovely presentation thanks for sharing your views...microsoft excel support|Excel Support|microsoft excel 2010

Anonymous said...

Ε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

Anonymous said...

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

Anonymous said...

Ι'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

Anonymous said...

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

Anonymous said...

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

Look іnto my page: fast online loans

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

my homepage; loans site

Anonymous said...

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

Anonymous said...

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

Fangyaya said...

adidas stan smith
true religion shorts
michael kors outlet online
michael kors outlet
cheap jordans
nike basketball shoes
christian louboutin shoes
louis vuitton bags
gucci outlet
louis vuitton outlet
coach outlet
louis vuitton outlet
nike huarache shoes
rolex submariner
coach factory outlet
nike roshe run
timberland outlet
nike trainers
kobe shoes 11
pandora jewelry
tory burch handbags
fitflops sale clearance
ray ban sunglasses outlet
coach outlet store online
louis vuitton
air jordans
louis vuitton
gucci outlet
true religion jeans
abercrombie
nike air force
louis vuitton outlet
michael kors outlet
coach factory outlet
tory burch outlet
jordan retro 3
christian louboutin outlet
replica watches
michael kors outlet
michael kors outlet
20167.13chenjinyan

Post a Comment

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