Default Font Size and other settings

[Davidns]

is there a way to set New Files to open with a designated font size and without gridlines or other settings? I am using Excel for Macs and have tried various suggestions from the internet, but nothing seems to work.
Any advice would be appreciated.
Thanks!

 

[Joe4]

I have a few possible suggestions for you:

1. If you are talking about the creation of new files, I would recommend creating an Excel template that is pre-formatted the way that you like, and use this to create your new files. Just Google "create excel template in mac" to find instructions on how to do this.

2. If you are talking about opening existing files, I would recommend creating a Macro that format the ActiveSheet the way that you like, and then storing it in your Personal Macro Workbook, so you can run it quickly and easily on any workbook that you like. Note that you can get much of the VBA code you need to do this by turning on your Macro Recorder and recording yourself manually formatting the sheet the way you like.

If you would like it to run automatically, you would instead need to store that VBA code in "Workbook Open" event of the particular workbooks that you would like it to run against. But it would have to be in each file.

 

[Lucas79]

If you want to control various settings with VBA in stead of creating or editing the Book.xltx in the Microsoft Office\Root\OfficeXX\XLSTART (on Windows), you can add the Macro "Workbook_Open" like Joe4 suggested on 'ThisWorkbook'.

1. Open the VBA Editor by pressing ALT+F11 (or Mac equivalent)
2. Navigate to ThisWorkbook
3. enter the code below

Private Sub workbook_Open()

    ActiveWindow.DisplayGridlines = False
    Cells.Select
   
    With Selection.Font
        .Name = "Calibri"
        .FontStyle = "Regular" 'Use Bold, Italic or Bold Italic if you want different Font Style
        .Size = 15
    End With

End Sub

You can use the Macro Recorder in the Development tab to see what the VBA Code is for enabling or disabling various settings in Excel. You have to enable the Developer Tab by customizing the Ribbon.

 

[Davidns]

Thanks guys. Much appreciated!