Jump to content
British Coin Forum - Predecimal.com

50 Years of RotographicCoinpublications.com A Rotographic Imprint. Price guide reference book publishers since 1959. Lots of books on coins, banknotes and medals. Please visit and like Coin Publications on Facebook for offers and updates.

Coin Publications on Facebook

   Rotographic    

The current range of books. Click the image above to see them on Amazon (printed and Kindle format). More info on coinpublications.com

predecimal.comPredecimal.com. One of the most popular websites on British pre-decimal coins, with hundreds of coins for sale, advice for beginners and interesting information.

Rob

Anyone good with excel?

Recommended Posts

The wife cleaned my keyboard. :( and now an excel file is infinitely wide(?) and hitting the up/down/left/right arrows moves the whole document instead of going to the appropriate box on the page. I previously had it set to fit A4. Recoverable or start again?

Share this post


Link to post
Share on other sites

Is your scroll lock on?

Very good, thank you. :)

Next question. Why does it have A4 pages on the right hand side at least as far as box DX and probably further. All I want is a file about a thousand boxes long, and 6 wide to fit on A4 in x pages. Ta.

Share this post


Link to post
Share on other sites

Sounds as if, during the cleaning, the spread sheet was led to believe it was somewhat larger than it needs to be!

I would highlight just the cells that you want and copy/paste them into Sheet2 (assuming it's a new(ish) work book). You can then dispose of Sheet1.

Share this post


Link to post
Share on other sites

Very good again. You might get a permanent position soon as the man who can defeat binary bloody-mindedness. Ta. :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×