The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Can't believe I don't know this, but hey.
How do I fix a sheet so you can't scroll down to infinity? You know, lock it so the whole sheet is just the cells you can see and you can't for example hold the down button and create a thousand more rows (or go across and create columns).
A few situations at work require me to implement and reverse this feature and I'm a little stumped :(
How do I fix a sheet so you can't scroll down to infinity? You know, lock it so the whole sheet is just the cells you can see and you can't for example hold the down button and create a thousand more rows (or go across and create columns).
A few situations at work require me to implement and reverse this feature and I'm a little stumped :(
Use the freeze panes option under the window menu.
Above and to the right of the scrollbars there are small notches. Simply drag them down/right and Excel will show two panes onscreen - a fixed area and the normal scrollable area.
Hmm, as far as I can recall, I've tried everything, but obviously I haven't or I would have solved it :D
It's probably something really simple too!
It's probably something really simple too!
I tried google for you but it didn't bring anything up. Have you tried messing around with the options?
Yeah yeah. Any serious answers?
Bullett wrote:
> scroll down to infinity?
omgogm!
you should scroll right down to infinity and tell us what the number is!
mathematicians worldwide will be stunned!
> scroll down to infinity?
omgogm!
you should scroll right down to infinity and tell us what the number is!
mathematicians worldwide will be stunned!
Can't believe I don't know this, but hey.
How do I fix a sheet so you can't scroll down to infinity? You know, lock it so the whole sheet is just the cells you can see and you can't for example hold the down button and create a thousand more rows (or go across and create columns).
A few situations at work require me to implement and reverse this feature and I'm a little stumped :(
How do I fix a sheet so you can't scroll down to infinity? You know, lock it so the whole sheet is just the cells you can see and you can't for example hold the down button and create a thousand more rows (or go across and create columns).
A few situations at work require me to implement and reverse this feature and I'm a little stumped :(