Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Excel and windows

Excel and windows

Scheduled Pinned Locked Moved The Lounge
csharpvisual-studioquestion
32 Posts 12 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P PaulowniaK

    Joan Murt wrote:

    You could middle-click the excel icon

    Cool, I didn't know about that! :cool:

    Joan Murt wrote:

    then double click the file

    That puts the file in the excel that was already opened, not the one I just opened with the middle button click.

    Joan Murt wrote:

    drag it to the newly openend excel

    Yup, this always has worked, but you end up with a spare Book1 floating around. No harm done, sure. Just annoyed that something so seemingly simple is so difficult.

    Almost, but not quite, entirely unlike... me...

    J Offline
    J Offline
    Joan M
    wrote on last edited by
    #23

    PaulowniaK wrote:

    Cool, I didn't know about that! :cool:

    Great, I'm glad it has helped you.

    PaulowniaK wrote:

    That puts the file in the excel that was already opened, not the one I just opened with the middle button click.

    You should click the newly opened excel first, then the file will go to the last excel with focus... (I'm speaking from deep memories). :thumbsup:

    [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

    P 1 Reply Last reply
    0
    • D Dalek Dave

      TOP TIP! Even I, Excel Guru Par Excellence, did not know about that! Earns you some man points, and some real ones too :)

      --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

      J Offline
      J Offline
      Joan M
      wrote on last edited by
      #24

      I'm glad it has been useful to you! :thumbsup: and thank you DD!

      [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

      1 Reply Last reply
      0
      • J Joan M

        PaulowniaK wrote:

        Cool, I didn't know about that! :cool:

        Great, I'm glad it has helped you.

        PaulowniaK wrote:

        That puts the file in the excel that was already opened, not the one I just opened with the middle button click.

        You should click the newly opened excel first, then the file will go to the last excel with focus... (I'm speaking from deep memories). :thumbsup:

        [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

        P Offline
        P Offline
        PaulowniaK
        wrote on last edited by
        #25

        Joan Murt wrote:

        You should click the newly opened excel first, then the file will go to the last excel with focus... (I'm speaking from deep memories).

        Sounds extremely sensible... just that I'm still having trouble with that... :doh: I wonder if I can find any Excel settings I've got set strangely...

        Almost, but not quite, entirely unlike... me...

        1 Reply Last reply
        0
        • D DaveAuld

          http://answers.microsoft.com/en-us/office/forum/office_2007-office_install/opening-wordexcel-document-opens-second-blank/2eadcb0c-7d87-4c89-bf94-496e2c8a6a62[^] May be the solution to your problem!

          Dave Find Me On: Web|Facebook|Twitter|LinkedIn


          Folding Stats: Team CodeProject

          OriginalGriffO Offline
          OriginalGriffO Offline
          OriginalGriff
          wrote on last edited by
          #26

          That fixed it! Cheers - it was never a "biggie", so I didn't bother too much, but it helps. Don't you love MS consistency though:

          winword /r
          excel /o

          Both to do the same thing in suite apps... :sigh:

          Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

          1 Reply Last reply
          0
          • D Dalek Dave

            You were unclear in your original post. A more succinct question will, inevitably, lead to a more precise answer :) In response I would say that you need the 'Clunky' method of opening it, saving it, opening a second instance of Excel and then reopening the file in the second instance. (Cannot see how that is better). Or the alternative way is open two excel sheets in one excel instance. Next you choose the tab "View" and click the "all window" option, then you can select that all the open windows should appear next to each other. When you make your Excel instance a big as your desktop (across two screens) you can see both of the excel sheets in one instance.

            --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

            G Offline
            G Offline
            Gary R Wheeler
            wrote on last edited by
            #27

            Before Excel 2010, it would not allow you to run multiple instances.

            Software Zen: delete this;

            D 1 Reply Last reply
            0
            • G Gary R Wheeler

              Before Excel 2010, it would not allow you to run multiple instances.

              Software Zen: delete this;

              D Offline
              D Offline
              Dalek Dave
              wrote on last edited by
              #28

              Ah, maybe, but we are not running obsolete software are we?

              --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

              B 1 Reply Last reply
              0
              • P PaulowniaK

                Pardon me if I'm being extremely thick here, but why is it that when you double click on an excel file in Windows explorer it automatically opens in the current excel window you've got opened? It makes comparing files very difficult. And, say, with Visual Studio, you can pull windows out to have them side by side when you need them, but with Excel, once you've got two files opened in a window you can't get them separated. If anyone could prove me wrong, I'd be more than happy!

                Almost, but not quite, entirely unlike... me...

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #29

                There are worser problems with Excel, like when a column is wider than what can fit in the window, you have a tough time trying to read through the columns. They only way I know of is to select the column and adjust column width from the context menu.

                1 Reply Last reply
                0
                • D Dalek Dave

                  TOP TIP! Even I, Excel Guru Par Excellence, did not know about that! Earns you some man points, and some real ones too :)

                  --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #30

                  Dalek Dave wrote:

                  Even I, Excel Guru Par Excellence, did not know about that!

                  It's not an Excel feature. It's a Windows 7 feature. Works for all apps (that support opening new windows), not just Excel.

                  1 Reply Last reply
                  0
                  • D Dalek Dave

                    Do you know about VIEW - ARRANGE ALL - SIDE BY SIDE? There, problem solved! :) (It has synchronous scrolling option too).

                    --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

                    S Offline
                    S Offline
                    Slacker007
                    wrote on last edited by
                    #31

                    Dave, you're my hero. :-O

                    1 Reply Last reply
                    0
                    • D Dalek Dave

                      Ah, maybe, but we are not running obsolete software are we?

                      --------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^]

                      B Offline
                      B Offline
                      Brady Kelly
                      wrote on last edited by
                      #32

                      I have an instance of VB6 open on my desktop right now. I have inquired about another VB6 related gig, but if it at all involves having to use this detestable piece of crap IDE, I will triple my rate. If they still want me, I'll suffer gladly for that money.

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups