How do I check whether an Excel cell is empty?
Use ISBLANK and related logic to test a cell before your formula returns a result.
Read the ISBLANK tutorial
Choose a question
Solve a common Excel problem
Start with the question closest to what you are trying to do. Each guide opens as a complete tutorial with worked steps and examples.
How do I create a drop-down list in Excel?
Control the values people can enter and make a worksheet easier and more consistent to use.
Create an Excel drop-down listHow do I calculate working days between two dates?
Learn how the NETWORKDAYS function counts weekdays while allowing for public holidays.
Learn the working-days formulaWhy does Excel remove the first zero from a phone number?
See why leading zeros disappear and how to keep phone numbers displayed correctly.
Keep the leading zeroHow does the Excel OFFSET function work?
Understand how OFFSET returns a reference based on a starting cell, rows and columns.
Explore the OFFSET functionHow can VBA consolidate data from multiple sheets?
Follow a step-by-step VBA example for bringing information from several sheets together.
View the consolidation VBAHow do I create alternating row colours?
Use a conditional-formatting formula to make rows easier to follow without manual colouring.
Create alternating row coloursHow do I automatically add sheet tabs in Excel?
Learn a faster way to create and organise additional worksheets in an Excel workbook.
Add sheet tabs automatically