How do I reset the scrollable columns in Excel to the default settings?

I tried to paste three values into a worksheet, into cells A1, B1, and C1. By accident I highlighted rows A, B and C before I pasted. That caused the values to be repeated throughout the rows, as far as excel would go. Then I saved the file, also by accident. Now my worksheet has thousands of columns I can scroll through, even though I deleted all those new columns. This is making all procedures in this worksheet very slow. Does anybody know how I can reset the number of columns to the default setting? I don't want to restrict what can be scrolled, I want to reset.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi shampouya

Have you Deleted contents or totally deleted the columns with empty cells?

Make sure to highlight all the columns and then right click and select delete.

You should Delete as below picture. This will adjust the scroll bar to default.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
select all rows that you don't like and the choose "Clear" - "Clear All"  from menu then Save
every thing will get back to normal
Rob HensonFinance AnalystCommented:
The default will always be 16,384 columns (out to column XFD) and rows down to 1,048,576. However, just because they are physically there, if they are not used they will not be included in the Used Range and the scroll bars should reflect that.

As Jean Marc has suggested physically deleting the surplus rows/columns should reset the used area but will also need a save to enforce it. FarWest's suggestion about using the Clear All sometimes works but not always.

Rob H
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.