Excel VBA
How to Format Date to YYYYMMDD with Excel VBA (3 Examples)
Learn how to format dates to YYYYMMDD in Excel VBA using NumberFormat for cells or ranges, and the VBA Format function for flexibility.
Read article
Blog
1285 articles
Excel Pro Tips
How to Sort Tabs in Excel (3 Suitable Methods)
Learn how to sort tabs in Excel by drag-and-drop, VBA, or alphabetically in A-Z or Z-A order, while keeping specific sheets in place.
Read article
Excel Pro Tips
How to Sort Alphabetically in Excel & Keep Rows Together
Learn how to sort alphabetically in Excel while keeping rows together using the Sort tool, SORT function or filters for proper organization.
Read article
Excel Pro Tips
How to Return 0 If Cells are Blank in Excel (3 Useful Formulas)
Learn how to return 0 if cells are blank in Excel using IF, ISBLANK, Go To Special, or Find & Replace for quick data cleanup.
Read article
Google Sheets Basics
What Is Smart Fill in Google Sheets and How to Work with It
Learn how the Smart Fill feature works in Google Sheets, what it does, and how to use it to quickly auto-complete and format your data.
Read article
Excel VBA
How to Delete Row Based on Cell Value in Excel VBA (7 Methods)
Learn how to delete rows based on cell values in Excel VBA, whether matching text, blanks, numeric criteria, or multiple user-defined rules.
Read article
Excel VBA
How to Create a Macro Button in Excel (6 Effective Ways)
Learn how to create a macro button in Excel using form controls, ActiveX, shapes, VBA, Quick Access Toolbar, or a custom ribbon group.
Read article
![[Fixed] Cannot Edit Macro on a Hidden Workbook](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-cannot-edit-a-macro-on-a-hidden-workbook-2-d3e8b523.webp)
Excel VBA
[Fixed] Cannot Edit Macro on a Hidden Workbook
Fix the “Cannot edit a macro on a hidden workbook” error in Excel by unhiding, adjusting PERSONAL.xlsb, enabling macros or disabling add-ins.
Read article
Excel Pro Tips
How to Convert Number to Words in Excel for Peso (2 Ways)
Learn how to convert numbers to words in Excel for Peso using VBA macro code, along with essential formatting tips for accurate results.
Read article
Google Sheets Basics
How to Copy Format in Google Sheets (3 Simple Ways)
Learn how to copy formatting in Google Sheets using the Format Painter tool or Paste Special features for quick and consistent styling.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Auto-Transfer Data Between Excel Sheets
Learn how to transfer data between Excel worksheets automatically using VLOOKUP, XLOOKUP, or INDEX-MATCH for flexible and accurate lookups.
Read article
Excel Functions & Formulas
Vlookup from Multiple Columns with Only One Return in Excel
Learn how to VLOOKUP from multiple columns in Excel with one return using a helper column, XLOOKUP, or the INDEX-MATCH formula.
Read article