How to make gridlines invisible in Excel
![How to make gridlines invisible in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-42.png)
Make gridlines invisible or change the gridlines colour in your Excel workbook after reading our quick tutorial. Plenty of examples to learn from!
Filter data with a formula: Excel FILTER
![Filtering Data with a Formula in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-34.png)
Learn how to filter data with a formula in Microsoft Excel and how to use FILTER with condition. Become more efficient with our Excel tips and tricks.
How to increase indent in Excel
![Indenting in Excel Cells](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-30.png)
Discover how to increase indent in Excel and shortcut keys for indentation. Learn how to remove indent quickly to style your spreadsheets in a timely manner.
Flash Fill in Excel: shortcut and use
![Flash Fills in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-27.png)
You don’t know how to use Flash Fill in Excel? No worries, Ted Jordan is here to teach you how to become an Excel Wizard! Learn what is the Flash Fill shortcut and save time filling your data automatically.
Scroll to top button in Excel: how to add one?
![Navigation Button in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-22-1.png)
Add a scroll to top button in Excel to impress your customers and use shortcuts to go back to the first cell of your worksheet. Learn Excel tips and trick with Ted Jordan!
How to define names in Excel (tables)
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
Discover shortcuts to create Excel tables and rename them; learn how to define selections and name them. Use structured references in Excel formulas to save time!
AutoSum shortcut: quick sum of column (Excel)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-15.png)
The AutoSum shortcut or how to save time to calculate sum of columns or rows in Excel. Learn how to use AutoSum in MS Excel with our various examples (with short videos and with images).
Insert row shortcut: how to create shortcuts in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-12.png)
Create shortcut keys in Excel to add rows or a pivot table to your spreadsheet like a pro! Learn how to customise shortcuts and how to create new ones with Ted Jordan.
How to Custom Sort in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-10.png)
Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort like a pro.
Design and unformat tables in Excel
![Design and Unformat Tables in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-8.jpg)
Unformat Excel table easily and design it like a pro within seconds! Convert cell range to a table and vice versa.