How to Make a Floorplan in Excel : Microsoft Excel Tips

Subscribe Now:

Watch More:

Making a floorplan in Microsoft Excel is a lot easier than you probably think it's going to be. Find out how to make a floorplan in Excel with help from a mechanical engineer with 32 years of experience in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is a powerful database and spreadsheet tool that is an important part of the Microsoft Office productivity suite of software. Get tips on how to best use Microsoft Excel to its full potential with help from a mechanical engineer with 32 years of experience in this free video series.

[cherylglackin]

To beef up your design, you can add diagonal lines, doors, furniture, etc. by inserting shapes.

[ThaSaltyDawg]

Very Interesting. I never thought about using Excel for creating floor plans. After watching your video, I created some VBA modules to autocreate and made it easier. I'm still working on the modules to get it just right, If it works as i expect I might come back and post a link to it if anyone is interested.

[maliadavidson]

Thank you! I was looking for a simple and clean way of my creating a floor plan. This is way better than my drawing lines and measuring on paper.

[theartist]

Wow this is really how to waste a ton of time, don't use Excel for trying to blueprint omg haha!
In a different App I could have done that in 60 seconds.

[kawsakiTV]

Would this be considered a “Ted Talk”? ;-)

[bergsonlouis-jacques]

It would really be helpful if the author of this video would tell us what version of Excel he is using (first and foremost) because I am seeing pixels, not inches! Also what operating system he is using... thankfully +carolek09 has given very helpful info!! Thank you +carolek09!!

[jeniferamajuoyi]

this is super helpful and who is watching this in 2019?

[jdhspeedify]

Thanks...forgot all about Excel for simple drafting. Like Dive Like Junk mentioned, there are options for diagonal lines as well; you can also rotate the text how you like and choose where on the square to place it. Another way to open that option window without having to scroll all the way back and forth, is to right click on the highlighted area in windows or open the drop menu in Mac, it will be in the list. That same list also has where you can set the rows height and column width by just entering the number value if you don't want to drag it. Very helpful video thanks again.

[kalingahhh]

Thank you very much Ted. Very simple but useful instructions.

[divelikejunk]

Hey, this is a very helpful tutorial, but you were wrong about the diagonal lines. Excel can make diagonal lines.
In the Border options you can see them as clickables on the bottom left and bottom right corner of the options.

[jackthelad]

It's ok if your house measurements don't have any inches.

[kdubs]

I was looking for a simple way to make office floorplans for all of our clients, and this was simple and easy! Thanks!

[khanghua]

this video was 11 years ago, and today thanks to it, i know that i can modify the borders by clicking to the "preview diagram"

[scottjones]

I'm running Excel 2010 and having trouble changing the cell format from pixels to inches. I went into home/options/advanced/display and changed the units to inches but I'm still seeing pixels on the spreadsheet. If I go into view/page layout, I can change each column or each row to 1 inch cells but can't do it for the entire spreadsheet. Can anyone help?

[Moody]

So, who needs AutoCAD when there is Excel? xD

[iancrawford]

I will say I did not watch the video. But just the title alone looks incredibly stupid. Use AutoCAD, Inventor, or 3ds Max even. Not Excel.

[ALVIN]

luar biasa sangat membantu salam dari Indonesia, ..

[cyrellecunananc.]

Wtf, whats wrong with youtube these days, to many spam commments. It's getting really annoying. Don not believe the fake spam comments, just Gamecrook works.

[Iron-Bridge]

Thanks! Very useful video as I need to come up with a simple floor plan to assist with an Indoor Air Quality investigation for a building.

[gwendolynjeffersonskinner]

Ted, when I drag a column, I get pixels not inches. How do you get inches as you widen or narrow the Excel column?