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
| +195 | Americas M&A League Table Q2 Updated | 77 | 15h |
| +142 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 37 | 4h |
| +126 | Restructuring: Anti-climactic Experience | 34 | 14h |
| +94 | IB Net Worth / Savings Check | 43 | 16h |
| +79 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 18 | 3h |
| +78 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 3d |
| +54 | Stop sleeping on UBS - it’s pretty good | 15 | 1h |
| +48 | 2026 VAULT PRESTIGE RANKINGS | 29 | 21m |
| +39 | Investment Banking is Hard | 17 | 2d |
| +32 | AI + Financial Modelling | 11 | 3h |
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".
Molestias doloribus vitae impedit sit aperiam distinctio. Perferendis sed dolor quisquam voluptatem. Occaecati veniam dolorum error ullam in. Saepe facilis porro tenetur minima nostrum. Mollitia ullam dolor error dolorem laudantium.
Ea est enim deserunt ea quis adipisci dolor. Fugit adipisci repellendus assumenda quia. Harum et earum illo illum.
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...