5 Easy Ways to Change Column Width of Excel in mm

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.

Dataset of Excel Column Width in mm

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.

Excel Options dialogue box of Excel Column Width in mm

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.

APPROACH

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.

Page Layout option to Excel Column Width in mm

  • Thirdly, select the D column and right-click.
  • Then select Column Width.

Using the Column Width option from right-click to Excel Column Width in mm

  • 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.

APPROACH

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.

Applying the Drag option to Excel Column Width in mm

Finally, we must say that we can do this with ease.

APPROACH

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.

Changing the width of multiple cells to Excel Column Width in mm

This is unquestionably a highly useful strategy to practice.

APPROACH

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.

Using Cell Format to Excel Column Width in mm

  • 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.

Result of using the Cell Format

Without a doubt, using this tactic periodically will be really beneficial.

📕 Read More: 5 Approaches to Reset Cell Size to Default in Excel

APPROACH

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.

Applying the keyboard shortcuts to Excel 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.

Excel options to convert in inches of column width

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.

Excel options to convert in cm of column width

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.

Using the Autofit Column Width to adjust column width

  • Finally, you will see the adjusted column width which you needed.

Result of adjusting column width

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.

(Visited 30 times, 1 visits today)
Jonayed

Jonayed

Hello! My name is Jonayed. I've completed my graduation from BUET in Naval Architecture & Marine Engineering. As Excel is very interesting to me, I like to do various types of research regarding Excel. My inquisitive nature drives me to find solutions to different types of problems with Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo