CODEWITHSUNDEEP
excelhyperlinkexcel-2013
Degauser
Degauser

Reputation: 120

Excel 2013 Format Hyperlinks

I'm working with Excel 2013. And I need to style ALL of the Hyperlinks in my workbook.

In Word, I can just select - for example Heading 1 - and modify it. This makes all Heading 1 texts same.

But I couldn't do it with Excel 2013. How to format all of the Hyperlinks (and more can be added later) easily? In all sheets, in all cells, wherever they are in the workbook.

Upvotes: 0

Views: 1948

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

The Hyperlink Style is on the same row as Calculation and Check Cell

pic

.

Just right-click it and pick Modify...

You could also use a small macro like:

Sub HyperBold()
    ActiveWorkbook.Styles("Hyperlink").Font.Bold = True
End Sub

If you do this often.

Upvotes: 3

Related Questions