Spreadsheet Tips
Useful Excel tips, as animated gifs.
Get an Excel tip like this in your inbox every few weeks.
Previous Tips
-
November 26, 2019
Reference Cells Across Sheets
-
November 12, 2019
Enable Excel shortcuts in Google Sheets
-
October 29, 2019
Collapse Data with Groups
-
October 15, 2019
Display Units as Custom Formats
-
September 30, 2019
Shortcut: Quickly Create Tables
-
September 17, 2019
Manage Data with Tables
-
September 03, 2019
Simplify Formulas with Named Ranges
-
August 20, 2019
Visualize Data with Data Bars
-
August 06, 2019
Shortcut: Quickly Create Charts
-
July 23, 2019
Freeze Rows and Columns in Excel
-
July 09, 2019
Simplify Formulas with Named Cells
-
June 25, 2019
Quick Counting with the Status Bar
-
April 02, 2019
Shortcut: Format a Number as Currency
-
March 26, 2019
Shortcut: Format a Number as a Percentage
-
March 19, 2019
Check Excel Formula parts with F9
-
March 05, 2019
Shortcut: Format a Number in Scientific Notation
-
February 26, 2019
Unit Conversions in Excel
-
February 19, 2019
Remove Spaces with Text to Columns in Excel
-
February 05, 2019
Shortcut: Format a Number as a Time
-
January 29, 2019
Pasting Formulas as Values
-
January 21, 2019
Spellcheck in Excel
-
January 08, 2019
Shortcut: Format a Number as a Date
-
January 01, 2019
Show Excel Formulas with FORMULATEXT
-
December 17, 2018
Link to Another Worksheet in Excel
-
November 10, 2018
How to Use Absolute Value in Excel
-
October 27, 2018
How to Select Entire Rows and Columns
-
October 19, 2018
How to Split Columns in Excel
-
October 05, 2018
How to Show all Formulas in a Spreadsheet
-
September 28, 2018
How to Convert Columns into Rows in Excel
-
September 21, 2018
How to add a Screenshot in Excel
-
September 15, 2018
How to Search Within Formulas in Excel
-
September 07, 2018
How to Center Data Across a Selection in Excel
-
August 31, 2018
How to Hide Sheets in Excel
-
August 24, 2018
How to Use AutoSum for Averages in Excel
-
August 16, 2018
How to Filter Data Easily in Excel
-
July 26, 2018
How to Add Common Formats in Excel
-
July 20, 2018
How to Hide Rows and Columns in Excel
-
July 13, 2018
How to add a Hyperlink in Excel
-
July 05, 2018
How to Autocomplete Formulas in Excel
-
June 28, 2018
How to Show Zeroes as Blank Cells in Excel
-
June 20, 2018
How to Transpose (Flip) Data in Excel
-
June 14, 2018
How to Hide the Excel Ribbon for More Space
-
May 31, 2018
Toggle Absolute References in Excel with F4
-
May 23, 2018
Use Format Painter to Copy Formats in Excel
-
May 16, 2018
How to Easily Switch Between Spreadsheets
-
May 09, 2018
How to Show the File Path in Excel
-
May 03, 2018
How to use the PRODUCT Function in Excel
-
April 25, 2018
How to Add Comments to Your Spreadsheets
-
April 19, 2018
How to Use Sparklines for Visual Indicators
-
April 12, 2018
How to Create Custom Number Formats in Excel Easily
-
April 05, 2018
How to Join Cells With a Space Between them in Excel
-
March 22, 2018
How to Join Cell Contents with "&"
-
March 15, 2018
How to Merge and Center Cells in Excel
-
March 08, 2018
How to Turn Off Gridlines in Microsoft Excel
-
March 01, 2018
The Fastest Way to Create Sums in Excel
-
February 22, 2018
How to Use =MID to Grab Part of a Cell
-
February 15, 2018
Use =LEFT To Extract Part of a Cell
-
February 08, 2018
Use =RIGHT To Extract Part of a Cell
-
February 01, 2018
How to Remove Spaces with TRIM
-
January 25, 2018
How to Get the Absolute Value of a Cell in Excel
-
January 18, 2018
How to Autofill Formulas in Excel
-
December 21, 2017
How to Freeze Rows in Google Sheets
-
December 14, 2017
Make Sequences with The Fill Handle
-
December 07, 2017
How to Wrap Text in Excel
-
November 30, 2017
Insert Multiple Rows or Columns in Excel
-
November 25, 2017
How to Insert Hyperlinks in Excel
-
November 18, 2017
How to Select all Cells in Excel
-
November 09, 2017
How to Change Text Case in Excel
-
November 02, 2017
How to Show Today's Date in Excel
-
October 26, 2017
Concatenate Excel Cells with the "&" Symbol
-
October 18, 2017
How to Show a Formula in a Cell in Excel
-
October 12, 2017
How to Make Quick Totals with Autosum
-
October 05, 2017
Emojis in Excel
-
September 29, 2017
Make Absolute Cell References in Excel
-
September 19, 2017
Using Mathematical Constants
-
September 08, 2017
How to Display a Formula Instead of a Calculation
-
August 19, 2017
Remove Formatting in Excel