Spreadsheet Tips

Useful Excel tips, as animated gifs.

Concatenate Cells in Excel

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