Excel Shortcuts You Probably Don't Know
Вставка
- Опубліковано 4 лип 2012
- Excel Shortcuts You Probably Don't Know | Upgrade Your Life
Becky Worley shows time-saving shortcuts to make your spreadsheet workflow faster and easier.
Microsoft Excel is an incredibly powerful spreadsheet program that millions of people use. It's got so many tools in it that even experts don't always know all the shortcuts. But just knowing a few tricks can vastly speed up - and simplify - your workflow.
Note: Different versions of Excel may have different commands, so a couple of these may not work in your version. That said, here are my top Excel shortcuts that can make you a star amongst the spreadsheet crowd:
1. Insert Sum: Alt =
Summing has to be Excel's most commonly used task, and this trick can save you several clicks every time. To sum a column of numbers, select the cell at the bottom of the column. Then, Alt = will insert the sum function.
2. Select an Entire Column: Ctrl-Spacebar
You probably know that Alt-a will select everything on a page, but if you simply want to select one column, hit Ctrl-Spacebar. And if you want to select a single row, use Shift-Spacebar.
3. Navigate to Top: Ctrl-Home
Big spreadsheets can be many pages long. Instead of scrolling, Ctrl-Home takes you back to the first cell: A1. And Ctrl-End takes you to the last cell.
4. Hide Data: Ctrl-0
Sometimes, you just want to hide some data without deleting it. Here's the shortcut for that: select the column you want to hide, then hit Ctrl-0. To unhide it, use Ctrl-Shift-0. (Note: the "0" is the number zero, not the letter O.)
5. Delete a Cell: Alt-E-D
When you want to fully delete a cell, you can certainly right-click and then hit delete, but I find it faster to keep my hands on the keyboard rather than going for the mouse. Alt-E-D. In my mind, it stands for Express Delete.
6. Add Date: Ctrl-Semicolon
Ctrl-Semicolon inserts today's date. Ctrl-Shift-Semicolon inserts the current time.
7. Show Formulas: Ctrl ~
Functions are the math formulas that give Excel its power. They are math equations that Excel computes and displays. Normally, you enter a function either in the formula bar or directly in the cell, and - when you hit enter - it displays the result. Once that's done, the underlying formula becomes hidden from view. But sometimes you need to check those hidden formulas. Sure, you can go back and click every cell to see them, but if you hit Ctrl and the tilde key, all your formulas will be revealed in their cells. Oh, and in case you didn't know, the tilde key is usually in the upper left corner of your keyboard and looks like this: ~
Hi Becky. I really appreciate when someone encourage users to learn keyboard shortcuts. As a trainer I teach all level at least over 30 of them just in Excel. I do have to highlight that to delete a Cell, a Row or a Column Ctrl+Minus key (on keypad) and Enter is easier. As you mentioned Shift+Space (for Row) or Ctrl+Space (for Column) then hit it with Ctrl+Minus.
Once you know that it's simple to remember Ctrl+Plus (on keypad) and Enter to insert row, col.
Thanks for your video.
Daniel
There is no corner to be critisized. Everything stuffed with motivation and inspiration. Its really excitable that fascinates for more and more.
Many many thanks and love you.
Very interactive short cuts.Much appreciated.
Nicely presented!
Danny Rocks
The Company Rocks
Good demonstration!
I just learned a new shortcut. I did not know about the ctrl + O to hide a column. I love the shortcut keys/tips.
When my boss walks in unexpectedly I can quickly hide my column porn.
Thanks very much for these amazing shortcut tips.
Wow clean and neat tricks! Thank you!
Thank you so much for sharing us wonderful tips
Great Tips! Thank you very much!!
Thanks for sharing
Thank you for posting this shortcuts tricks.
wonderful and productive demo
Wow! Action teacher. Nice lesson. Thanks.
Really amazing method of teaching
Thanks for sharing, you are an awesome teacher
Thanks so much. I love this
Too good....very handy and useful!
many many thanks
Really helpful..Thank you..
Thank you so much for sharing
superb shortcut. Realy appreciate
amazing tips...i loved it......please share more if possible
Simplistic and easy to understand .
great tips. thanks!
Awesome time saving shortcuts
Great n easy. Thanks a lot, waiting for more.
Nice tutorial. It helps a lot.
Awesome!! Waiting for next.....
Wonderful short cuts. A wonderfully done video and Becky Worley is a wonderful actress. She has done a wonderful work. Please convey may congratulations for such a nice work. Same to the cameraman and the person who edited the video. Really wonderfully done. A+++++
Very very clear explanation 👌👌👌🤗
smart and useful. Thanks!
Love u for this action tips.👌
Beautiful teacher
Many many thanks.
Thank you! It's good
Really i am happy to see this video, even though I have one more doubt about exactly which key for seperation. my question is which does not come divide (/) key . .It should come (I) like this,Please let me it.
Thanks a lot for sharing....
"Alt+E+D" to delete a particular cell.
How about 'Ctrl' + '-' ???
Its simple & easier to remember.
Similar to this, we can use 'Ctrl' + '+' to add a cell.
Wow very informative video thanks a lot
You are Awsome ;I liked it very much
Awesome tricks.
THANK YOU
Excellent Technic Mam.
Great teacher
This is amazing
Really good and informitive
nice tips
I like it. Thanks
Thank you. I came to know short cut about Selecting Rows/Columns and hiding them.
Thank you.
A Big Thank you
Great, Thanks
Thnk you for sharing
great,
thanks
keep it up
wow very very informative
very very nice !!!!
Really helpful .......
Thank u so much...
Hey, nice tips
nice great work
thnxx dear its real good video
It 's very nice & useful shortcut. Thanks for the video. But be aware if you have Excel App in other languages ( German, French, etc. ). Some shortcuts may not work.
vui vì gặp a trên các diễn đàn excel. sẵn đây cảm ơn những video về excel của a. rất hay!
Lam Vinh Ha :)
+ĐT Nguyễn [Excel]
👍👏
so nice your style is nice you are good teacher for all viewer
And cntrl+E,D is not only for delete the cell value, it also shift the right cell value to left. Its better to use only del key to delete the value only.
Nice and very good
YOU ARE AWESOME
plzz give the percentage formula and u have done awesome work
thank you
very good job madam i appreciate
Cool stuff..
thanks dear
nice vidio
thanks
awesome
very nice
👌👌🤗Amazing
very nice video
Excellent mam
Thank you ma'am
intresting video .
amazing
Awesome
thanks
wow, thanks
cool tricks
And hide a row use Ctrl+9.
How do you bring it back?
Great
O wow very nice teacher
Good video I like mam
thanku so much............|
love it
thanks 😂😁😉
Nice
awesome
Ctrl d copies above cell
Can you use it with 2016 version?
you are awesome lady ,, love you
Thank u madam >>>>
nice
thank
you are grate mam
Pleas thy are way to keep select arrow for example wan i select line 1 and move line 2 all line to selected and wan move line 3 all
line 3 select and stay select in the editing