I Want To Learn Drawing Floor Plans In Excel.

Asked By Jamal Keaton 0 points N/A Posted on - 08/17/2016

I am working on making a floor plan for my small scale cafe. I do not want to invest in any advanced software. I am going to work on Excel. I want to learn drawing floor plans in Excel, can anyone tell me about the basics.

• Status: Open
• Question Views: 600
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By ysam adam 0 points N/A #99665

I Want To Learn Drawing Floor Plans In Excel.

First thing that according to me should be done in order to make a floor plan is measure the actual maximum floor length.

You can do it using a simple measuring tape. Note down the maximum length and breadth.

Scale this down in such a way that it fits on your viewable part of your Excel page. Convert all measurements to this.

A good practice is to use units of 1. For example, 1cm=1m. If your area is bigger, then you may use 1cm=2m or 3m, and so on. Then, create a rectangle of the scaled down versions of the total measurements. To do this, just select an appropriate number of cells in Excel. For example, if your area is 28*15 cm (scaled down), select 28*15 cells.

Now you have your maximum area selected. You can change the colour of the cells to make them easier to make out.

Now, plan your shop within this area, using different colour for different things.

About ysam adam

Questions
2

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/17/2016
• Question Category: MS Excel