Skill Components of the Function Purpose Steps to do it Formatting View—Window: Freeze Panes icon select Freeze panes To keep an area of an excel worksheet visible while scrolling to what want to freeze another area. Alternate (for MAC 2016 only): on top task bar freeze panes ‘Window’ Dates vs. Dates can change excel values to Home—Cells: Format Format Cells Primary: – numbers vs. appear as a date and specify the type select type of formatting text of date format Numbers can specify type of format Alternate: – (percentage, currency, etc.) Right click Format Cells Date (or number or Text so that information (including – % or whatever) numbers) in the cell will NOT be treated as a value that can be calculated. Custom Use if want alternative number Home—Cells: Format Format Cells Primary: format not preselected in excel. select custom customize option Alternate: Right click Format Cells select custom customize option Text wrap Use if want text to appear on Home—Alignment: Wrap Text icon Primary: multiple lines within a cell. To create a line break, enter ALT+ENTER. Right click Format Cells Alternate: Alignment Text control
Skill Purpose Steps to do it Components of the Function Formatting Freeze panes To keep an area of an excel worksheet visible while scrolling to another area. View—Window: Freeze Panes icon select what want to freeze Alternate (for MAC 2016 only): ‘Window’ on top task bar freeze panes Dates vs. numbers vs. text Dates – can change excel values to appear as a date and specify the type of date format Numbers – can specify type of format (percentage, currency, etc.) Text – so that information (including numbers) in the cell will NOT be treated as a value that can be calculated. Primary: Home—Cells: Format Format Cells select type of formatting Alternate: Right click Format Cells Date (or number or % or whatever) Custom Use if want alternative number format not preselected in excel. Primary: Home—Cells: Format Format Cells select custom customize option Alternate: Right click Format Cells select custom customize option Text wrap Use if want text to appear on multiple lines within a cell. To create a line break, enter ALT+ENTER. Primary: Home—Alignment: Wrap Text icon Alternate: Right click Format Cells Alignment Text control
aspire_excel_2013_pc_and_mac_2016_guide_final.docx