Rob Posted October 19, 2014 Posted October 19, 2014 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? Quote
Rob Posted October 19, 2014 Author Posted October 19, 2014 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. Quote
Paulus Posted October 19, 2014 Posted October 19, 2014 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. Quote
Rob Posted October 19, 2014 Author Posted October 19, 2014 Very good again. You might get a permanent position soon as the man who can defeat binary bloody-mindedness. Ta. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.