10 Most useful Excel Keyboard Commands

-

The shortcuts

Action Shortcut
Insert a new line within a cell[Alt] [Enter]
Enable editing within a cell [F2]
Add a comment to a cell[Shift] [F2]
Open Print Preview[Ctrl] [F2]
Fill selected cells with an entry you typed in one cell [Ctrl] [Enter]
Fill data down or to the right through selected cells[Ctrl] D or [Ctrl ] R
Create a name[Ctrl [F3]
Insert the current date or timeCtrl] and ; (semicolon) or Ctrl and : (colon)
Create a chart from a range of data[F11]
Toggle the display of formulas[Ctrl] ~


Comments

Post a Comment

Popular posts from this blog

Written by a 90 year old...the 45 lessons life taught me.

-
Image
This is something we should all read at least once a week!!!!! Make sure you read to the end!!!!!! Written by Regina Brett, 90 years old, of the Plain Dealer, Cleveland , Ohio . "To celebrate growing older, I once wrote the 45 lessons life taught me. It is the most requested column I've ever written. My odometer rolled over to 90 in August, so here is the column once more: 1. Life isn't fair, but it's still good. 2. When in doubt, just take the next small step. 3. Life is too short to waste time hating anyone. 4. Your job won't take care of you when you are sick. Your friends and parents will. Stay in touch. 5. Pay off your credit cards every month. 6. You don't have to win every argument. Agree to disagree . 7. Cry with someone. It's more healing than crying alone. 8. It's OK to get angry with God. He can take it. 9. Save for retirement startin...
Read More

Fwd: Fw: complete vs. finished

-
No dictionary has ever been able to define the difference between "complete" and "finished". However, in a linguistic conference,   held in London England, and attended by some of the best linguistics in the world, Samsundar   Patel , was the clever winner. His final challenge was this. Some say there is no difference between "complete" and "finished". Please explain the difference in a way that is easy to understand.  His response was: When you marry the right woman, you are "complete". If you marry the wrong woman, you are "finished". And, when the right one catches you with the wrong one, you are "completely finished".       His answer received a five minute standing ovation.
Read More

Fwd: Fw: Fwd: Prayers do nourish!

-
Subject: Prayers do nourish! Prayers do nourish! A 'devotee' wrote a letter to the editor of an Indian newspaper and complained that it made no sense to go to the Temple. 'I've gone for 30 years now, he wrote, and in that time I have heard something like 3,000 mantras. But for the life of me, I can't remember a single one of them. So, I think I'm wasting my time and the Gurus are wasting theirs by giving services at all. This started a real controversy in the 'Letters to the Editor' column, much to the delight of the editor. It went on for weeks until someone wrote this clincher: "I've been married for 30 years now. In that time my wife has cooked some 32,000 meals. But, for the life of me, I cannot recall the entire menu for a single one of those meals. But I do know this... They all nourished me and gave me the strength I needed to do my work. If my wife had not given me these meals, I woul...
Read More