


How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)
Hide or Unhide Excel Worksheets by Avantix Learning Team | Updated September 14, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can hide or unhide Excel worksheets using the Ribbon, the right-click menu or keyboard shortcuts. If...
Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)
Highlight Dates Before Today or Within a Date Range in Excel Using Conditional Formatting by Avantix Learning Team | Updated October 17, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can use conditional formatting in Excel to...
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
3 Ways to Replace Spaces Between Characters in Excel Text Strings by Avantix Learning Team | Updated October 20, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) In Excel, you can replace spaces in text strings with underscores, dashes or...