Is there a way to establish and apply a default Page Layout

[Patikns23]

Is there a way that I can establish a default Page Layout for all Excel worksheets and apply that to all of the worksheets that I open in Excel?

For example, I export A LOT of csv files from Great Plains. Currently, I have to change the page setup on each and every one. It would be nice to have that done automatically.

.5" Top, Left, Right margins
.75" Bottom margin
Foot at .3"
Left footer: File Path
Right footer: Date and Time
Fit to 1 page portrait, letter size
Center horizontally

Thank you.

 

[OaklandJim]

If I understand your need you could format a worksheet as needed, name it Template then hide it. by right clicking on the worksheet tab then select Hide. When you need a new worksheet you make a copy of the Template sheet. The macro below does that, if the sheet is named Template.

I suggest assigning a "Hot Key" to the macro so you can run the macro that way. Maybe Ctrl N which normally creates a new workbook but for you would create the new worksheet in the existing workbook.

I found this web page that shows how to do that. 2 Ways to Assign Keyboard Shortcuts to Macros - Excel Campus

Here is the macro that makes a copy of the template worksheet.

Sub MakeSheetFromTemplate()

    Dim iWorksheetsCount As Long
    
    iWorksheetsCount = ThisWorkbook.Worksheets.Count

    With Worksheets("Template")
        .Visible = True
        .Copy Before:=Sheets(1)
        .Visible = False
    End With
    
    ActiveSheet.Name = "Sheet" & iWorksheetsCount + 1
    
End Sub