Catalog University Blog
Upgrade Now
Learn how to remove borders and dashes using built in tools and the substitute function in this blogpost
How to Remove Dashes in Excel exceltips exceltools removedashes substitute function Apr 13, 2022
Make sure that your spreadsheets are always optimized for speed and efficiency by removing formulas in Excel. Learn how in this blogpost.
How To Remove Formula in Excel (While Keeping the Data) copy paste exceltips formulas keyboard shortcuts Apr 07, 2022
Know how to highlight cell values in your Excel tables with or with the use of Number formatting and the Conditional Formatting tool
How to Make Negative Numbers Show Up in #Red in Excel conditional formatting exceltips number formatting tables Mar 28, 2022
Learn a few methods on how to identify, highlight, and remove duplicate values from your Microsoft Excel Spreadsheets. Some of the methods in this article also work with Google Sheets.
How to Remove Duplicates in Excel countif data duplicates exceltips remove duplicates tables Feb 28, 2022
Conditional Formatting is a great basic tool to highlight data in your Excel Spreadsheets. Learn more about them in this article.
Using Conditional Formatting In Excel conditional formatting excel exceltips exceltools Jan 25, 2022
Learn how to lock cells in excel to protect your data and formulas from being overwritten
Locking Cells in Excel cell format exceltips lock cells Jan 13, 2022

CATEGORIES

All Categories array functions automation benefit of excel templates cell format cells changing currency circular references compare columns compatibility conditional formatting copy paste countif currency data deleting formats deleting tables dependent lists developer tools drop-down lists duplicates excel excel errors excel formulas excel functions excel influencers excel integrations excel is fun excel live training excel tips excel365 exceltips exceltools excle errors file conversion formatting formulas functions google finance google sheets graph gsheets keyboard shortcuts lock cells macros match and index merge microsoft forms microsoft office templates number formatting pdf pdf to excel pdf to spreadsheet pivot tables printable spreadsheet templates remove duplicates removedashes show changes signing an excel document spill error spill functions spreadsheet templates substitute function tables tick boxes tutorials unique unprotect sheet user forms vba vlookup windows 11 windows 11 excel xlookup youtube