Data Cleaning with Excel

Excel features many keyboard shortcuts that will help you save time while navigating spreadsheets. These include:

Moving around quickly in a worksheet

• Ctrl (Cmd for Mac) + right arrow: move right
• Ctrl (Cmd for Mac) + left arrow: move left
• Ctrl (Cmd for Mac) + down arrow: move to bottom of a column
• Ctrl (Cmd for Mac) + up arrow: move to top of a column
• Ctrl (Cmd for Mac) + f (Find): Brings up a dialog box to type the string of characters you'd like to find

Copying/Pasting

• Ctrl (Cmd for Mac) + c: Copy
• Ctrl (Cmd for Mac) + v: Paste
• Ctrl (Cmd for Mac) + Alt + v: Paste special. Choose specific conditions for the paste operation.
• Ctrl (Cmd for Mac) + z: Undo

Quick Access to Menus

• Ctrl (Cmd for Mac) + 1: Bring up the formatting menu
• Alt + Shift + Tab: Brings up the quick menu to the other programs you have open