I there anything I can do about inconsistent keyboard shortcuts?
Our take
I am getting really pissed off with the fact that scrolling left and right is Ctrl+Shift+Mousewheel in Excel, but only Shift+Mousewheel when using Excel in SharePoint. I am constantly zooming in and out accidentally when I'm using a spreadsheet in SP due to pressing the Ctrl key, or doing nothing in native Excel because I'm not pressing the extra button. It seems the Ctrl+Shift+Mousewheel shortcut doesn't exist in SP, so it reverts to the Ctrl+Mousewheel zoom function if you press both keys. Even if this combo did nothing it wouldn't be too bad, but I'm constantly zooming when I want to scroll.
I tried a quick google and the suggestions on changing the settings described adjusting options that I don't appear to have in my menus (unless I'm looking in the wrong place). If anyone has any guidance or alternatives that will work I'd appreciate it. Changing either setting to match the other would be good. I just need it to be consistent across both versions for the muscle memory.
I would also like to thank Microsoft's designers and engineers for giving the same program two different control schemes. Genius move.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Stop excel from jumping while scrollingSo I don't know how to frame this more accurately. I am using excel for some light text analysis purposes (yeah yeah there is better and I should probably just use different software). When I scroll, excel keeps putting the cell I am scrolling to on top of the screen, but this confuses my brain. I want to have the cell in the middle of the screen so I can situate it to the last one. Any chance someone understands what I mean, and knows a solution? I tried changing the scroll lock, frozen pans etc... but nothing seems to change excels bad habit of deciding for me, where the current cell is supposed to be. thank you submitted by /u/Alyano95 [link] [comments]
- Hyperlink on Excel MobileI am building a complex spreadsheet for an operational task at work. Without going into detail essentially employees that are out on the road will use cell phones or tablets to enter data for employees that are at the home office to print. The current set up is chaos. In my workbook, there are many hyper links that on desktop are one touch however, in mobile, you have to click, two sometimes three drop downs to open the link. I have a mixture of formula hyperlinks that are title words, button style, hyperlinks attached to a text box or picture that are above the cell and within the cell. They all do the same thing. In Excel online some perform as one touch and some you have to open the link then click the link. It would be fine if the clicking wouldn’t result in hyperlinks getting deleted or messed up and I have too many tasks to micromanage the corrections. Does anyone have any suggestions on how to make these perform as one touch on mobile? submitted by /u/Present_Brush7357 [link] [comments]
- Font formatting of a calculation dashboard KEEPS reverting every time the data in the other sheets is updatedI am at my wits end, every time I open this spreadsheet the formatting of these cells (supposed to be large and extremely readable to low-tech users on same team) reverts back to Calibri size 11 for some reason. I even created a custom cell style to try and force it to stay that way and I can see that it's selected in the menu, but not reflected whatsoever. Is it just impossible to format cells with a constantly changing calculation? What can I do here?? I feel like I have gone through every formatting constraint/rule there is to try and force it to behave but it always changes back, even if its not right away. It's a spreadsheet stored on sharepoint primarily but I don't know if that makes a difference. Advice appreciated. 😞 submitted by /u/vailette [link] [comments]
- Has Excel been garbage for other people lately, too?I’ve used it for over a decade and just this past year, I feel like it’s having an issue at least everyday. It’s mostly with the focus switching to the wrong workbook, clicking in cells not being registered correctly, and some keyboard shortcuts just breaking randomly until I restart. Working in excel used to be a pleasure; now it annoys me at least a couple times a day. I mostly just needed to vent because wtf Microsoft? Edit: to clarify, I’m using the Microsoft 365 version which is probably part of the problem. submitted by /u/TheInternetShill [link] [comments]