A refreshed export is correct and unreadable: no thousands separators, negatives with a minus sign buried mid-column, columns too narrow to show the headers, and nothing frozen. Fixing that by hand takes ten minutes and happens every single month. The macro does the lot — number format with negatives in brackets, a bold header row, autofit, freeze panes, and a border under the headings. The one rule worth following is to format the RANGE rather than whole columns: `Columns("B:D").NumberFormat` touches a million cells and makes the file bigger and slower for no benefit.

Sub FormatReport()
    Dim ws As Worksheet, lastRow As Long, lastCol As Long
    Set ws = ActiveSheet

    lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
    lastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
    If lastRow < 2 Then Exit Sub            ' nothing but a header

    Application.ScreenUpdating = False

    With ws.Range(ws.Cells(1, 1), ws.Cells(1, lastCol))
        .Font.Bold = True
        .Interior.Color = RGB(244, 242, 234)
        .Borders(xlEdgeBottom).Weight = xlMedium
    End With

    ' Numbers only, and only the used range — never whole columns.
    With ws.Range(ws.Cells(2, 2), ws.Cells(lastRow, lastCol))
        .NumberFormat = "#,##0;(#,##0)"     ' accountant's brackets
        .HorizontalAlignment = xlRight
    End With

    ws.Range(ws.Cells(1, 1), ws.Cells(lastRow, lastCol)).Columns.AutoFit

    ' Freeze below the header. Needs the sheet active, so do it last.
    ws.Activate
    ws.Range("A2").Select
    ActiveWindow.FreezePanes = False        ' clear any existing freeze first
    ActiveWindow.FreezePanes = True

    ws.Range("A1").Select
    Application.ScreenUpdating = True
End Sub

Paste into the Visual Basic Editor (Alt + F11 → Insert → Module), then run and save as macro-enabled (.xlsm).

• Tidy a refreshed export before it goes to anyone.
• Make every monthly schedule look the same without doing it by hand.
• Run it at the end of a close macro so the output is presentable.

A simulation — press Run to perform what the macro does to a sample workbook.

• A Table (Ctrl + T) — Gets you banding, autofilter and a frozen header for free, and survives a refresh. Worth preferring when the data allows it.
• Cell Styles — Define the look once and apply by name; a macro then only has to assign the style.