Data Import & Export

Fix the Missing Scroll Bar in Excel for Mac Text Import

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

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.
Before you start

Have the text file ready and note your current macOS scroll-bar setting so you can restore it after importing.

Solution 1Recommended

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.

1
Open scroll-bar settings

Choose Apple menu > System Settings > Appearance. On older macOS versions, open Apple menu > System Preferences > General.

2
Show scroll bars

Under Show scroll bars, select Always.

3
Restart the import

In Excel, click Cancel in the current Text Import Wizard, then start the text-file import again from the Data tab.

4
Adjust the columns

Choose the fixed-width import option and use the horizontal scroll bar to reach and adjust column breaks beyond the visible area.

5
Restore your setting

After completing the import, return to the macOS scroll-bar settings and select your previous option if desired.

Scrolling limitation: The scroll bar should appear after restarting the import, but mouse-wheel scrolling may still be unavailable in the wizard.
Free Microsoft Office alternative

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.

Open and edit imported spreadsheet data in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar interface helps make the move from Microsoft Office easierFree and lightweight for everyday spreadsheet work
microsoft office alternative - wps office

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.