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
| +137 | AI Creating More Work | 44 | 3h |
| +131 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 17 | 11h |
| +128 | Shit PWP Culture | 86 | 1h |
| +113 | Is pay at BofA really that bad? | 58 | 2h |
| +48 | Day at Macquarie | 3 | 11h |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 1d |
| +41 | UBS Group AG is coming under renewed US pressure over Credit Suisse’s handling of Nazi-Linked accounts | 3 | 1h |
| +34 | Analyst Shows Up in the Prada Sped Slipper — What Are You Doing? | 8 | 57m |
| +29 | Law school instead of MBA for RX Banking | 5 | 1d |
| +29 | No BB RO 2026 | 10 | 4h |
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".
Unde excepturi sunt repellat. Dolorem quidem molestiae illum fugiat et. Dolores repellat eos voluptatum non deserunt. Eos veritatis quis ipsum quae. Autem omnis et architecto dolorum.
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...