Text Data Import in Excel for Mac not allowing selection of columns for data type changes

%3CLINGO-SUB%20id%3D%22lingo-sub-1634317%22%20slang%3D%22en-US%22%3EText%20Data%20Import%20in%20Excel%20for%20Mac%20not%20allowing%20selection%20of%20columns%20for%20data%20type%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634317%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20most%20recent%20desktop%20version%20of%20Excel%20for%20the%20Mac%2C%20Version%2016.40.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20import%20a%20CSV%20file.%26nbsp%3B%20Form%20a%20new%20document%2C%20I%20go%20to%20Data%20-%26gt%3B%20From%20Text%20and%20select%20a%20CSV%20file%20to%20access%20the%20Text%20Import%20Wizard.%26nbsp%3B%20I%20select%20Delimited%20(Step%201)%20then%20Comma%20(Step%201).%20At%20Step%203%2C%20I%20need%20to%20select%20all%20the%20fields%20and%20ensure%20they%20are%20formatted%20as%20Text%20(I%20have%20a%20lot%20of%20leading%20zeros%20and%20need%20the%20exact%20number%20of%20spaces%20in%20my%20file).%20From%20this%20preview%2C%20I%20can%20see%20about%207%20columns%20of%2040.%26nbsp%3B%20I%20can%20use%20my%20mouse%20to%20select%20any%20of%20the%20seven%20but%20am%20unable%20to%20use%20my%20arrow%20keys%20to%20move%20beyond%20the%207th%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20does%20not%20allow%20me%20access%20to%20my%20other%2033%20columns%20that%20need%20to%20be%20set%20to%20Text%20rather%20than%20General%20and%20it's%20causing%20data%20issues%20when%20it's%20imported%20into%20Excel%20since%20it's%20dropping%20my%20leading%20zeros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20this%20same%20operation%20in%20Excel%20on%20Windows%20in%20VMWare%20on%20the%20same%20machine%2C%20I%20do%20not%20have%20this%20issue.%26nbsp%3B%20Is%20anyone%20able%20to%20recreate%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1634317%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1638131%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Data%20Import%20in%20Excel%20for%20Mac%20not%20allowing%20selection%20of%20columns%20for%20data%20type%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781807%22%20target%3D%22_blank%22%3E%40dcshuler01%3C%2FA%3E%26nbsp%3BThat's%20a%20somewhat%20odd%20setting%20on%20your%20Mac.%20Not%20Excel%20related.%20Don't%20ask%20why%2C%20but%20you%20need%20to%20go%20to%20the%20Apple%20logo%20(top%20left)%2C%20System%20Preferences...%2C%20General.%20Then%2C%20check%20%22Always%22%20in%20the%20%22Show%20scroll%20bars%22%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-09-05%20at%2016.21.47.png%22%20style%3D%22width%3A%20290px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216744iAC5B1DB2957E7C2E%2Fimage-dimensions%2F290x247%3Fv%3D1.0%22%20width%3D%22290%22%20height%3D%22247%22%20title%3D%22Screenshot%202020-09-05%20at%2016.21.47.png%22%20alt%3D%22Screenshot%202020-09-05%20at%2016.21.47.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Text Import Wizard.  I select Delimited (Step 1) then Comma (Step 1). At Step 3, I need to select all the fields and ensure they are formatted as Text (I have a lot of leading zeros and need the exact number of spaces in my file). From this preview, I can see about 7 columns of 40.  I can use my mouse to select any of the seven but am unable to use my arrow keys to move beyond the 7th column. 

 

This does not allow me access to my other 33 columns that need to be set to Text rather than General and it's causing data issues when it's imported into Excel since it's dropping my leading zeros.

 

When I try this same operation in Excel on Windows in VMWare on the same machine, I do not have this issue.  Is anyone able to recreate this? 

3 Replies
Highlighted

@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.

 

Screenshot 2020-09-05 at 16.21.47.png

Highlighted

@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.

Highlighted

@dcshuler01 I guess Macs aren't always as intuitive as one expects.