Jason Howie

This page illustrates useful find features in Excel. Learn how to perform workbook-wide searches case-sensitive searches find exact cell content and use wildcards.

To shade alternate rows in Excel use conditional formatting or apply a table style. Coloring every other row makes it easier to read your data.

By default Excel records macros in absolute mode. However sometimes it is useful to record macros in relative mode. This program teaches you how to do this. If you don't know how to record a macro we highly recommend you to read this example first.

This chapter teaches you how to declare initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called declaring a variable. Initializing simply means assigning a beginning (initial) value to a variable.

Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.

Wrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically or enter a manual line break.

The MsgBox function in Excel VBA can return a result while a simple MsgBox cannot.

You can split your Excel worksheet into panes to view multiple distant parts of your worksheet at once. Simply use the split bar to change the size of each pane.

If you have Excel 365 or Excel 2021 use XLOOKUP instead of VLOOKUP. The XLOOKUP function is easier to use and has some additional advantages.

The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples.