Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: Small Excel Problem

  1. #1
    Join Date
    May 2007
    Location
    Tromsĝ, Norway
    Posts
    42

    Default Small Excel Problem

    Is there any way for me to be able to see the A column and the R column at the same time?

    I'm working on the Norwegian translation, and I've been assigned column 18. I have to keep scrolling back and forth to check the next word

    Anyone got a solution?

  2. #2
    Join Date
    Mar 2006
    Location
    Denmark
    Posts
    426

    Default

    (I use an english excel). Highlight the columns you dont want to see. Rightclick and select hide.

  3. #3
    Join Date
    May 2007
    Location
    Tromsĝ, Norway
    Posts
    42

    Default

    Thanks, much easier now

  4. #4
    Join Date
    Mar 2006
    Location
    Denmark
    Posts
    426

    Default

    No problem. I just haven't figured out how to unhide those columns yet

  5. #5
    Join Date
    Jul 2004
    Location
    Wolverhampton, UK
    Posts
    5,000

    Default

    Or place your 'active' cell in cell B2 (that's a guess) and go to Windows > Freeze Panes. You should then be able to scroll to column R and A stay visible.

    Bubka, right lick on the top left cell, the one both 'A' and '1' touch, and select unhide.
    #You can play your card, I'll hold onto mine, Tied up in the reasons, Ace take your time#
    #Looks turn to lovers, flames into fires, Jack loves his tragedy, Queen her desires#

  6. #6
    Join Date
    Jan 2006
    Location
    Last door right...
    Posts
    1,501

    Default

    Yes, right click will give you the option to hide and unhide columns and rows.

    If you want to hide/unhide only one, when selecting one of its cells (if it's hidden write the number and letter on the cell selector top left ) and then go to Format -> column/row ->Hide/unhide

    Hope it sounds reasonable
    Fab, that's it, plain Fab
    Visit NSS Spanish Forum - Shamrock's Myspace

  7. #7
    Join Date
    Mar 2006
    Location
    Denmark
    Posts
    426

    Default

    Quote Originally Posted by John Jensen's Underpants View Post
    Bubka, right lick on the top left cell, the one both 'A' and '1' touch, and select unhide.
    How do you right lick? I dont want to know what kind of excel you have

  8. #8
    Join Date
    Jul 2004
    Location
    Wolverhampton, UK
    Posts
    5,000

    Default

    Quote Originally Posted by Bubka View Post
    How do you right lick? I dont want to know what kind of excel you have
    You mean you don't have the version where you have to tilt your head to the left or right and lick, a double lick? I need to upgrade.
    #You can play your card, I'll hold onto mine, Tied up in the reasons, Ace take your time#
    #Looks turn to lovers, flames into fires, Jack loves his tragedy, Queen her desires#

  9. #9
    Join Date
    Mar 2006
    Location
    Denmark
    Posts
    426

    Default

    Quote Originally Posted by John Jensen's Underpants View Post
    You mean you don't have the version where you have to tilt your head to the left or right and lick, a double lick? I need to upgrade.
    I leave the licking to other ppl

  10. #10
    Join Date
    Jul 2003
    Posts
    2,434

    Default

    Or just put the two side by side IE A and B then copy and paste to R when you are done.

  11. #11
    makelw's Avatar
    makelw is offline Member Of The Original Three International Superstar
    Join Date
    Oct 2005
    Location
    Hey, first I must tell my age and now where I live :D.. Finland, Alastaro
    Posts
    303

    Default

    Damn I already made Finnish, and I was put to 19th which is S, and didn't realise that
    Member Of The Original Three
    Tell us about your own country: http://www.newstarsoccer.com/newstar...ead.php?t=1905

  12. #12
    Join Date
    Nov 2005
    Posts
    37

    Default

    i have a problem with the "-" and the "+" , row 384-385 ... i cannot type them in the box , any suggestions ?

  13. #13
    Join Date
    Aug 2006
    Location
    İzmir, Türkiye
    Posts
    1,423

    Default

    Quote Originally Posted by Pitzi View Post
    i have a problem with the "-" and the "+" , row 384-385 ... i cannot type them in the box , any suggestions ?
    copy&paste from English column

  14. #14
    Join Date
    Nov 2005
    Posts
    37

    Default

    doesn't work ... i mean, i can type it but then appears smth like P=387 or things like that

  15. #15
    Join Date
    Aug 2006
    Location
    İzmir, Türkiye
    Posts
    1,423

    Default

    When typing manually I have the same problem too. But if you do as I said you can do it without having problem...
    First left click to 384th column, then without relasing mouse, drag to 385th column then relase the mouse. Now you're selected the rows
    384 and 385, now click copy button on toolbar then click the your language's 384th column and click paste.
    This should have solved your problem. (at least it worked for me )
    Last edited by raknet; 08-16-2007 at 01:01 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •