Fix the Missing Scroll Bar in Excel for Mac Text Import
Question details
The user needs to navigate horizontally while setting column breaks for a wide fixed-width text file in Excel for Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Importing a wide fixed-width text file with the Text Import Wizard.
- Observed behavior
- The wizard may hide the horizontal scroll bar, making columns beyond the visible area difficult to adjust.
Have the text file ready and note your current macOS scroll-bar setting so you can restore it after importing.
Set macOS to Always Show Scroll Bars
Use this workaround when the horizontal scroll bar is hidden in Excel's fixed-width Text Import Wizard.
Choose Apple menu > System Settings > Appearance. On older macOS versions, open Apple menu > System Preferences > General.
Under Show scroll bars, select Always.
In Excel, click Cancel in the current Text Import Wizard, then start the text-file import again from the Data tab.
Choose the fixed-width import option and use the horizontal scroll bar to reach and adjust column breaks beyond the visible area.
After completing the import, return to the macOS scroll-bar settings and select your previous option if desired.
Send Feedback to Microsoft if the Scroll Bar Remains Missing
Use this option if the macOS setting does not make the wizard easier to navigate.
Work With Imported Spreadsheet Data in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible files in WPS Spreadsheets to continue working with your data; it does not change Excel's Text Import Wizard.

Frequently Asked Questions
Where is the Show scroll bars setting on a Mac?
Open Apple menu > System Settings > Appearance and select Always under Show scroll bars. On older macOS versions, look in System Preferences > General.
Do I need to restart the text import after changing the setting?
Yes. Cancel the current Text Import Wizard and start the import again from Excel's Data tab so the wizard can display the scroll bar.
Will the mouse wheel scroll horizontally in the wizard?
Not necessarily. The Always setting may reveal the horizontal scroll bar, but mouse-wheel scrolling may still be unavailable.
What can I do if the scroll bar is still missing?
Check that Show scroll bars is set to Always, cancel the wizard, and reopen the import. If the issue persists, use Excel's feedback button or Help > Feedback to report it to Microsoft.




