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.
Floor Plan: Overview
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.
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. Using 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.
Read More: How to Draw Engineering Drawing in Excel
2. Applying 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  ribbon, then 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 ribbon, then 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 have been given in the below screenshot.
Read More: How to Draw Isometric Drawing 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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.
