Share via

How to delete chart files in excel 592 charts have opened so far

Anonymous
2023-11-13T13:31:32+00:00

I have 592 chart files open in my excel spreadsheet and I need to delete the charts.... How do I do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-13T16:58:40+00:00

    Hello Linda S,

    I'm Shalom and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    You can use the following steps to close multiple charts at once:

    1. Go to the View Tab: In Excel, go to the "View" tab on the Ribbon.
    2. Switch to the "Windows" Group: Look for the "Windows" group within the "View" tab.
    3. Arrange All: Click on "Arrange All." This will give you options to arrange your open windows.
    4. Choose "Vertical" or "Horizontal": Select either "Vertical" or "Horizontal," depending on your preference.
    5. Close Charts: You should now see all your open charts arranged side by side. Close them by clicking on the "X" in the top right corner of each chart window.

    If you want to delete the chart sheets within the workbook:

    1. Go to the Sheet Navigation: At the bottom of the Excel window, you'll see sheet tabs. Locate the sheet tabs for your chart sheets.
    2. Right-Click on Sheet Tab: Right-click on the sheet tab of the chart you want to delete.
    3. Select "Delete": From the context menu, select "Delete."
    4. Repeat for Each Chart Sheet: Repeat this process for each chart sheet you want to delete.

    If you have too many chart sheets to delete manually, you might consider using a VBA (Visual Basic for Applications) macro to automate the process.

    Best Regards, Shalom

    1 person found this answer helpful.
    0 comments