Sometimes we need to change the column width of Excel in mm. In this article, we will show you how to change the column width in mm of Excel with 5 easy approaches. We have also included some relevant concerns at the end of this article. So, let’s get started.
📂 Download Excel File
Download free workbook from here:
How to Change Column Width of Excel in mm from Inch with These Steps
While writing this article, “5 Ways to Change Column Width of Excel in mm ”, we’ve considered a dataset that contains approximately 5 columns and 12 rows. In this dataset, we added Name, Researcher ID, City, and Country to make you better understand. But if you want, you can change the entities and put your own values.
If you want to change the column width in mm of Excel then you can do it from the Excel option. It is not a strenuous process. You can do it by maintaining the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Excel worksheet.
- Secondly, select the File tab.
- Then click on Options.
- Now you will get a dialogue box name Excel Options.
- Thirdly, go to the Advanced option.
- Select Millimeters on Ruler units.
- Finally, click on OK.
Undoubtedly, this is a very handy technique to work on.
Learn to Set Column Width of Excel in mm with These 5 Approaches
5 approaches, which are given below, are very effective to change the column width of Excel in mm. You can follow these approaches with no difficulty.
1. Changing Column Width by Dragging
Using a column width input box is also a simple way to change the Column Width in mm of Excel. You just have to follow the below steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, go to the View tab.
- Secondly, select Page Layout.
- Thirdly, select the D column and right-click.
- Then select Column Width.
- Now you will get a dialogue box name Column Width.
- Give your desired width and then press OK.
- Finally, you will have your required result.
Truly, we can follow the process easily.
2. Applying Drag Option
If you want to change the column width in mm of Excel, you may use the drag option. It is a very straightforward way. Follow the given steps.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, select column of D.
- Secondly, use the fill handle icon and drag it Rightward until you get your desired column width.
- Consequently, this will give your the required result.
Finally, we must say that we can do this with ease.
3. Substituting Width of Multiple Columns
Substituting the width of multiple columns is a very good approach to changing the column width in mm of Excel. You just have to maintain the below steps.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select the C, D, and E
- Secondly, employ the fill handle icon and drag it Rightward until you get your desired column width.
- Finally, this will change the column width in mm.
This is unquestionably a highly useful strategy to practice.
4. Selecting Cells to Change Width in mm
You can select the cells to change the column width in mm of Excel. To achieve the process you just have to follow the steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, you need to select cell E7.
- Secondly, go to the Home tab.
- Then select the Cells option.
- Now select the Format option.
- Afterward, click on the Column Width.
- Now you will get a dialogue box name Column Width.
- Give your required width and then tap OK.
- Eventually, you will find the desired result as well.
Without a doubt, using this tactic periodically will be really beneficial.
📕 Read More: 5 Approaches to Reset Cell Size to Default in Excel
5. Adopting Keyboard Shortcuts
If you want, you can adopt a keyboard shortcut to change the column width in mm of Excel. Follow the given steps.
⬇️⬇️ STEPS ⬇️⬇️
- First, go to the Excel worksheet.
- Secondly, hold the Alt key and then press H, O, and W keys consecutively.
- Now you will get a dialogue box name Column Width.
- Give your required width and then you need to press OK.
- Consequently, this will change the column width in mm.
Without a doubt, employing this strategy on a regular basis will be really advantageous.
How to Set Column Width in Inches/cm in Excel
If you want to change your column width in inches of Excel then this portion is for you. You just have to follow the below steps given here.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, you need to go to the Excel worksheet.
- Secondly, you have to select the File tab.
- Then click on Options.
- Now you will get a dialogue box name Excel Options.
- Thirdly, go to the Advanced option.
- Select Inches on Ruler units.
- Finally, click on OK.
Set Column Width in Inches/cm
Again Excel column width can be converted to cm. It is straightforward and simple. Just maintain the following steps to achieve this.
⬇️⬇️ STEPS ⬇️⬇️
- First, you just go to the Excel worksheet.
- Secondly, you have to select the File tab.
- Then click on Options.
- Now you will find a dialogue box name Excel Options.
- Thirdly, you need to go to the Advanced option.
- Select Centimeters on Ruler units.
- Finally, click on OK.
Eventually, this will make your column width in inches or cm when you intend to change.
How to Adjust Column Width in Excel
You can adjust column width in Excel by following the necessary steps given below.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, you need to select column E.
- Secondly, go to the Home tab.
- Then select the Cells option.
- Now select the Format option.
- Afterward, click on the Autofit Column Width.
- Finally, you will see the adjusted column width which you needed.
That’s how you can adjust the column width in Excel.
📕 Read More: How to Make All Cells Same Size in Excel
📄 Important Notes
You should be aware of the following things while performing the processes mentioned above:
🖊️ You need to be careful while changing the Excel options for the Ruler Units.
🖊️ While using the input box give the Column Width properly.
📝 Takeaways from This Article
If we summarize the whole article, we have got some points.
📌 Firstly, we reshaped the Excel options to change the column width in mm of Excel.
📌 Secondly, we used a column input box.
📌 Thirdly, we applied the Drag option.
📌 Fourthly, we substituted the width of multiple columns.
📌 Fifthly, we used keyboard shortcuts.
📌 Sixthly, we changed the Excel column width in inches.
📌 Afterward, we also changed the Excel column width in cm.
📌 Finally, we tried to show you how to adjust column width in Excel.
Conclusion
We wish that you would be able to change the column width in mm of Excel using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website www.ExcelDen.com.