Floor plan with excel

How to Make a Floor Plan in Excel

Edraw Content Team

Do You Want to Make Your Floor Plan?

EdrawMax specializes in diagramming and visualizing. Learn from this article to know everything about how to make your floor plan in Excel and easier way. Just try it free now!

A floor plan is among the first drawings an architect shows to their client before starting the construction project. A floor plan consists of the dimensions, the entire property’s scale, bedroom outlines, and the positioning of all the furniture. Students these days try to make a floor plan in Excel because of its offline availability. However, Excel does not have enough design tools that let you create a professional-looking floor plan.

In this guide to making a floor plan in Excel, we will introduce the floor plan symbols and templates offered by EdrawMax. Here you will learn how easy and affordable it is to create a floor plan in Excel format using the amazing features that come with EdrawMax.

1. How to Create a Floor Plan in Excel

Microsoft Excel comes with Microsoft Suite. So, the first step you need to do here is to download the entire MS suite and pay the license fees starting at $69.99 annually. Once you have acquired the license, you can create a floor plan in Excel.

Launch the application and open a blank worksheet:

Considering how to make a floor plan in Excel, here are the steps. First, launch the application. Click the application shortcut icon on your desktop or taskbar, or you can go to the Start Menu and click the option for Excel to open it. Once the window is open, go to the Home tab and click on the Blank workbook option to open a blank sheet.

Create a grid sheet:

The Excel sheet is already in the format of rows and columns; all you need to do is adjust the cell size to get the desired grid format. Select all the rows and columns by clicking on a small button in the top left corner between the rows and columns. Now, clicking on a cell and resizing it by dragging it will force the other cells to adjust according to it, and the result is a grid sheet that is perfect for drawing a floor plan.

Define the outline:

Before jumping to the next step, define the area where you want to create your drawing. Select the rows and columns required and go to the Borders option in the Font group of the ‘Home’ tab. The Outside borders tool will let you draw the area border to draw the floor plan.

Draw the plan using resizing technique:

To draw a detailed plan, go to the Borders option in the Font group and click the arrow for the drop-down menu. Use the options in the drop-down menu, like Bottom Border, Left Border, Right Border, and others, to draw the entire floor plan.

Now that you know how to make a floor plan in Excel, the final step is to save the drawing. Go to the File tab, click on Save As option and input the filename and targeted location. Click the Save button, and your floor plan is ready to use.

As you saw here, creating a floor plan in Excel requires much technical expertise and lets you depend on other third-party add-ons. Instead of going this way, let us show you the easiest way that helps in creating a professional-looking floor plan.

2. How to Create a Floor Plan in EdrawMax

Now that you have seen the complicated steps, let us show you the easiest way of creating a floor plan in EdrawMax.

Step1 Open EdrawMax & Login

The first step in creating a floor plan is downloading and installing this 2D floor plan maker in your system. Head to https://www.edrawsoft.com/edraw-max/ to download the EdrawMax installer file, depending on your system. We offer an online version of this floor plan software as well. Register to the EdrawMax dashboard if you are using it for the first time; otherwise, log in using your registered email address.

Step2 Template Selection

EdrawMax comes with over 3,000 free templates for different drawings. Go to the ‘Template’ section on the left side of this floor plan software and look for ‘Floor Plan’. Here, you will find hundreds of user-generated templates. Check out the templates and click on ‘Use Immediately’ to import all the floor plan components to your drawing. You can even duplicate multiple floor plan templates to take out their respective elements to create your own unique design.

Step3 Create From Scratch

If you wish to explore EdrawMax features, head to the Building Plan section and click on the ‘+’ sign. In the EdrawMax canvas board, you will find user-friendly drag-and-drop features that help create floor plan diagrams. Start with the basic outline of the floor plan, followed by the interior and exterior elements.

Step4 Select Symbols

On the toolbar, you will see ‘Predefined Symbols’. Click on ‘Floor Plan’ to import all the relevant symbols of the floor plan design. Once they are imported, you can start placing them in the floor plan outline you have just created in Step #3.

Step5 Add Components

After creating the outline and adding bedroom walls and windows, you can start adding the basic components of the floor plan, like Window, Open Window, Glider Window, Double Door, Revolving Door, Sofa, L-Shaped Sofa, Round Sofa, Curved Sofa, Sectional Sofa With Arms, One Seat Sofa, Two Seat Sofa, Three Seat Sofa.

Step6 Export & Share

After creating the floor plan, you can export it into Excel formats and other important formats, like JPG, PNG, PDF, Word, PPTX, and more. This 2D floor plan also lets you share your floor plan design on different social media platforms, like Twitter, Facebook, LinkedIn, and Line.

Basically, it is simple to draw an floor plan in EdrawMax, just grab a template and keep customizing, drag and drop professinal symbols to make your plan better. If you are still confusing about how to create a floor plan in EdrawMax, just check this floor plan drawing guide, or check the video below.

3. EdrawMax vs. Excel

Some of the most common differences between EdrawMax and Excel are:

• Excel is designed to handle complex finance and accounting problems. It lacks several design features. EdrawMax lets you create over 280 different types of diagrams, including tables, to note down your financial details.
• All the files exported from Excel are not fully encrypted. These files can easily be opened by any third-party offline or online tools. All the files exported from EdrawMax are highly encrypted. Even the files you will store in your personalized cloud space are protected by the highest level of SSL certification.
• Excel is an offline tool and does not provide any support for real-time remote collaboration. You will need to access Google Meet or Zoom if you need to access your system’s file for your team members. EdrawMax has an online version that instantly brings your remote team to one page, from where you can easily create floor plans and other building plans.

EdrawMax is the best resources for creating a floor plan, you can find hundreds of floor plan symbols and templates here. Just drag and drop, you can create floor plan easily.

Источник

How to use Excel to design simple Floor Plans

Excel in Office 365 is a very versatile app. The built-in features of Excel make it able to be the building block for so many projects. While we cannot predict or avoid all disasters, our response to them can make a big difference. Our response to disasters is strongly tied to our planning and preparedness. One important tool in disaster preparedness is a Floor Plan showing evacuation routes and emergency numbers. Microsoft Office 365 Excel can help you to get your family or even workplace prepared for any eventualities. Microsoft Office 365 Excel has some features that will enable anyone with even basic skills to craft a Floor Plan showing evacuation routes.

Microsoft Office 365 Excel may also be used to do floor plans for organizing rooms, seating arrangements, and a lot more. With the built-in calculation feature, you will be able to show the Floor Plan and do calculations if the plan is for seating arrangements.

How to create a Floor Plan using Excel

Making the Floor Plan with Office 365 Excel requires to follow these steps:

1. Memorize or get the plan for the area
2. Do a rough draft on paper
3. Get a mouse instead of using the touchpad
4. Remember where all entrances stairs are
5. Move from paper to Microsoft Office 365 Excel.

Let us show you how you can create a Floor Plan using Excel.

There may be a point when you want to do a Floor Plan, Seating layout, or organize a room. You may be on a budget so you cannot get the software to do the job. You may have the skills to do the layout, so you do not need to hire a professional. Well, you already have the perfect tools, Microsoft Office 365 Excel, your creativity and skills, and time.

1] Memorize or get the plan for the area

Do a walkthrough of the space a few times to get a mental picture of the layout. You can walk with a pencil and paper so you can sketch the space that you want the plan for. Make notes of important areas that you need to remember. If it is Floor Plan for the emergency route you may want to make notes of stairs, lifts, fire extinguishers, etc. after sketching, try to follow the plan on paper and see if it matches the space. This is the same for Floor Plans for the emergency route, seating layout, or space to design/decorate.

2] Do a rough draft on paper

Doing a rough draft on paper is important as this will help you to remember. When you go to design in Excel, you may think you will remember, but you may miss important details. The rough draft will also give you an idea if you are on the right track when you compare to Excel.

3] Get a mouse instead of using the touchpad

If you are using a laptop, it is best to use a wired or wireless mouse instead of the touchpad. An external mouse will offer more comfort and accuracy. You can get an affordable and simple mouse or go for a fancy one. Whichever you choose, the external mouse will make designing in Excel more comfortable and accurate.

5] Move from paper to Microsoft Office 365 Excel

Now to get to the fun part of putting the design into Microsoft Office 365 Excel. Excel is made up of grids. These grids help to make it more accurate when trying to get things lined up perfectly. These grids can be hard to get around when you need to create curves in a design, but a little creativity, imagination, and some Excel features will help.

If your design has features on all sides then it is best to fit it in the middle of the Excel sheet. Be sure to get the beginning correct or it will affect the rest of the design. Corrections can be very time-consuming. Choose the area and start with the general shape of the structure or space you want to design. Microsoft Excel Borders Option Dropdown Menu

You will use thick borders to show walls or major borders. Thinner borders can be used to show inner walls and partitions, and dotted lines to show doorways. Other features can be represented by your choice of items. Be sure to include a key so that persons will understand.

Shapes are extremely helpful when there is a need for features that cannot be made with the grids. Shapes such as lines, arcs, squares, etc. Shapes can be used to represent objects such as tables, also used to represent curved areas of the plan and accessways. Floor Plan designed with Microsoft Office Excel

The finished floor plan with all the parts in place using the different features in Microsoft Excel. The grid lines will still show while in Microsoft Excel. The grid lines will not be printed by default, they will have to be set. In the print segment, you will be shown how to print the gridlines. Floor Plan designed with Microsoft Office Excel with no gridlines

A finished Floor Plan, seating plan, or any plan should be clear and to the point. Anyone reading the Floor Plan should be able to see what is to be done. Microsoft Office 365 Excel makes the Floor Plan clear and easy to read.

Printing your Floor Plan in Excel

The first step that should be done before printing is to see how many sheets the Floor Plan is on. Create a print area to eliminate wasting paper. The print area would be the section with the Floor Plan and the information.

To set the Print Area select the areas that you want to be included, go to Page Layout, click Print Area, then click Set Print Area. If you decide to change or delete the print area just go to Page Layout, click Print Area, then click Clear Print Area Microsoft Office Excel Print Gridlines option

The paper size can be changed to facilitate a larger plan on a single sheet. Margins could also be modified to get the Floor Plan to fit on a single sheet. You can choose to keep the gridlines in the final print or make the print be plain with only the lines of the Floor Plan. To print, the gridlines, go to Page Layout then go to Gridline and select Print.

Microsoft Office 365 Excel, like other Microsoft Office apps, is very versatile. They can do so much more than meets the eye. It is extremely easy to navigate Excel to create Floor Plans and any other plans. Microsoft Office 365 Excel is an app to consider for easy and cost-effective Plan designs. It requires little or no technical skills and anyone with a knowledge of Microsoft Office 365 and Excel can use it to make a Floor Plan.

Источник