In this tutorial, I am going to demonstrate how to create a drop-down menu that will hyperlink to other worksheets within a workbook.  Download the featured file here. The first step is to create a new worksheet in your workbook.  In this worksheet, enter the names of the worksheets that you want to be able… Read More »Create a Hyperlink Drop-Down in Excel

In this tutorial I demonstrate how to automatically name an Excel worksheet based on a value entered in a cell on that worksheet.  To start with you will need to copy the VBA code shown below and then follow the instructions. If Not Intersect(Target, Range(“C2”)) Is Nothing Then If Range(“C2”) = Empty Then ActiveSheet.Name =… Read More »Rename Excel Worksheet Based on Cell Value

In this video tutorial I explain how to add a watermark in Excel. How to Create a Text Watermark The first step is to switch over to the Page Layout view.  Do this on the Ribbon’s View tab Now click where it says “Add Header” at the top of the worksheet Write your watermark text… Read More »How to Insert a Watermark in Excel