how do i get my excel spreadsheet to open in the same location on my desktop

Irene Bajarias 20 Reputation points
2026-06-10T15:52:04.8666667+00:00

User's image

i want my spreadsheet to open in same location when i open existing files. but everytime i open existing files it keeps opening on different locations on my desktop. im tired of having to manually move my spreadsheets

Windows for home | Windows 11 | Desktop, Start, and personalization | Other
0 comments
Answer accepted by question author

AI answer

2026-06-10T15:52:40.6466667+00:00

This behavior is controlled by how Excel windows are saved and reopened, not by a setting to “lock” a fixed position. Excel reuses the last window layout that was saved with a workbook or with Excel itself.

To keep a consistent layout:

  1. Open one of the workbooks.
  2. Arrange and resize the Excel window exactly where it should appear on the desktop.
  3. Close any extra Excel windows for that same workbook (if there are multiple windows like Book1:1, Book1:2).
  4. Press Ctrl+S to save the workbook while it is in the desired position.
  5. Close Excel.
  6. Reopen the workbook; Excel should now reuse the last saved window arrangement for that file.

If multiple windows of the same workbook are being saved, Excel can reopen them in different positions. In that case, close the extra windows first and then save, as described above.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ritesh Kumar 0 Reputation points
    2026-06-10T15:56:31.89+00:00

    If you want an Excel spreadsheet to always open in the same position on your desktop, Excel does not have a built-in setting for this. However, you can try these methods:

    Method 1: Save the Window Position

    Open the Excel file.

    Move the Excel window to the desired location on your screen.

    Resize the window if needed.

    Save the workbook.

    Close Excel while the workbook is still in that position.

    When you reopen the workbook, Excel may remember the last window size and position.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.