Excel: Tips and Tricks

Introduction

• Save time in Excel

• Enter data or formulas in nonadjacent cells simultaneously
• Copy data or formulas down a column
• Instantly enter today's date or time
• Convert formulas to values with a simple drag
• Display all worksheet formulas
• Create charts with these keystroke shortcuts
• Zoom in and out quickly

• Access ribbon commands with Alt key sequences
• Expand and collapse the ribbon and full-screen views

• Create split screens and frozen titles in a flash
• Restore missing labels and hide repeating labels
• Customize the display of status bar totals

• Navigate between workbooks and worksheets efficiently
• Navigate within worksheets efficiently
• Open, close, save, and create new workbooks with keystrokes
• Select an entire row, column, region, or worksheet
• Select noncontiguous ranges and visible cells only

• Accelerate data entry
• Enter dates and date series efficiently
• Enter times and time series efficiently
• Use custom lists for data entry and list-based sorting
• Enhance editing tools

• Accelerate copy and move tasks within cells and worksheets
• Drag and insert cells with the Shift key
• Display the Paste Special options
• Accelerate copy, move, and paste actions with the right mouse button

• Create formulas rapidly
• Select all dependent or precedent cells
• Use AutoSum shortcuts
• Count the number of unique entries
• Use conditional formatting to highlight formula cells
• Perform calculations without formulas

• Insert, delete, hide, and unhide columns and rows
• Realign imported text
• Select and manipulate blank cells
• Collapse and expand detail with group and ungroup buttons
• Create double-spaced or triple-spaced printouts

• Use keystroke shortcuts for frequently needed numeric formats
• Accentuate data with alignment tools
• Add a color background to every fifth row in a range
• Use conditional formatting based on comparison criteria
• Use special formats for times over 24 hours
• Add and remove strikethrough and borders with keystroke shortcuts
• Display values in thousands or millions without formulas
• Format phone and social security numbers

• Clean up spaces with the TRIM function
• Split column data using Text to Columns and Flash Fill
• Join data with the TEXTJOIN function and Flash Fill
• Insure unique entries with data validation rules
• Display unique items from large lists
• Use new rich data types (Office Insiders)

• Manipulate chart placement and sizing with dragging techniques
• Create chart titles from cell content
• Create and manipulate shapes with the Shift, Ctrl, and Alt keys
• Create linked dynamic and linked static images

• Adjust report layouts to allow totals on top or bottom
• Revisit relevant source data with the drill down feature

• Become a more proficient Excel user with these short tips

• Next steps