Arrange Windows for the Obsessive Compulsive

I’m sure you can find how to Arrange Windows in Excel all over the web; it’s been covered many times. However, if you’re anything like me, you would like to know how to control the actual arrangement is done by Excel. Maybe you’d like the window on the left to be the “before” worksheet and the worksheet on the right to be the “after” worksheet when viewing multiple worksheets. It seems that Excel just puts the windows in whatever order it wants. Well, there’s a little-known fact about arranging these windows: the order at which they are displayed can be controlled. Yup, that’s right. It’s a little tricky, but it can be done. Check this out.

Say I have 4 windows open (all new windows of the same workbook), named: Book1:1, Book1:2, Book1:3, and Book1:4. Excel knows the order that I have clicked on them (“activated”). Excel keeps track of that info and uses it to display the windows a certain way. Take Tiled, for instance. It will organize the windows top to bottom, then left to right. Just like this:

1st 3rd
2nd 4th

If I click on the windows in the following order:

  1. Book1:1
  2. Book1:2
  3. Book1:3
  4. Book1:4

Then that means I clicked on the 4th last, which will end up in the 1st position. Then Book1:3 will show up in the 2nd position. Book1:2 in the 3rd position, and Book1:1 in the 4th position. Like so:

Tiled secret

If I cared enough (and I do) and I wanted the layout to be:

Book1:1 Book1:2
Book1:3 Book1:4

Then I would click the windows in the following order:

Want FREE Excel Tips?

Of course you do. We all do! Join our FREE email list and be first-in-line when new posts come out!

  1. Book1:4
  2. Book1:2
  3. Book1:3
  4. Book1:1

Notice how I click the windows in the reverse order than how Tiled displays them. This is crucial to getting the layout correct. The result?

Tiled secret corrected

Nice 🙂 They are now ordered how I would like to view them. The same applies for Horizontal, Vertical, and Cascade arrangements. Cascade, however, is a little different in the sense that it will show the most active window as the “closest” one, like so:

Cascade

Play around with this with the other arranging methods to see how the results change. I hope this helps you and your obsessive compulsiveness (like me!) 🙂

Are you ready to master Excel Dashboards?

Learn Excel Dashboard Course Power BI Webinar

Still not convinced? Check out my review of the course!

  • twitter password reset

    Hello! Would you mind if I share your blog with my facebook group?

    There’s a lot of people that I think would really enjoy your content. Please let me know. Many thanks

    • Hello twitter password reset,

      Of course! Please do.

  • I truly love your site.. Excellent colors & theme.
    Did you develop this site yourself? Please reply back as I’m attempting to create my own website and would
    love to know where you got this from or what the theme is called.
    Many thanks!

    • Hi mobile games (if that IS your real name),

      Glad you like the site. I recently updated it with a WordPress theme called X. You can find it on themeforest.net. Good luck with your site.