![]() ![]() ![]() Shift + Ctrl + Arrow Keys: Select to Boundary (same in Mac Excel) 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |