How to Change Units in Excel: Step-by-Step Guide to Adjust Measurement Settings

Learn how to change units in Excel for rulers and page layout views. Adjust measurements from inches to centimeters or millimeters easily.

94 views

To change units in Excel, go to the File tab, then select Options. In the Excel Options dialog box, click Advanced. Scroll down to the Display section. Here, you'll find options to change the units for the Ruler (used in Page Layout view), which can be set to Inches, Centimeters, or Millimeters. Unfortunately, Excel does not directly allow changing the unit of measurement for cell sizes; those are predominantly determined by your system settings.

FAQs & Answers

  1. Can I change the units for cell sizes in Excel? No, Excel does not allow direct changes to the unit of measurement for cell sizes. These sizes are primarily controlled by your system's settings.
  2. How do I access the ruler unit settings in Excel? Go to the File tab, select Options, click Advanced, then scroll to the Display section to find and change ruler units.
  3. What units can I select for the Excel ruler? You can set the Excel ruler units to Inches, Centimeters, or Millimeters within the Advanced options.

Watch More

For more detailed tips on customizing Excel and improving your workflow, explore our tutorials on Excel formatting, page layout adjustments, and advanced Excel options.

  1. How to Change Print Scaling in Excel: A Step-by-Step Guide Learn how to adjust print scaling in Excel for optimized printed documents. Fit sheets and more with simple steps!
  2. How to Fix Page Size in Excel: Step-by-Step Guide Learn how to fix page size in Excel by adjusting paper size settings for individual sheets or entire workbooks easily.
  3. How to Change the Paper Size to A4 in Excel for Printing Learn how to set your Excel worksheet to A4 paper size using the Page Layout tab for accurate printing and standardized documents.
  4. How to Standardize Page Size in Excel for Consistent Printing Learn how to standardize page size in Excel using the Page Layout tab to ensure uniform printing of all sheets in your workbook.
  5. How to Customize Page Size in Excel: A Step-by-Step Guide Learn how to customize page size in Excel to fit your printed content perfectly. Quick tips for Excel users!
  6. How to Change Excel Date Format to UK (dd/mm/yyyy) Easily Learn how to switch Excel to UK format and set the date display to dd/mm/yyyy with simple step-by-step instructions.
  7. How to Fix and Adjust Page Layout in Excel for Perfect Printing Learn how to fix and customize the Page Layout in Excel using Margins, Orientation, Size, and Page Setup for accurate printing results.
  8. How to Scale Excel Worksheets to Fit Paper Size for Printing Learn how to scale Excel spreadsheets to fit your chosen paper size using Page Layout settings for optimal printing results.
  9. How to Apply Paper Size to All Sheets in Excel Easily Learn the simple steps to apply paper size settings across all sheets in an Excel workbook quickly and efficiently.
  10. Why Is My Excel Printing So Small and How to Fix It? Learn why Excel prints small and how to fix it by adjusting scaling and print area settings for clear, correctly sized printouts.
  11. How to Select A4 Paper Size in Excel for Printing Learn how to set A4 paper size in Excel via the Page Layout tab for accurate printing of your documents.
  12. How to Manage Page Layout in Excel: Step-by-Step Guide Learn how to manage page layout in Excel using margins, orientation, print area, and page setup for professional printouts.
  13. How to Make Excel Cells Fit on an A4 Sheet: Step-by-Step Guide Learn how to fit Excel cells on an A4 page by adjusting Page Setup scaling options for perfect printing results.
  14. How to Select A3 Paper Size in Excel for Printing Learn how to easily set A3 paper size in Excel via Page Layout for optimal large format printing.
  15. How to Easily Fix Text Alignment in Excel Learn quick steps to adjust text alignment in Excel for a tidy and professional look.
  16. How to Select A2 Paper Size in Excel for Printing Learn how to set A2 paper size in Excel to print large worksheets correctly with simple steps in the Page Layout tab.
  17. How to Create an Index Card Size (3x5) in Excel for Printing Learn how to set up a 3x5 inch index card size in Excel by adjusting column width, row height, and page layout for perfect printing.
  18. What Is the Page Layout Option in Excel and How to Use It? Learn how Excel's Page Layout option helps you customize print settings like margins, headers, and orientation for professional documents.
  19. How to Make All Excel Sheets the Same Size for Printing: Step-by-Step Guide Learn how to set all Excel sheets to the same size for printing using page layout settings and the Format Painter tool.
  20. How to Make All Excel Columns the Same Width Easily Learn how to quickly adjust column widths uniformly in Excel with these simple steps.