Breaking News: Grepper is joining You.com. Read the official announcement!

I want Excel to autofit columns when I open it and without any external input. How can I do that?

Wide-eyed Wolverine answered on July 25, 2023 Popularity 1/10 Helpfulness 1/10

answer I want Excel to autofit columns when I open it and without any external input. How can I do that?

I want Excel to autofit columns when I open it and without any external input. How can I do that?

Comment

1. Open your Excel workbook.

2. Press "Alt + F11" to open the Visual Basic for Applications (VBA) editor.

3. In the VBA editor, click on "Insert" in the top menu, and then click "Module" to insert a new module.

4. In the module window, paste the following VBA code:

Private Sub Workbook_Open()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Sheets
        ws.Cells.EntireColumn.AutoFit
    Next ws
End Sub

5. Close the VBA editor and save your workbook as a macro-enabled workbook (.xlsm).

6. Now, when you open the workbook, the Workbook_Open event will be triggered automatically, and it will autofit all columns in all sheets.

Here's how to enable macros:

When opening the workbook, you'll see a security warning below the ribbon.
Click on "Enable Macros" or "Enable Content" to allow the VBA code to run.
After enabling macros once, Excel will remember your choice for future openings of the same macro-enabled workbook on your computer. However, this might not be the case if you share the workbook with others or open it on a different computer.

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: chat.openai.com

Tags: any excel external whatever when

Link to this answer
Share Copy Link

Contributed on Jul 25 2023

Wide-eyed Wolverine

0 Answers Avg Quality 2/10

I want Excel to autofit columns when I open it and without any external input. How can I do that?

Contents

More Related Answers

I want Excel to autofit columns when I open it and without any external input. How can I do that?

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.