by Not Zero | 10:07 pm

 

Shortcut
Description
F2
Edit the selected cell.
F3
After a name has been created, F3 will paste names.
F4
Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5
Go to a specific cell. For example, C6.
F7
Spell check selected text or document.
F11
Create chart from selected data.
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Alt + Shift + F1
Insert New Worksheet.
Alt + Enter
While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3
Open the Excel formula window.
Shift + F5
Bring up search box.
Ctrl + 1
Open the Format Cells window.
Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + S
Save the open worksheet.
Ctrl + U
Underline highlighted selection.
Ctrl + 1
Change the format of selected cells.
Ctrl + 5
Strikethrough highlighted selection.
Ctrl + P
Bring up the print dialog box to begin the printing process.
Ctrl + Z
Undo last action.
Ctrl + F3
Open Excel Name Manager.
Ctrl + F9
Minimize current window.
Ctrl + F10
Maximize currently selected window.
Ctrl + F6
Switch between open workbooks or windows.
Ctrl + Page up
Move between work sheets in the same document.
Ctrl + Page down
Move between work sheets in the same document.
Ctrl + Tab
Move between Two or more open Excel files.
Alt + =
Create a formula to sum all of the above cells.
Ctrl + ‘
Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1
Format number in comma format.
Ctrl + Shift + 4
Format number in currency format.
Ctrl + Shift + 3
Format number in date format.
Ctrl + Shift + 5
Format number in percentage format.
Ctrl + Shift + 6
Format number in scientific format.
Ctrl + Shift + 2
Format number in time format.
Ctrl + Arrow key
Move to next section of text.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.
Ctrl + –
Delete the selected column or row.
Ctrl + Shift + =
Insert a new column or row.
Ctrl + Home
Move to cell A1.
Ctrl + ~
Switch between showing Excel formulas or their values in cells.

Post Comments

comments

Comments

sprinter unblocked game,

Tɦiѕ is a gгeat tiⲣ partіcularly to those fresh
to tһe blogosphere. Simple Ƅut very accrate infߋrmation… Μany thankѕ fоr sharing thiѕ one.
Amust rеad article!

Apr 25.2017 | 07:11 pm

financial advisor business

Superb website you have here but I was curious if you knew of any community forums that cover the same topics talked about here? I’d really like to be a part of community where I can get responses from other knowledgeable people that share the same interest. If you have any suggestions, please let me know. Bless you!|

May 07.2017 | 11:59 pm

advice on employment contracts

Magnificent items from you, man. I have consider your stuff previous to and you’re simply too wonderful. I really like what you’ve bought right here, certainly like what you’re saying and the way in which wherein you assert it. You are making it entertaining and you still care for to keep it smart. I cant wait to learn much more from you. This is actually a tremendous site.|

http://employmentclue.eu/

May 08.2017 | 12:06 am

home family recipes

Hello there! Do you use Twitter? I’d like to follow you if that would be ok. I’m undoubtedly enjoying your blog and look forward to new updates.

http://homeandfamily.eu/

May 08.2017 | 02:17 am
    Not Zero

    Not Zero

    yes kindly use follow us link on header

    May 08.2017 | 05:55 pm

online degrees

Spot on with this write-up, I truly think this amazing site needs a lot more attention. I’ll probably be back again to read through more, thanks for the advice!

http://learningclue.eu/

May 08.2017 | 03:28 am

health

I’m not sure why but this website is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later on and see if the problem still exists.

May 08.2017 | 05:45 am

small business financing

Heya! I realize this is sort of off-topic but I had to ask. Does managing a well-established blog like yours require a large amount of work? I am completely new to running a blog however I do write in my diary everyday. I’d like to start a blog so I can easily share my personal experience and views online. Please let me know if you have any kind of recommendations or tips for new aspiring blog owners. Thankyou!

http://businessclue.eu/

May 10.2017 | 05:37 am
    Not Zero

    Not Zero

    i am also a new at blogging and for managing a blog you have to work hard as required regular research work. always learn to improve your blog and also post new things and be regular and committed to your work.

    May 10.2017 | 04:57 pm

education online courses

I’m really enjoying the design and layout of your blog. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Great work!

http://educationclue.eu/

May 11.2017 | 07:47 am

seo plugin

Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

Jun 02.2017 | 05:08 am

pay day loans

Why users still make use of to read news papers when in this
technological world all is presented on net?

Jul 07.2017 | 10:38 am

payday loans

Hi there to every , as I am actually keen of reading this weblog’s post to be updated
on a regular basis. It consists of nice information.

Jul 07.2017 | 11:53 am

blogs

Heya i am for the first time here. I came across this board and I find It really useful & it helped me out much.

I hope to give something back and aid others like you helped me.

Aug 15.2017 | 04:17 am

강친

I believe that is among the so much important information for me.
And i’m happy studying your article. However should observation on some common things, The website taste is ideal,
the articles is really excellent : D. Good job, cheers

Jun 14.2018 | 06:18 am

Leave a Reply

Your email address will not be published. Required fields are marked *