Video:Top Excel Keyboard Shortcutswith Nick Richards
Knowing the keyboard shortcuts in Excel can save a lot of time. Watch this About.com video to see what they are and how to use them.See Transcript
Transcript:Top Excel Keyboard Shortcuts
Hi, I'm Nick and today for About.com, I'm going to teach you some of the best keyboard shortcuts in Excel 2010.
Basics About Using Excel Keyboard Shortcuts
To get started, you'll want to have a spreadsheet open in front of you, so press ctrl+N to create a new spreadsheet, or ctrl+O to open an existing document.
Useful Shortcuts in Excel
One of the most valuable shortcuts in Excel 2010 is the alt key. Pressing alt will display labels next to each item in the ribbon, making navigation quick and easy. For example, press N to open the Insert ribbon and then press X to open a new text box. Let's get rid of that text box again by pressing ctrl+Z – the undo shortcut.
To add a comment to a selected cell, press shift+ F2. Comments will be marked by a red triangle and can be viewed by moving your mouse over the cell.
To insert the current date into a cell, press ctrl+;. To insert the current time, enter press ctrl+shift+:.
To hide a selected row from view, press ctrl+9. To hide a selected column, press ctrl+0.
Ctrl+K allows you to insert a hyperlink to a selected cell, while ctrl+H opens up the Find and Replace window for quick searching.
A really useful shortcut to remember is alt+F1, which instantly creates a chart out of a range of selected cells.
If you're struggling with Excel and need a bit of support, press F1 to open the Help window.
Now you know some of the best keyboard shortcuts for Excel 2010. For more tips and tricks, visit Compute.About.com.