Shift + Spacebar: Select Row (same in Mac Excel) To do that, we will use the following functions and shortcuts: Navigation, Selection, and Row/Column Shortcuts:Ĭtrl + Spacebar: Select Column (same in Mac Excel) We want to separate the entire “Address” for each order into Street Address, City, State, and ZIP Code fields: Our task here is simple: we have customer order data, but the addresses are not presented in an ideal format. How to Clean Data in Excel, Part 1: Typical Tasks, Functions, and Shortcuts We do cover Mac Excel shortcuts in our full Excel & Financial Modeling Fundamental course, but they’re presented in completely separate sets of lessons.īelow, we will list the key PC/Windows shortcuts as well as Mac alternatives. NOTE: This tutorial on how to clean data in Excel uses the PC/Windows version shortcuts.
