Spreadsheet Tips

Previous Tips

• 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