You might think you have mastered all the Word and Excel keyboard shortcuts, but you may have missed some of them. These 10 time-saving shortcuts let you keep your hands on the keyboard and off your mouse.
Undo & Redo an action
We all make mistakes while creating an important document or worksheet, the first ones on this list have to be Undo and Redo: Ctrl-Z and Ctrl-Y. For example, if by mistake you cut text, clicking ctrl + Z will undo the change and clicking Ctrl + Y would redo the Undo. A small arrow curved to the left represents Undo in both Word and Excel. However, in Word, a circular arrow indicates Redo and in Excel the arrow curves to the right.
Find & Replace
Corrections would have been difficult without Find (ctrl+F) and Replace (ctrl+H). Ribbon shortcuts are Alt+H+F+D+F for Home, Find to open Find in both Word and Excel.
Cut, Copy, Paste
For copying a selected text, we use Ctrl+C , and for pasting it at a particular place we use Ctrl+V. The ribbon shortcuts for these tasks are Alt+H+C for Home, Copy (Alt+H+c+C for Home, Copy, Copy in Excel) and Alt+H+X for Home, Cut in both Word and Excel.
Delete a full word
Using ctrl+Backspace will delete a full word at once instead of a single character.
In Excel, Ctrl+ Backspace clears the content of the active cell.
Move the cursor one word at a time
To move the cursor on word at a time, hold down the Ctrl key while pressing the left or right arrow.
In Excel, Ctrl+arrow keys move the cursor to the edge of the current data region.
Select a word or select All
Ctrl+A selects an entire document or a spreadsheet that needs to be copied, cut or deleted. The ribbon shortcut is Alt+H+S+L+A.
To select a word, place the cursor on that word and double click it. Three times click will select the entire paragraph. In Excel, place the cursor on any cell and double click to edit the cell contents.
Print & Print Preview
Ctrl+P prints the document or spreadsheet. Ctrl+F2 takes you to Print Preview. The Ribbon shortcut is Alt-F-P for both File, Print and Print Preview, because when you select Print, the Preview displays as well.
Navigation becomes quite tough with bigger documents and spreadsheets. The only Navigation command on the Ribbon version is the Go To feature, which means navigate to a specific cell address or navigate to a specific page. It’s Ctrl-G or F5, followed by a dialog box that opens for additional input—the same dialog boxes as the Ribbon shortcuts. For the Ribbon version, it’s Alt-H-F-D-G (Home, Find, GoTo).
In Word, Home places the cursor to the beginning of the line or row. For example, if your cursor is on the fifth word of the fourth line, Home takes the cursor to the beginning of the document.
In Excel, Home places the cursor at the beginning of that line or row. Ctrl+H takes the cursor to cell A1.
In Word, the End key takes the cursor to the end of a line. Ctrl+End will shift the cursor to the end of a document.
In Excel, End has various functions. In the Edit Mode, End shifts the cursor to the end of a line only inside a text or formula cell. End accompanied by any cursor key shifts the cursor to the last occupied cell in a column or row of data just before a blank, empty cell. For example, if the cursor is in A1 and the entire column contains empty cells, End-Down Arrow shifts the cursor to the bottom of the entire workbook. The same rule applies horizontally: If an entire row is full of blank cells, your cursor is pointing at A1, and you select End-Right Arrow, the cursor shifts to column XFD, row 1.