How to remove gridlines 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!
TRUE and FALSE in Excel (with examples)
![TRUE and False in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-31.png)
Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet Master with Ted Jordan!
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.
How to add a password to Excel sheets
![Protecting Excel Sheets with a Password](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-28.png)
Add passwords to Excel workbooks and control who can open and edit your data. Learn how to create a password on Excel and how to unprotect Excel sheets.
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.
How to run spell check in Excel
![Built-in Spell Check in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-25.png)
Learn how to run spell check and how to turn on/off AutoCorrect quickly with Ted Jordan.
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!
Conditional formatting in Excel: how to change cells colour based on value
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Conditional-Formatting.png)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Conditional-Formatting.png)
Change cells colours based on value and become a spreadsheet pro! Watch our videos and examples to learn how to use conditional formatting in MS Excel.
Excel TRANSPOSE formula: how to rotate columns to rows
![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)
![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)
![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)
What’s the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how now!