Articles (12)

Avoid Merging Cells

Center across cells to save on sorting and formatting issues

Conditional Formatting

Use conditional formatting to highlight info

Flash Fill

Let Excel automatically fill data when it senses a pattern

Freeze Panes for Scrolling

Keep parts of your worksheet visible while scrolling!

How to Transpose Data

Use Transpose to flip data on its side

Keyboard Shortcuts (Excel)

Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions.

Line Breaks and Text Wrapping

Alt + Enter = Your new BFF

Number Formats

Control cell formatting from doing math or defaulting to dates

Text to Columns

Separate data into columns from the same cell

Tips for Printing Spreadsheets

How to make spreadsheets look good on paper

Using AutoSum

Let Excel do the math for you

Using the Fill Handle

You can quickly copy formulas into adjacent cells by using the fill handle