How to Enable the Developer Tab in Excel (Windows & Mac)

In this Excel training video, we guide you through the process of enabling the developer tab in both Windows and Mac desktop versions of Excel. We’ll also show you how to use some of the common developer tools that can help you take your Excel game to the next level.

Once enabled, we’ll show you how to utilize add-ins, form controls, and Visual Basic for Applications (VBA). By the end of this tutorial, you’ll not only have the developer tab readily available but also the skills to harness its tools effectively.

Resources

VBA code to add current date & time to selected cells:

Sub AddDateTime()
    Dim selectedRange As Range
    Set selectedRange = Selection

    If Not selectedRange Is Nothing Then

        For Each cell In selectedRange
            cell.Value = Now
        Next cell

    Else
        MsgBox "Please select a range of cells.", vbExclamation, "Selection Required"
    End If

End Sub