How To Measure An Oblong Table For A Tablecloth In Excel

How to Measure an Oblong Table for a Tablecloth in Excel

Many tables are rectangular, but some are oblong. Oblong tables have rounded corners that add an elegant, sophisticated touch to any dining room. They require a specially measured tablecloth to ensure a perfect fit due to their different shape.

Measuring an oblong table for a tablecloth in Excel is a simple process that can be completed in a matter of minutes. By following these steps, you can create a custom tablecloth that perfectly complements your table and decor.

Before you begin measuring your table for a tablecloth, you will need the following equipment:

A tape measure or measuring tape
A pencil or pen
A piece of paper
Microsoft Excel

Once you have gathered your materials, follow these steps to measure your oblong table for a tablecloth in Excel:

1. Measure the length of the table

Use the tape measure to measure the length of your table from end to end. Do not include the overhang of the tablecloth in this measurement. Record this measurement on the piece of paper.

2. Measure the width of the table

Use the tape measure to measure the width of your table from side to side. Do not include the overhang of the tablecloth in this measurement. Record this measurement on the piece of paper.

3. measure the depth of the table

Use the tape measure to measure the depth of your table from the edge to the center. Record this measurement on the piece of paper.

4. Open Microsoft Excel

Open Microsoft Excel and create a new blank spreadsheet. In the first cell, enter the label "Length." In the next cell, enter the length of your table in inches. In the next cell, enter the label "Width." In the next cell, enter the width of your table in inches.

5. Calculate the tablecloth size

In the next cell, enter the formula "=Length + (2 * Depth)." This formula will calculate the total length of the tablecloth, including the overhang. In the next cell, enter the formula "=Width + (2 * Depth)." This formula will calculate the total width of the tablecloth, including the overhang. Add 12 inches to Length and Width measurements to get the size of the tablecloth.

6. Format the tablecloth size

Select the cells that contain the tablecloth size and format them as inches. To do this, click the "Home" tab and then click the "Number" drop-down menu. Select "Custom" and then enter "0.00"" in the "Type" field. This will format the tablecloth size to two decimal places.

7. Save the spreadsheet

Click the "File" tab and then click "Save As." Enter a name for the spreadsheet and then click "Save." You can now use this spreadsheet to create a custom tablecloth that perfectly fits your oblong table.