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

In this article, we’ll demonstrate two quick ways to draw a floor plan in Excel. Here’s an overview of the dataset we’ll be using.

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

## Method 1 – Using Border Command

Steps:

• Select cells B4 to H12 to draw the outside layout of the floor plan.

• From the Home ribbon, select Font → Borders → Outside Borders.

The outside borders of the floor plan are drawn.

Now, we draw the partition of the floor.

• From the Home ribbon, go to Font → Borders → More Borders.

A Format Cells dialog box opens.

• Select the Border tab.
• Select the right side border.
• Click OK.

The vertical partition in the middle of the floor is drawn.

• Draw the horizontal partition in the middle of the floor by repeating the process for drawing the vertical partition above.

• Similarly, draw the layout of the Bedroom, Living Room, Balcony, Store Room, Bath and Kitchen as in the screenshot below.

Read More: How to Draw Engineering Drawing in Excel

## Method 2 – Using Color Command

Steps:

• Select the entire worksheet by pressing Ctrl + A.

• Go to Home → Cells → Format → Row Height.

• Set the Row Height to 3 and similarly set the Column Width to 1.

The worksheet should like below:

Now we draw the outline of a floor.

• Go to Home → Font → Fill Color → Light Blue.

The outline of the floor is drawn.

• Similarly, draw the layout for the Bedroom, Living Room, Balcony, Bath, and Kitchen as in the below screenshot.

Read More: How to Draw Isometric Drawing in Excel

## Things to Remember

#N/A! errors will occur when the formula or a function in the formula fails to find the referenced data.

#DIV/0! errors will occur when a value is divided by zero(0) or the cell reference is blank.

## Related Articles

<< Go Back to Drawing in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF