Some cells may contain a lot of information in the form of multiple paragraphs of text where you may only wish to copy, edit or format a section of the text. It will also ensure your data is consistent as you did not have to re-enter the information. When you work with large amounts of data, knowing how to cut, copy and paste contents from one section into another may save you a lot of time. For example if you bold a word in a cell and select another cell and press Ctrl+y, the bold action will be repeated. You can also use Ctrl+y to repeat certain actions. To redo any actions that you used undo on, press Ctrl+y.

Pressing Ctrl+z repeatedly will undo the last series of actions that you have performed.Ģ. The undo and redo shortcut combinations allow you to undo and redo actions without lifting your fingers from the keyboard.ġ. The redo function acts as a further insurance policy against the undo function and allows you to reinstate actions that you reversed using the undo function. * Shortcuts to Undo and Redo The ability to undo mistakes, unintentional formatting or data entries and edits, is extremely useful. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĮxcel Keyboard Shortcuts for Cell Contents Test * Shortcuts to Display Cell Value or Formula Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to cut, copy, paste, and format the contents of the cells. * Shortcuts to Insert Comments and Hyperlinks * Shortcuts to Cut, Copy, Paste and Edit Cell Contents Excel Tutorial – Keyboard Shortcuts for Cell Contents Tutorial with corresponding Free Online Test – Excel 2010 Keyboard Shortcuts for Cell Contents

Excel keyboard shortcut undo