Check out our recent tips below.
Looking for this week’s tip? Find it at Tip of the week.
Get an account in just a few clicks.
Join free and get a bonus tip each week.
Check out our plans to see what else you can get.
Users on paid plans can also review Last week’s tip, and get access to our very latest Tip of the week on the Advance Publication schedule.
It’s your time!
Blank pages at the end of your document? Page alignment look wrong? Strange print or export results? Here’s how to solve some of the common spreadsheet printing and exporting issues.
Use the power of data table formulas to work faster and more efficiently. See how cell references in data tables are structured, and how you can save time when using formulas in data tables.
Quickly show and evaluate formulas, find inconsistent formulas and troubleshoot them quickly.
Select the cells you want to go to using the keyboard, fast… no matter where they are in your spreadsheet!
Quickly use your best work again and again by making small changes fast. Find and replace or remove content, formatting or both.
Get quick keyboard shortcuts for your most frequently used command buttons on the Quick Access Toolbar.
Get more flexibility and speed from SUMIF and COUNTIF functions, whether you are new to them or use them already.
Quickly organize your data into tables for faster updating, while keeping references, totals and formats updated automatically.
Make a new chart in no time with this simple keyboard shortcut.
Save time by reusing data, formulas and formatting. See how to fill and repeat acoss other cells, reuse formulas and extend patterns.
About circular reference errors, circular reference warnings, how to find and correct them… and when to embrace circular references!
Need to quickly remove formatting from an existing cell or range?
Use these shortcuts to clear cell formatting while leaving the cell contents unchanged.
Still scrolling around your worksheets to find and select cells?
Here’s how to fly around the current worksheet at lighting speed.
Quickly access cell format settings for the current cells.
Insert today’s date or time, adjust formatting, and see how to update the date and time automatically.
Still using the slow way to audit formulas?
Trace cell precedents and dependents in an instant with these handy shortcuts.
Use absolute and relative references to control whether your formulas stay the same or update when copied to other cells.
Format cells to display custom number formats, and learn how to use number format codes to make your own custom formats quickly.
Subtotals save time, reduce errors and provide confidence. Learn how to use subtotal formulas to speed up your spreadsheets and cut down editing time.
Know your way around subtotals already? Check out this tip to see if you’re getting the most out of them.
Want a new version of the current workbook?
Here’s how to create and save a new copy in an instant.
How much time do you spend editing formulas?
Spend less with these essential formula editing tips.
