Top 10 Keyboard tricks in Word & Excel that boost your productivity

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.

f2-ribbonaccessnew-100532168-origShortcut keys help provide an easier and faster way of navigating windows. They increase your productivity and make Word a more seamless and smooth experience.

  1. 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.Undo and Redo

  1. 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.

  1. 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.

For Paste, it’s Alt-H-V-K for Home, Paste, Keep Source Formatting in Word, and Alt-H-V-P for Home, Paste, Paste in Excel.Cut, Copy, Paste

  1. 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.

  1. 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.

  1. 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.

  1. 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.Print and Print Preview

  1. GoTo

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).GoTo

  1. Home

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.

  1. End

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.

EndIn 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.