# How to Draw to Scale in Excel (2 Easy Ways)

We’ll draw a simple floor plan to scale.

### Method 1 – Using Border Options to Draw to Scale in Excel

#### Step 1 – Setting Up Row Height and Column Width

• Click on the Box in the left corner to select all the Rows and Columns of the Excel Worksheet.

• Go to the Home tab and click on Cells.
• Click on Format and select Row Height.

• The Row Height box will appear.
• Insert 9 as the Row Height.
• Click on OK.

• Click on Format and select Column Width.

• The Column Width box will appear.
• Insert 1 as Column Width.
• Click on OK.

#### Step 2 – Drawing Walls to Scale Using Borders in Excel

We will draw a Floor Plan of 25 by 35 ft using Borders in Excel.

• Select the range B4:Z38.
• Go to the Home tab and click on Borders.

• Select More Borders.

• The Format Cells box will open.
• From the Border tab in Style options, choose any Border. We will select the Double-line style.
• Add this Border to the Bottom, Top, Left, and Right of the Cell range.
• Click on OK.

• You will get the External Wall of the Floor Plan.

• Select the cell range B4:N14.
• Go to the Home tab and click on Borders.
• Select More Borders.

• The Format Cells box will appear.
• From the Border tab in Style options, choose any Border. We will select the Double-line style.
• Add this Border to the Bottom and Right of the Cell range.
• Click on OK.

• You will get the walls of a room of 13’ by 11’ in scale.

• To create a gap for the door, select cell range L14:N14.
• Go to the Home tab, click on Borders, and select More Borders.

• The Format Cells box will open again.
• From the Border tab, unselect the Border from the Bottom.
• Click on OK.

• This creates a gap in the wall.

#### Step 3 – Using Rectangles for Text in the Drawing

• Go to the Insert tab and click on Illustrations.
• Click on Shapes and select Rectangle.

• Insert a Rectangle and right-click on it.

• Select Edit Text.

• Type any description you want to add in the Rectangle. We will type Master Bedroom 13’ X 11’.

• Select the Text.
• Go to the Home tab and select Middle and Center Alignment.

• Select the Rectangle.
• Go to the Shape Format tab and click on Theme Styles.

• Select any Theme Style. We selected Colored Outline – Blue, Accent 5.

• You will get a room drawn in scale with a description in a Rectangle.

• Draw other rooms in scale and add descriptions to the rooms.

Read More: How to Draw Shapes in Excel

### Method 2 – Applying Fill Color to Draw to Scale in Excel

We will use a scale of 1 square unit (Cell) equivalent to 1 square foot. We will use walls of 1ft width and add color to them.

Steps:

• Set up the Row Height and Column Width of the cells following the same steps shown in Method 1.

• Select the cell range B4:AC4.
• Go to the Home tab and click on Fill Color.

• Select any Fill Color. We will select Blue, Accent 1, Darker 50%.

• Select the range B4:B43.
• Go to the Home tab and click on Fill Color.
• This will automatically select the Fill Color we selected previously.

• Select the range C43:AC43.
• Go to the Home tab and click on Fill Color.

• Select the range AC5:AC42 and use Fill Color.

• You will get the External Wall of the Floor Plan.

• Select the cell range P5:P16.
• Go to the Home tab and click on Fill Color.

• Use Fill Color on the range C16:L16.

• You will get the walls of a room of 13’ by 11’ in scale.

• Insert a Rectangle and add text to it following the same steps shown in Method 1.
• You will get a room drawn in scale with a description in a Rectangle.

• Draw other rooms in scale and add descriptions to the rooms.

Read More: How to Make Fishbone Diagram in Excel

## Practice Section

You can use a blank spreadsheet to practice.

## Related Articles

<< Go Back to Drawing in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF