If you right-click the Quick Access toolbar, you have an option to customize it in a variety of ways in the Excel Option dialog box, selecting from a huge list of command icons representing Excel tools and features. You can also right-click any icon in the ribbon menu system and add it to the Quick Access toolbar.
- [Voiceover] The Quick Access Toolbar appears…above the ribbon menu system in the upper…left corner of your screen.…If you've just installed Excel, or if you've…not used this feature, you'll see three buttons in it.…The one to the left is a button for save…notice the keyboard shortcut there too.…Next one is undo, it too has a keystroke shortcut.…And also to the right of that redo…for the moment we can't use it.…But you can add buttons to this.…And the general idea is this is for features…that you use frequently that you always…want to have available.…
The Quick Access Toolbar can be changed…in a number of different ways.…The right most button, the drop arrow…gives us some choices.…It might be convenient to have a file open button here…so let's add open.…Some of the other choices here you might consider as well…maybe print preview, that's another one.…And if you do sorting a lot maybe ascending…sorting is more common you might make that choice as well.…And all we're doing here is putting additional buttons…on the Quick Access Toolbar.…
Author
Dennis Taylor
Released
4/21/2016The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple drag
- Undoing and redoing with keyboard commands
- Accessing the Ribbon from the keyboard
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Dragging and dropping data
- Performing calculations without formulas
- Applying formatting with keyboard shortcuts
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome33s
-
-
1. Top 10 Shortcuts
-
Zoom in and out quickly3m 23s
-
2. Ribbon and Quick Access Toolbar Tips
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigate within worksheets7m 10s
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerate data entry9m 54s
-
Enhance editing tools3m 40s
-
-
7. Drag and Drop Techniques
-
8. Formula Shortcuts
-
Create formulas rapidly6m 26s
-
Use AutoSum shortcuts3m 53s
-
Use rounding shortcuts5m 30s
-
Generate random numbers5m 3s
-
-
9. Operational Shortcuts
-
Re-align imported text5m 44s
-
10. Formatting Shortcuts
-
11. Data Management Techniques
-
12. Charting and Visual Object Tips
-
13. Ten Tiny Tips
-
Conclusion
-
Goodbye33s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Adjust the Quick Access Toolbar