Forum Discussion
dcshuler01
Sep 04, 2020Copper Contributor
Text Data Import in Excel for Mac not allowing selection of columns for data type changes
I have the most recent desktop version of Excel for the Mac, Version 16.40. I am trying to import a CSV file. Form a new document, I go to Data -> From Text and select a CSV file to access the T...
Riny_van_Eekelen
Sep 05, 2020Platinum Contributor
dcshuler01 That's a somewhat odd setting on your Mac. Not Excel related. Don't ask why, but you need to go to the Apple logo (top left), System Preferences..., General. Then, check "Always" in the "Show scroll bars" section.
dcshuler01
Sep 05, 2020Copper Contributor
Riny_van_Eekelen That was it, thank you. I still can’t use the arrow keys to navigate across the columns to scroll but can move the scroll bars with the mouse.
- Riny_van_EekelenSep 05, 2020Platinum Contributor
dcshuler01 I guess Macs aren't always as intuitive as one expects.