How to Compare Centimeters and Inches Visually in Excel
Question details
The user wants to create a visual comparison between centimeters and inches using exact shape dimensions in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a visual measurement reference to understand the size difference between centimeters and inches.
- Observed behavior
- The user needs to draw shapes with specific metric and imperial measurements to see that 1 inch equals 2.54 centimeters visually.
Ensure you are working in Page Layout view in Excel, as this is the only view where the ruler and exact physical dimensions for shapes are accurately displayed.
Change Ruler Units and Draw Exact Shapes
Switch Excel's ruler units between centimeters and inches to draw and compare shapes with precise measurements.
By adjusting the advanced display options in Excel, you can change the default measurement units. This allows you to draw shapes with exact physical dimensions, making it easy to visualize the 1 inch to 2.54 centimeters ratio.
Go to the View tab on the ribbon and click on Page Layout to ensure the ruler is visible and shapes scale correctly on the screen.
Navigate to File > Options > Advanced. Scroll down to the Display section, set Ruler units to Centimeters from the dropdown menu, and click OK.
Go to Insert > Shapes and select the Rectangle tool. Draw a square, then use the Shape Format tab to set its exact height and width to 1 cm.
Return to File > Options > Advanced, change the Ruler units to Inches in the Display section, and click OK.
Insert another rectangle and use the Shape Format tab to set its height and width to 1 inch. Place it next to the 1 cm square to visually compare the sizes.
Visually Compare Measurements in WPS Spreadsheet
WPS Spreadsheet offers precise shape formatting and unit adjustments, allowing you to easily create visual comparisons for centimeters, inches, and other measurements.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet.
- 2. Insert a Shape: Go to the Insert tab, click Shapes, and draw a rectangle on your sheet.
- 3. Adjust Shape Size: Select the shape, go to the Drawing Tools tab, and enter exact values (e.g., 1 cm or 1 in) in the Height and Width boxes.
- 4. Compare Visually: Draw a second shape with the alternative unit to instantly see the visual difference side-by-side.
Frequently Asked Questions
Why are my shapes not printing at the exact size I set in Excel?
Printer scaling settings or monitor resolution can affect how shapes appear or print. Ensure your print settings are set to 'Actual Size' or '100% scaling' rather than 'Fit to Page'.
Can I change the default measurement unit for all new Excel workbooks?
Yes, the Ruler Units setting in File > Options > Advanced > Display applies globally to the Excel application, so all new and existing workbooks will use the selected unit until you change it again.
How do I view the ruler in Excel?
The ruler is only visible in Page Layout view. To enable it, go to the View tab, click Page Layout, and ensure the 'Ruler' checkbox in the Show group is checked.
Is there a formula to convert inches to centimeters in Excel?
Yes, you can use the CONVERT function. For example, typing =CONVERT(1, "in", "cm") in a cell will return 2.54, which is the exact centimeter equivalent of one inch.
