Small Excel Problem

[Olsinho]

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?

[Bubka]

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

[Olsinho]

Thanks, much easier now;)

[Bubka]

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

[JJU]

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.

[Fabrizio Gatti]

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

[Bubka]

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 :blimey:

[JJU]

How do you right lick? I dont want to know what kind of excel you have :blimey:
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.

[Bubka]

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 ;)

[statto]

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

[makelw]

Damn I already made Finnish, and I was put to 19th which is S, and didn't realise that :P

[Pitzi]

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

[raknet]

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 ;)

[Pitzi]

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

[raknet]

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 :D )

[Dimitrije]

Leave it alone,and when you send your translation to Fab,he will add + and -.;) I think,right Fab?:D

[Fabrizio Gatti]

The thing is that the program thinks you're going to add a forumla there :)

I believe you should press + / - then the del. key, so the program ignores any formula intentions ;)

Failing that, just send it to me and I'll put those :)

[Silver Surfer]

You just press enter after the + / -.
Excel will leave it be and move to next row.