How to Show or Hide Gridlines in Excel
Show or Hide Gridlines in Excel Worksheets (+ Shortcuts) by Avantix Learning Team | Updated June 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By default,...
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 June 28, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can combine first and last name in Excel in several ways –...
How to Use the XLOOKUP Function in Excel (with Examples)
Use the Excel XLOOKUP Function to Look Up Data (and Why It's Better than VLOOKUP) by Avantix Learning Team | Updated June 27, 2026 Applies to: Microsoft® Excel® 2021, 2024 and 365 (Windows) The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function...
How to Lock Cells in Excel (3 Ways)
Easily Lock Cells in Excel Worksheets by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 or 365 (Windows) It's easy to lock cells in Excel to protect data or formulas. This is typically a two-step process. First,...Follow Us
