How to Make a Floor Plan on Microsoft Excel

Microsoft Excel is the perfect tool for inputting, calculating, and analyzing business data like sales statistics, sales taxes, or commissions. On the other hand, this spreadsheet-manipulating application can also be used for creating high-quality floor plans. how-to-make-a-floor-plan-on-microsoft-excel

Download the Free How to Make a Floor Plan on Microsoft Excel Article in PDF

How to Make a Floor Plan on Microsoft Excel Download

How to Make a Floor Plan on Microsoft Excel

Microsoft Excel is one of the most versatile tools for creating documents and spreadsheets. With it, you can also create and design floor plans such as a house plan or industrial plan.

  • Step 1: Set Up Row and Column

    how-to-make-a-floor-plan-on-microsoft-excel-step-1

    Once the spreadsheet is opened, modify the cells to generate grid coordinates so that scaling will be easy. You need to select all the cells using the Ctrl+A shortcut, right-click on the column letters, select Column Width, change its value, and then click OK. Next, while all cells are still selected, right-click on the row numbers, select Row Height, change its value accordingly, and click OK. Now, you have a grid working area that is ready for layout.

  • Step 2: Make a Scaling and a Wall

    how-to-make-a-floor-plan-on-microsoft-excel-step-2This step is done depending on the intended design of your floor plan. Simply draw border lines on the cells, taking into account the scaling that will be applied. As for the example, the scale for the layout is 4 square units (cells), which is equivalent to 1 square foot.

  • Step 3: Begin Dividing the Floor Area

    how-to-make-a-floor-plan-on-microsoft-excel-step-3In this step, you can start partitioning the areas of your floor plan, including the bedroom, living room, comfort room, and kitchen. You can use the Shape toolbar to create figures on the layout. Furthermore, you can also refer to the average size of rooms or spaces used in making floor plans.

  • Step 4: Refine the Layout

    how-to-make-a-floor-plan-on-microsoft-excel-step-4Refine the layout of the floor plan by removing the lines connecting the walls that make them look like one. To do this, select the cells with the unnecessary lines, then right-click. Next, choose the Format Cells option, select the Borders option, remove the unnecessary lines, and click OK.

  • Step 5: Finalize the Floor Plan

    how-to-make-a-floor-plan-on-microsoft-excel-step-5

    To finalize your floor plan, you can add decorations or draw some furniture. You can also color them to make them more lively and realistic.

FAQs

What file type should I save my floor plan in Microsoft Excel?

You can save your floor plan as a DWG file by going to the File tab, selecting Save As, changing the “Save as type” to AutoCAD Drawing (.dwg), clicking OK to confirm, and then saving it.

What does a DWG file mean?

A DWG file is the preferred file format for floor plans that CAD software can read, it provides additional metadata, such as room numbers, that other applications, such as Microsoft Search, can utilize to create seating charts.

Why should I design floor plans with Microsoft Excel?

You can use Microsoft Excel as a suitable replacement for any commercial software for creating floor plans, interior designs, or landscaping layouts as it is convenient and simple to use and it also provides easy-to-use tools such as shapes for creating the floor plan you want.