Batch Resizing Columns

Posted on 2009-12-28
Medium Priority
Last Modified: 2013-11-25
How can I resize all of the columns on all of the excel files in the a given directory?
Question by:eracer001
LVL 31

Accepted Solution

gowflow earned 1500 total points
ID: 26137908
Well try this file and let me know her eis how it works
1) File is 2003 Excel Version and can work 2007
2) Set your security Macro to Medium before running the file: Tools/Macro/Security choose Medium and close Excel
3) Run this file and Enable Macro When prompted
4) Run macro 'ResizeColumnsAllFiles' by doing: Tools/Macro and the Play Sign
5) Choose the Directory that you want to resize columns
6) it will find the first file and display it and select the first sheet and ask you for a column size input what you want like 8 15 or whatever digit you want. Then it will do it for oyu if the workbook has an other sheet it will display it and ask you to input the column with the InputBox show you the file name and the sheet it is processing. It will do all workbooks in the mentioned directory.

If you need more automation like just input once and it doing the whole thing for you let me know it is a minor change.

Author Closing Comment

ID: 31670569
Worked good, but I had to mod the file so it wouldn't ask for every single sheet's column width.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question