How to Draw a Floor Plan in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Using AutoCAD software, we can easily draw a Floor Plan. we can also do that using Microsoft Excel. The Floor Plan drawing depicts the relationships between rooms, spaces, traffic patterns, and other physical characteristics on one level of a structure in architecture and building engineering. Today, in this article, we’ll learn two quick and suitable ways to draw a floor plan in Excel effectively with appropriate illustrations. Here’s an overview of the dataset for today’s task.

Table of Contents hide

Download Practice Workbook

Introduction to Floor Plan

2 Suitable Ways to Draw a Floor Plan in Excel

1. Use Border Command to Draw a Floor Plan in Excel

2. Apply Color Command to Draw a Floor Plan in Excel

Things to Remember

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Floor Plan.xlsx

Introduction to Floor Plan

A floor plan is a technical drawing to scale that depicts the relationships between rooms, spaces, traffic patterns, and other physical characteristics on one level of a structure in architecture and building engineering. The dimensions of the rooms and the lengths of the walls are typically drawn between the walls. Details on fixtures like sinks, water heaters, furnaces, etc. may also be included in floor layouts. Floor drawings may consist of construction notes that outline finishes, building techniques, or symbols for electrical components.

2 Suitable Ways to Draw a Floor Plan in Excel

There are two suitable ways to draw a floor plan in Excel. Following these two methods, we can easily create a floor plan in Excel. The methods are given below.

1. Use Border Command to Draw a Floor Plan in Excel

In this section, we will use the border command to draw a floor plan. From our dataset, we can easily do that. Let’s follow the instructions below to draw a floor plan in Excel!

Step 1:

First of all, select cells B4 to H12 to draw the outside layout of the floor plan.

After that, from the Home ribbon, go to,

Home → Font → Borders → Outside Borders

As a result, you will draw the outside borders which have been given in the below screenshot.

Step 2:

Now, we will draw the partition of the floor. To do that, from the Home ribbon, go to,

Home → Font → Borders → More Borders

Further, a Format Cells dialog box will appear in front of you. From the Format Cells dialog box, firstly, select the Border tab. Secondly, select the right side border under the Border At last, press OK.

As a result, you will draw the vertical partition in the middle of the floor.

Step 3:

Hence, we will draw the horizontal partition in the middle of the floor. To do that, simply repeat step 2.

Similarly, repeating step 2, we will draw the layout of the Bedroom, Living Room, Balcon, Store Room, Bath, and Kitchen which have been given in the below screenshot.

2. Apply Color Command to Draw a Floor Plan in Excel

In this method, we will apply the Color command to draw a Floor Plan. From our dataset, we can easily do that. This is also a time-saving way. Let’s follow the instructions below to learn!

Steps:

First of all, select the entire worksheet by pressing Ctrl + A on your keyboard.

Hence, we will give Row Height and Column Height. We can do that from the Home From your Home ribbon, go to,

Home → Cells → Format → Row Height

After that, give the Row Height as 3 unit and similarly give the Column Height as 1 unit.
As a result, you will get your worksheet like below.

Now, we will draw the outline of a floor. We can do that from our Home From the Home ribbon, go to,

Home → Font → Fill Color → Light Blue

Hence, we will be able to draw the outline of the floor.

Similarly, we will draw the layout of the Bedroom, Living Room, Balcony, Bath, and Kitchen which has been given in the below screenshot.

Things to Remember

👉 #N/A! error arises when the formula or a function in the formula fails to find the referenced data.

👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.

Conclusion

I hope all of the suitable steps mentioned above to draw a floor plan will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.