Horizontal scroll is not working.
When I import a text file and want to select all of the columns as text the horizontal scroll feature does not work and I can only change what ever I can see in the window to text. I use the feature on a weekly basis. This makes excel 2016 unusable for me on a Mc.
By setting your scroll bars to be always shown in your MacOS general settings, you are able to scroll horizontally in the text import wizard.
We will prioritize this issue accordingly with other issues based on the votes and interest that we see here.
Steve K [MS Excel]
I found another workaround that doesn't require enabling "always show scroll bars" in MacOS. I found that if I right-click where the scroll bar should be at the bottom of the columns preview, it will appear long enough to click and drag it.
Would be nice to see this get a proper fix though, it seems like a small thing.
This is a serious issue for my workflow, looking at abandoning Excel altogether even though it has other features I rely on heavily.
The Excel Team's suggested workaround does nothing but show scrollbars - I still cannot actually scroll in the text import wizard.
I wouldn't have to use the import wizard at all if Excel wasn't so aggressive with changing data in CSVs when opening the file. Guess I'm going back to Google Docs or OpenOffice.
I signed up just so that I could comment here.
This is an annoying, frustrating bug.
It may have a workaround that works, BUT:
Each and every mac user who will want to import a large dataset as text will encounter this issue. Each and every one of them will try to find a solution, and most will not know where to look (and those who do will still spend a lot of time).
This solution cannot be permanent.
Very shameful this major bug is still there - without any normal workaround. Very very bad.
This is absurd. Microsoft please fix. You can force scrollbars on in-application content that you know is wider than the viewport.
Graeme Thorn commented
Two comments on this:
If the default import in the wizard wasn't "General" but "Text" then this wouldn't be so much of an issue, as the formats could be fixed afterwards: every time I import data which includes text such as "Sept9" or "March1" (which are *not* dates, but gene names) they get converted to dates and I manually have to replace them.
Secondly, allowing the columns in the wizard to be selected by moving the cursor keys rather than the mouse/scroll bar would enable this to be worked round for everyone, not just Mac users.
Joseph - I think you've misunderstood the issues others are having. I have no frozen panes. This is not an issue in the workbook, but rather in the text import wizard.
Open a CSV file in Text Edit
Copy the data
Paste into Excel
Choose "Use Text Import Wizard" from the dropdown under the data
Choose comma as the delimiter
Try to scroll over in the "Preview of selected data" screen. It won't scroll unless you have scrollbars enabled always.
Joseph J. Radler commented
I just messed around with some of the view settings for Excel in MacOS Mojave. It seems that the "Panes" are frozen by default in the "View" menu. I managed to fix the horizontal scrolling issue by clicking "View > Unfreeze Panes". Bingo! Horizontal scrolling is back!
I agree that it's been rather annoying to have horizontal scrolling disabled. I'm glad the fix is literally just a toggle switch that has been hiding from me in plain view all this time!
System: MacBook Pro running MacOS Mojave running MS Excel for Mac ver. 16.19.
Hopefully this works for y'all! I don't have to have my scrollbars turned on to "Always" either, which is nice because I'm one of those annoying minimalist types who gets very easily distracted!
This issue is so utterly annoying I can't even begin to explain my frustration. Please fis this.
Ranganath Samudrala commented
Setting scroll bars to be always shown causes a few other applications to crash, like Eclipse IDE.
Setting your scrollbars to "always" does at least allow you to get to the other columns.
But you can only do so bar dragging the scrollbar thumb; you can't use your trackpad or mouse horizontal scroll gesture, or the keyboard.
This is a ridiculous setback for Excel 365 for Mac. Should be fixed. Bush league.
I agree and disagree Noel. You don't have to do that in Excel 2011. You only have to do it in 2016. What I said to do was simply a "workaround". Microsoft should adopt Apple's methodology and make the horizontal scrollbars to appear while scrolling. I hate having scrollbars always show and I will not set that option to always just for this one function.
JB has hit the nail on the head. It's more of an Apple Scroll Bar issue than an Excel issue. Open 'System Preferences' either from your dock or from the Apple Menu (top left), select 'General', then next to the 'Show Scroll Bars' option select 'Always'. When you then open Excel and try and import a text file, the horizontal scroll bar is BACK!! This has frustrated me for 12 months and it now works.
Still an issue almost 2 years later. This works fine in Excel 2011 but does not in 2016. This is the one and only reason I still keep Excel 2011 on my Mac. In the community it was said that we should just turn on the option to have scrollbars always visible. I hate that option and while it does work, that is not a "fix". That is a workaround.
This coulkd be related to "fixed columns". Can be deactivated in the Window Menu
Mike Crader commented
I have reported this issue separately as one that involves both vertical scrolling through all records and horizontal scrolling to the end of all fields. These are available in the Windows version and are critical to being able to define a large fixed width field text data connection. Like others I am forced to use the Windows version. Incidentally, the macOS version connection properties check box to resize fields during a refresh refuses to stay unchecked after a properties edit. Again, the only way to get this done is in the Windows version. These issues have been around through many versions so I suspect they are not important enough to the developers to fix. Hopefully our comments here will convince them to revise that low priority.
The horizontal scrolling on the Text Import Wizard Step 3 of 3 is also a major issue for me as I use it almost every day. At the moment I have to use an older version of Excel on a different Mac to import .txt files which means it is preventing me from upgrading my other Macs until this is resolved.
Why is this is still a problem? Seems like it should have been sorted long ago.
OP is referring to the "Text Import Wizard - Step 3 of 3", Curt_L you may have misunderstood.
I also have numerous occasions when imported CSVs need to have text format forced upon them, it causes a lot of headaches and I have to find an available PC just to do this repetitive task.