# Spreadsheet Tips

## Useful Excel tips, as animated gifs.

### Get an Excel tip like this in your inbox every few weeks.

## Previous Tips

- 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