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

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.

draw a floor plan in excel


Download Practice Workbook

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


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

Use Border Command to Draw a Floor Plan in Excel

  • 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

Use Border Command to Draw a Floor Plan in Excel

  • 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.

Use Border Command to Draw a Floor Plan in Excel

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.

Use Border Command to Draw a Floor Plan in Excel


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.

Apply Color Command to Draw a Floor Plan in Excel

  • 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

Apply Color Command to Draw a Floor Plan in Excel

  • 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

Apply Color Command to Draw a Floor Plan in Excel

  • 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.

Apply Color Command to Draw a Floor Plan in Excel


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.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo