Vertical text Can be helpful if you are trying to Primary: Home—Alignment: ab icon conserve width in your spreadsheet. select vertical text Alternate: Right click Format Cells Alignment Orientation change from 0 to 90 degrees Adds certain functionality to the Home—Styles: Format as Table pick Convert to a Primary: table spreadsheet (such as shading a color/style you like alternate lines, easy sorting and Insert—Tables: Table icon select Alternate: filtering, auto-applying formulas to area that you want to include in your table entire column, etc.) Step 1: Highlight cells you wish to format Conditional Allows you to highlight certain cells in formatting excel depending on their value. Can Step 2: Home—Styles: Conditional be used to quickly highlight Formatting New Rule only cells that “Format important information in your contain” spreadsheet. Step 3: Select Cell Value, choose condition, insert value, choose format; go to fill and click color Data Validation Tools Data Data tools data Validation icon data Drop-down Used to restrict entries to – validation Allow: List, Source: type options list specified items (list). Can make data entry easier and more uniform in NOTE: Can add to the list later if needed, just excel. check the box these changes to all other “Apply cells with the same settings” Only numbers Used to restrict values into excel Data—Data Tools data validation icon data to only numbers. validation Allow: Whole number OR decimal
Vertical text Can be helpful if you are trying to conserve width in your spreadsheet. Primary: Home—Alignment: ab icon select vertical text Alternate: Right click Format Cells Alignment Orientation change from 0 to 90 degrees Convert to a table Adds certain functionality to the spreadsheet (such as shading alternate lines, easy sorting and filtering, auto-applying formulas to entire column, etc.) Primary: Home—Styles: Format as Table pick a color/style you like Alternate: Insert—Tables: Table icon select area that you want to include in your table Conditional formatting Allows you to highlight certain cells in excel depending on their value. Can be used to quickly highlight important information in your spreadsheet. Step 1: Highlight cells you wish to format Step 2: Home—Styles: Conditional Formatting New Rule “Format only cells that contain” Step 3: Select Cell Value, choose condition, insert value, choose format; go to fill and click color Data Validation Tools Drop-down list Used to restrict entries to items (list). Can make data entry easier and more uniform in excel. Data – Data tools data Validation icon data validation Allow: List, Source: type options NOTE: Can add to the list later if needed, just check the box “Apply these changes to all other cells with the same settings” Only numbers Used to restrict values into excel to only numbers. Data—Data Tools data validation icon data validation Allow: Whole number OR decimal specified