This code sample demonstrates a task pane add-in that is displayed in Excel 2013 when the add-in is first started. The task pane contains three tabs that are presented horizontally, each with a tab ...

As a small business owner, you will often have to work with others on an Excel worksheet. For example, if you have hired a sales or marketing consultant, you can give them an interactive worksheet for ...

Microsoft Excel is a popular tool for managing data, and its flexibility allows users to customize their workbook appearance. One of the ways to customize the appearance of an Excel workbook is to ...

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...

Have you found this content useful? Use the button above to save it to your profile. Simon Hurst draws on queries and answers from the ExcelZone archives to offer a collection of time-saving worksheet ...

A selected Worksheet Tab in Microsoft Excel is white, but what if you want to add a splash of Color or distinctive Colors to your Worksheet Tab. Adding Color to your Worksheet Tabs is an easy way to ...

A Microsoft Excel dashboard provides an overview of key performance indicators (KPIs) and other important metrics. Particularly, it features various graphs, charts, and tables to present these KPIs in ...