![How to Replace Zeros (0) with Blanks in Excel](https://www.avantixlearning.ca/wp-content/uploads/2024/01/replace-zeros-with-blanks-in-excel-featured.png)
![How to Replace Zeros (0) with Blanks in Excel](https://www.avantixlearning.ca/wp-content/uploads/2024/01/replace-zeros-with-blanks-in-excel-featured.png)
![How to Show or Hide Gridlines in Excel](https://www.avantixlearning.ca/wp-content/uploads/2023/10/remove-hide-show-gridlines-in-excel-featured-1080x675.jpg)
How to Show or Hide Gridlines in Excel
Show or Hide Gridlines in Excel Worksheets (+ Shortcuts) by Avantix Learning Team | Updated October 15, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By...![How to Combine First and Last Name in Excel (5 Ways)](https://www.avantixlearning.ca/wp-content/uploads/2023/09/combine-first-name-and-last-name-in-excel-featured-new-1080x675.jpg)
How to Combine First and Last Name in Excel (5 Ways)
Combine First and Last Names in Excel Using Formulas and Functions or Flash Fill by Avantix Learning Team | Updated September 20, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can combine first and last name in Excel in several ways –...![How to Use the XLOOKUP Function in Excel (Overview, Syntax + Formula Examples)](https://www.avantixlearning.ca/wp-content/uploads/2023/03/excel-xlookup-function-formula-examples-featured.png)
How to Use the XLOOKUP Function in Excel (Overview, Syntax + Formula Examples)
Use the Excel XLOOKUP Function to Look Up Data (and Why It's Better than VLOOKUP) by Avantix Learning Team | Updated March 9, 2023 Applies to: Microsoft® Excel® 2021 and 365 (Windows) The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as...![How to Lock Cells in Excel (3 Ways)](https://www.avantixlearning.ca/wp-content/uploads/2017/12/lock-143616_640.jpg)