Scrolling while editing cells in excel?
Anyone here know how to enable scrolling while in edit mode? It's really annoying to have to use the bar every time...
Thanks!
Trending Content - Investment Banking Forum
| +463 | Don’t work at UBS - UBS Sucks | 49 | 6m |
| +229 | Should My Intern Get a Return Offer? | 58 | 2d |
| +68 | Incompetent and annoying co-intern | 23 | 36m |
| +66 | Getting Laid in IB? | 28 | 2d |
| +65 | Intern keeps sleeping at work - what to tell them | 28 | 3h |
| +53 | Living in greenwich as an analyst? | 11 | 15m |
| +40 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 5 | 30m |
| +39 | NYC Associate Budget | 14 | 4h |
| +35 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +35 | Quick Thoughts on CVC AI Sale Process | 7 | 6h |
Career Resources
sort of a crude fix.. but:
that said, I can scroll using my mouse even in cell edit mode... look in settings, there has to be a way
i'm no stranger to google, and have no idea how to change this setting. I was only able to change the scroll to a zoom - but that's no good.
I don't think this is because I'm using 2013 is it?
This thread cracked me up
Sorry I have no idea what you're asking. Screen should scroll when you move (arrow keys) to the edge, use scroll wheel, or turn on scroll lock.
Scroll Lock my man.
Scroll lock you noob.
Scroll lock you noob.
You mean hitting F2?
exactly.
any thoughts on this? or is my comp the only one not allowing me to scroll while in F2?
Try options -> advanced -> enable 'Transition navigation keys'. I thought that was only for using ctrl+down/up/left/right but maybe it works for this? I don't know..
Not exactly it, but better than nothing - thanks.
I mistakenly said F2, without knowing that there is a difference between pressing F2 and clicking in the editing bar. This method doesn't work with the latter, but does with the former. Makes no sense.
Yes, it is because you are using Excel 2013. By default Excel 2013 does not allow this. It is a simple fix:
Excel Options -> Advanced -> Under the Edition Options, check the box that says "Allow editing directly in cells".
Consequuntur voluptas dolorem magni eligendi iure expedita. Ipsum velit labore eius distinctio.
Officia officia similique nobis officiis officiis quos nobis. Repellat asperiores explicabo cumque alias sit doloremque saepe. Odio dolorem dolores nisi est quisquam incidunt voluptates.
Earum consequuntur voluptatem quis eaque voluptate. Autem voluptas dignissimos ullam est quis dolor esse.
Maxime consequatur voluptate quis eum. Voluptas molestias quibusdam placeat laudantium aperiam sit. Quam perferendis quis et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...