You may like

How to Replace Zeros (0) with Blanks in Excel

How to Replace Zeros (0) with Blanks in Excel

Enter, Return or Display Blanks Instead of Zeros in Excel by Avantix Learning Team | Updated January 4, 2024 Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows) There are several strategies to replace zero values (0) with blanks in Excel. If you want to...

What is Power Query in Excel?

What is Power Query in Excel?

What is Power Query in Excel and Why is It So Useful? by Avantix Learning Team | Updated November 18, 2023 Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows) Power Query in Excel is a powerful data transformation tool that allows you to import data from...

How to Freeze Rows in Excel (One or Multiple Rows)

How to Freeze Rows in Excel (One or Multiple Rows)

Freeze One or More Rows in an Excel Worksheet by Avantix Learning Team | Updated October 25, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you...

How to Show or Hide Gridlines in Excel

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)

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 –...

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest