Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

Macros are small scripts you can use to automate many of the repetitive tasks involved in creating and editing Microsoft Excel spreadsheets. Macros help your business by saving you significant amounts ...

Excel is a useful program for creating tables, graphs and making complicated calculations automatically. It might seem complicated at the beginning, but when you get to know Excel's features, the ...

Alan is a technology author based in Nova Scotia, Canada. A computer enthusiast since his youth, Alan stays current on what is new and what is next. With over 30 years of experience in computer, video ...