Formatting Tricks in Excel

This 12 minute demo covers a variety of format-related functions to make it easier to view and use a dataset in  Excel.   You can watch the whole thing, or let the video load and skip to a section (look for a blue slide at the start of each). Tips include:

• Shortcuts to widen columns
• Applying shading and other formats
• Wrapping text in a cell so you see it all
• Using 'insert data table' to provide instant formatting
• Hiding data that you don't want to see
• Freezing data, while allowing other parts to move
• Changing view setting if you don't want to see grid lines
• Inserting comments