•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel on Mac shifts between open sheets when, while entering a function, I hit Cmd+Shift+Arrow or Ctrl+Shift+Arrow, WHY?
Our take
If you're experiencing issues with Excel on your Mac, where using Cmd+Shift+Arrow or Ctrl+Shift+Arrow while entering a function like SUM switches you to another open file, you're not alone. This behavior can be frustrating and may stem from shortcut mappings or settings within Excel. Understanding the potential reasons behind this issue can help you regain control over your workflow. Join the discussion to explore solutions and insights from others who have faced similar challenges.
So I use Excel on my Macbook.
Whenever I try entering a function like SUM and I want to select a range with Ctrl/Cmd+Shift+Arrow it switches to another open Excel file and I don't understand why. It happens 95% of the time, and I'm not sure if there's a weird shortcut mapping or something weirder going on.
Has anyone gone through this? Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to move around in formula with arrow keys on excel for macMan, I'm just starting to use excel but please help. in formula, if I command + shift + down to highlight all data and command + delete to come back to active cell, I can't move my arrow key left or right to select more data set. I have to use my cursor to do so. and if i push enter after the formula, the computation doesnt show up right away. i have to mess with the column width just to see it. Am I tripping or is this a bug? please help. submitted by /u/vlexhvnst33z [link] [comments]
- {Ctrl+W} -- 'Close file' or 'Hide column'I have been issues with Excel lately, in that {Alt+F} or selecting File is taking longer and longer to display. (I usually have 20-30 excel files open, and it appears that something in the File Screen iterates through the open files in the manner of 1, 1,2, 1,2,3, 1,2,3,4, etc. -- not as bad as a n² or n! type of programming issue, but it's still extremely frustrating. ) To avoid this, switched from {Alt+F}, C to {Ctrl+W}. Today, Excel switched from {Ctrl+W} closing the file to instead hiding the column of the currently selected cell (s). Is this MS being "helpful" and messing with functionality? Or did I inadvertently change a setting somewhere and break it myself? Windows 10 Pro, OS Build 19045.6456 Microsoft® Excel® for Microsoft 365 MSO (Version 2603 Build 16.0.19822.20086) 64-bit submitted by /u/-Zlosk- [link] [comments]
- Arrow keys are not working when I reference a cell from another tab.Hi everyone, whenever I type = and try to reference another cell on another tab, I am unable to click on a cell and use my arrow keys to move left or right. I can only go up and down. This problem has only started happening recently, so I am thinking I must have changed a setting or something by accident. Does anyone know what's going on? (I am also a MacBook user if that helps.) submitted by /u/No-Gold-5779 [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#real-time data collaboration#financial modeling with spreadsheets#real-time collaboration#google sheets