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.


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

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

End Sub

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts