To undo your last action, press Ctrl+z; to undo the action before that, press Ctrl+z again; press Ctrl+z repeatedly to undo as many as 100 of your last actions. Sometimes, after undoing ng an action, you might want to reconsider that action and "undo the undo" (redo) - press Ctrl+y. Also use Ctrl+y to repeat an action.
- [Voiceover] A really valuable feature in Excel…is your ability to Undo an action.…And not just your last action,…but possibly actions before that as far back…as 100 actions.…You can Undo up to 100 of your last actions in Excel.…And sometimes you'll change your mind…and after having undone an action you might want to Redo it.…And these are available by way of keystroke shortcuts.…I'm working with a worksheet here called Formulas…and I'm about to insert a new column to…the left of Column B.…
So I'll right click Column B and Insert,…but I mistakenly choose Delete.…It's pretty obvious that's caused big problems…in Formulas here.…I surely don't want to continue here…before I correct this.…Ctrl z will Undo the action.…Now I certainly don't want to Redo it,…but if I press Ctrl y,…that will Undo the Undo.…In this example here that would not be…a good use of it.…Now keep in mind you also have an Undo button…and a Redo button in your Quick Access Toolbar.…So at the top of the screen here if you…wanted to reconsider here,…
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: Undo, redo, and repeat with keystrokes