How to Make a Floorplan in Excel : Microsoft Excel Tips

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ต.ค. 2024

ความคิดเห็น • 401

  • @charleneduke7855
    @charleneduke7855 5 ปีที่แล้ว

    I am currently enrolled in an online Facility Planning course that requires me to design a healthcare clinic floor plan. I was convinced I was going to fail this class because I had no clue where to begin. I logged onto you tube and searched how to create a facility design using excel and this video emerged. This video gave me the necessary knowledge to execute my assignment and pass the class. Thank you for your post.

  • @maliadavidson7305
    @maliadavidson7305 5 ปีที่แล้ว +15

    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.

  • @justiceisstupid
    @justiceisstupid 8 ปีที่แล้ว

    I love the internet. You're never too old to learn something new. Of course he was using an older version of excel and that's what I hate about Windows every time they do an upgrade you have to learn where everything is all over again. Thanks Ted for the lesson.

  • @kdubs1976
    @kdubs1976 8 ปีที่แล้ว +5

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

  • @ThaSaltyDawg
    @ThaSaltyDawg 9 ปีที่แล้ว +42

    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.

    • @fotkamamatv3041
      @fotkamamatv3041 5 ปีที่แล้ว

      Please upload ur f plan with VBA....

    • @sasafie
      @sasafie 5 ปีที่แล้ว +1

      Yeah... Its already 3 years..

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว +1

      Hi Jimmy. That is really good to hear. It's now 2021. This is Ted in the video.

  • @matthewsaint6095
    @matthewsaint6095 6 ปีที่แล้ว

    I had to a floor plan for a retail business, for my Marketing classand I did not know how to do it. So I googled how to create a floor, and this video popped up. I know now how to do it. Thanks!

  • @cherylglackin923
    @cherylglackin923 6 ปีที่แล้ว +21

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

  • @fernandosanjose8691
    @fernandosanjose8691 9 ปีที่แล้ว

    My father is very busy to do my floor plan assignment. Thanks Ted now I can do it on my own!

  • @jdhspeedify
    @jdhspeedify 6 ปีที่แล้ว +16

    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.

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Thanks so much for the kind words and for the tip! This is Ted in the video, and I'm always learning.

  • @rogerr6534
    @rogerr6534 5 ปีที่แล้ว +152

    1.00 inch is 96 pixels yall

    • @SixDegreesOfGeek
      @SixDegreesOfGeek 4 ปีที่แล้ว +3

      Huge thanks for this info.

    • @therealestateslayer
      @therealestateslayer 4 ปีที่แล้ว +1

      Thank you too.

    • @yukadiangelo
      @yukadiangelo 4 ปีที่แล้ว +2

      THANKS

    • @Skxll007
      @Skxll007 4 ปีที่แล้ว

      thnx very helpfull :)

    • @Homer482976
      @Homer482976 4 ปีที่แล้ว +3

      And 38 pixels is a centimeter for the other 95% of the planet ;-)

  • @therealestateslayer
    @therealestateslayer 4 ปีที่แล้ว +1

    Thank you Ted. I need to make an outline of a hotel suite my charity group is using for a green room. The room has all kinds of nooks and crannies, this is soooo helpful.

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว +1

      Oh wow - that is so nice to hear! This is Ted in the video.

  • @judiadams1788
    @judiadams1788 7 ปีที่แล้ว +3

    Thank you Ted. You just saved me $100's of dollars I was dreading having to spend on an office floor plan app. All I need is something simple such as this to start. Thank you for sharing.

  • @kalingahhh80
    @kalingahhh80 8 ปีที่แล้ว +5

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

  • @HansEisenman
    @HansEisenman 6 ปีที่แล้ว +2

    A simple and useful "hack" for doing a quick floor plan. This helped me. I just needed to do some rough comparisons between two offices and whether furniture in one would work well if moved to the other. To do that requires a to-scale method of drawing out the spaces. This worked wonderfully. Thanks for putting it together.

  • @missy13april
    @missy13april 5 ปีที่แล้ว

    Thank you. Just managed to put my ideas together using excel before my architect comes to have a look around. Thanks again

  • @freeholdcottage5508
    @freeholdcottage5508 10 ปีที่แล้ว +1

    Thank you so much. I need to show a floor plan for fire personnel (if necessary) for a residential home and this has just showed me how! Thank you again!

  • @divelikejunk8557
    @divelikejunk8557 9 ปีที่แล้ว +8

    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.

  • @khanghua6276
    @khanghua6276 หลายเดือนก่อน

    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"

  • @tinyyogis6260
    @tinyyogis6260 4 ปีที่แล้ว

    This was very help in spite of my accidental poor rating. Seems only the poor rating would register. Thanks Ted.

  • @mahala77
    @mahala77 5 ปีที่แล้ว +1

    thank you Ted, you are a great teacher

  • @alandsouza2421
    @alandsouza2421 ปีที่แล้ว +1

    You nailed it man. Wish excel would allow some diagonal lines as you mentioned. Curved lines would also help :)

  • @katrinajames6499
    @katrinajames6499 4 ปีที่แล้ว +1

    Hi Ted, this has been so useful for me !! I come back to your quick instructions each time, thankyou!

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว +1

      Oh wow - thanks so much, Katrina. My son produced a ton of these videos a few years ago, and I did all the Excel ones, but we're both busy with other things now. It's so nice to hear someone has watched more than one of them.

  • @lanacahe
    @lanacahe ปีที่แล้ว

    Wow this is so simple and easy to use!! Thank you

  • @westfour3116
    @westfour3116 5 ปีที่แล้ว +1

    This is just what I was looking for

  • @aWiseThinkingMan
    @aWiseThinkingMan ปีที่แล้ว

    Thank you, simple but very usefull and accurate

  • @alittax
    @alittax ปีที่แล้ว

    Excellent explanation and presentation!

  • @jeniferamajuoyi2334
    @jeniferamajuoyi2334 5 ปีที่แล้ว +42

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

    • @azazkadiwala
      @azazkadiwala 5 ปีที่แล้ว

      Jenifer
      I am

    • @fodank
      @fodank 4 ปีที่แล้ว

      I am. Excel is easy to work in an this is a useful, simple tool that avoids all the BS of other online drafting programs. Thanks Ted. Cheers, D.

    • @VitorEmanuelOliver
      @VitorEmanuelOliver 4 ปีที่แล้ว +1

      2020, you’re living in the past D:

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      @@VitorEmanuelOliver This is Ted in the video, and it's now 2021. I'm just checking these comments for the first time. So nice to hear people are still watching it.

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Hi Jenifer. This is Ted in the video, and it's now 2021, and I"m just checking all the comments for the first time.

  • @xhoxhajfeta5166
    @xhoxhajfeta5166 4 ปีที่แล้ว

    Thanks Ted, Simple and useful explanation.

  • @yesiownfrodo
    @yesiownfrodo 6 ปีที่แล้ว +1

    An excellent tutorial. You're a natural teacher.

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Aww, that is SO nice to hear. I really enjoy teaching.

  • @amount2nothin244
    @amount2nothin244 4 ปีที่แล้ว +1

    Thanks for posting this. Perfect for what I needed

  • @TedChastain
    @TedChastain 7 ปีที่แล้ว +1

    Hi Ted. Ted here. This video was exactly what I needed. Thank you so much!

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Hey, Teds are the best. :-) So glad I could help another Ted!

  • @weevictor4906
    @weevictor4906 7 ปีที่แล้ว

    Thank you so much Ted. I is very useful. simple and to the point without all the confusing computer jargon.

  • @rahulsantosh_Insp
    @rahulsantosh_Insp 4 ปีที่แล้ว

    THAN Q SIR .............SOME VIDIOES JUSGT SAVE YOUR TIME SOO MUCH!!!!

  • @christinatorres4910
    @christinatorres4910 11 ปีที่แล้ว +1

    Very grateful for this video helped so much with my project! Much thanks Mr.Ted (:

  • @christiaanopperman3247
    @christiaanopperman3247 ปีที่แล้ว

    Extremely helpful, thanks

  • @lesterdavidoff9869
    @lesterdavidoff9869 4 หลายเดือนก่อน

    Very nice presentation
    I have entered furniture sizes into excel. Can i make them into shapes. Then can i move them into the floor plan ?

  • @johnquinn2982
    @johnquinn2982 3 ปีที่แล้ว

    Thank you Ted, Very helpful.

  • @jeaninebenenati6967
    @jeaninebenenati6967 8 ปีที่แล้ว +1

    Thanks Ted! You are a big help!

  • @AftenSummers-bh5eg
    @AftenSummers-bh5eg 9 ปีที่แล้ว

    Fantastic and soooo easy! Thanks, Ted!

  • @ALVIN722
    @ALVIN722 ปีที่แล้ว

    luar biasa sangat membantu salam dari Indonesia,..

  • @marksmith8290
    @marksmith8290 6 ปีที่แล้ว +1

    Ted - Great video and instructions - thanks for taking the time to do this

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Thanks, Mark. This is Ted in the video. My son produced a ton of these back in 2012, and I did all the Excel ones. I really enjoyed doing them.

  • @95countach
    @95countach 4 ปีที่แล้ว

    Clever use of Excel! I am PowerPoint expert, but not experienced with Excel. Is there a way to draw angled lines and curved walls?

  • @bonganibrianmpanza106
    @bonganibrianmpanza106 6 ปีที่แล้ว +1

    Wow it is interesting, thank you for this video. and im one of the young people who are interested in creating floor plans by watching this video im very surprised that you made things more easier to create floor plans by using the famous software it was unexpected to me.Thank you so much

  • @maleekmullings3501
    @maleekmullings3501 6 ปีที่แล้ว +1

    Thank you for making this man, really helpful looking to build a lil building to start up a business, this video has giving me a better understanding how to use excel for a floor plan

  • @dirkdigler8992
    @dirkdigler8992 4 ปีที่แล้ว

    Found this very helpful for the new build

  • @NilSonkamble
    @NilSonkamble ปีที่แล้ว

    Good job sir, very simple

  • @allisongarcia8799
    @allisongarcia8799 3 หลายเดือนก่อน

    Thank you so much Ted.

  • @jomarmartinez4351
    @jomarmartinez4351 4 ปีที่แล้ว

    This is so helpful. Thank you very much, sir!

  • @Iron-Bridge
    @Iron-Bridge 9 ปีที่แล้ว +2

    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.

  • @alexanderboaza8900
    @alexanderboaza8900 4 ปีที่แล้ว

    Thank you so so much. Now I have somewhere to start!

  • @foxwyrick1
    @foxwyrick1 3 ปีที่แล้ว

    Very helpful, thank you!

  • @mohdgous1
    @mohdgous1 5 ปีที่แล้ว

    It is very useful for basic planning ,nice idea ,nice video
    & Iot of thanks,

  • @howardtran5904
    @howardtran5904 4 ปีที่แล้ว

    Thank you very much for this useful information.

  • @lifetalkz4548
    @lifetalkz4548 8 ปีที่แล้ว

    Good information Ted for a quick floor plan. Thanks.

  • @duythinhnguyen6705
    @duythinhnguyen6705 2 ปีที่แล้ว

    Worked , thanks a lot!

  • @flakenify
    @flakenify 10 ปีที่แล้ว +1

    Your brilliance is in the simplicity. Thank you.

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Thanks so much, Jane. That is SO true. I'm Ted in the video.

  • @hillaryirungu5055
    @hillaryirungu5055 4 ปีที่แล้ว

    thank you. it works magic.

  • @NelsonRoodfromFlorida
    @NelsonRoodfromFlorida 6 ปีที่แล้ว +1

    Thank you Ted. I needed that!!

  • @franciscobravo2831
    @franciscobravo2831 4 ปีที่แล้ว

    Thank for your help. Good video
    You should make a video about how to do a complete house on excel .

  • @playlist3319
    @playlist3319 8 ปีที่แล้ว

    awesome...i learned from this video
    two thumbs up

  • @faizahsallehfs
    @faizahsallehfs 11 ปีที่แล้ว +4

    THANK YOUUUU! As a student I found this very helpful! :)

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Hi Faizah. Glad it was a help! This is Ted in the video.

  • @nnhutube
    @nnhutube 10 ปีที่แล้ว

    Good Technique. Very Useful. Thanks.

  • @sahntlewilliams5800
    @sahntlewilliams5800 4 ปีที่แล้ว

    this was so helpful thank you ted

  • @JDK45ACP
    @JDK45ACP 3 ปีที่แล้ว

    Useful, indeed. Thanks.

  • @dmfd305
    @dmfd305 5 ปีที่แล้ว +1

    I use the same process to map cemeteries. However, where Ted made 72 squares for a cell, which I think represents a foot, I reduce mine. I make a cell 15 square for a cell. That equals 6 inches for me. If I were to draw something as small as a house, I would probably make a cell 10 points square and have that represent a half inch. I could be much more precise with my drawing. Don’t forget you can use notes and hyperlinks as well, to show additional information. I don’t know what version of excel he is using, but you can now make 45 degree borders now. The biggest thing to remember here is, you are creating graph paper, be creative with this for anything you would use graph paper for.

  • @mdupotey
    @mdupotey 3 ปีที่แล้ว

    Great, Thanks Ted !

  • @Scott.Farkus
    @Scott.Farkus 4 ปีที่แล้ว

    As someone who majored in Drafting & Design I can't help but say "There really are better options" including the good ole pencil, straight edge, and paper.

    • @Seiferboi
      @Seiferboi 4 ปีที่แล้ว

      I often use graph paper myself.

  • @shaileshpankhania
    @shaileshpankhania 7 ปีที่แล้ว +1

    Simply Thank you Ted from Malawi

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Hi Shailesh! I'm so glad someone so far away found this to be helpful. I wish you the best. - Ted

  • @clfung2008
    @clfung2008 4 ปีที่แล้ว

    Interesting , very helpful ! Thanks for sharing and looking forward for more of your contribution ! Thanks !

  • @bergsonlouis-jacques3303
    @bergsonlouis-jacques3303 6 ปีที่แล้ว +7

    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!!

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      Hi Bergson. It's been nine years, so I don't know what version I was using, but regardless of the version, you can always change the display to show different units - pixels, inches, centimeters. This is Ted in the video.

  • @Zenconstructions
    @Zenconstructions 4 ปีที่แล้ว

    Wow.. fantastic!!

  • @kahtamt9538
    @kahtamt9538 3 ปีที่แล้ว

    Thankyou. It helps.

  • @cobamietvuonseattlewa1490
    @cobamietvuonseattlewa1490 3 ปีที่แล้ว

    I would like to make rectangular shape with a partial of a foot like 2 1/2 x 3 3/4. How do you draw that using Excel? Thanks

  • @waynemurray2966
    @waynemurray2966 11 ปีที่แล้ว

    Cheers Ted - very helpfull and easy to use!!

  • @a123464
    @a123464 3 ปีที่แล้ว

    Thank you Ted.

  • @OneJennifer247
    @OneJennifer247 4 หลายเดือนก่อน

    Thank you for this

  • @greenblood5640
    @greenblood5640 4 ปีที่แล้ว

    It's só simple and yet so helpful and not known by many people, great video

  • @davidkei2114
    @davidkei2114 5 ปีที่แล้ว

    Thank you for your guide!

  • @jamesimanwel5089
    @jamesimanwel5089 8 ปีที่แล้ว

    the video is real fantastic and it is awesome!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @possingham1
    @possingham1 8 ปีที่แล้ว

    Thanks Ted, most useful.

  • @Two_Buck
    @Two_Buck 4 ปีที่แล้ว

    Very cool, thanks.

  • @StaxxxInMyJeans
    @StaxxxInMyJeans 8 ปีที่แล้ว

    Very useful tutorial. Easy and fast design tool for simple projects, that's what I need!

  • @MrRypoc
    @MrRypoc 2 ปีที่แล้ว

    Great video, thanks! I think I did see a diagonal line option though, super useful.

  • @muoshoo1
    @muoshoo1 10 ปีที่แล้ว +1

    Yes very helpful...I am doing this for a class...and it was very easy and simple...thank-you!!

  • @bulllea
    @bulllea 4 ปีที่แล้ว

    useful ? it is very useful , thank you !

  • @josephwalker138
    @josephwalker138 5 ปีที่แล้ว

    A good option for a simple clean floor plan, and if you have nothing else...

  • @vaughniceelias7385
    @vaughniceelias7385 4 ปีที่แล้ว

    Can you make a video showing how we can make floor tile designs in Excel

  • @carolkunert211
    @carolkunert211 6 ปีที่แล้ว

    thanks Ted, nice and simples.

  • @xmask321
    @xmask321 4 ปีที่แล้ว

    This is great, thanks

  • @cowboieprince3335
    @cowboieprince3335 8 ปีที่แล้ว +1

    took Mechanical Drafting back in the 60's. Forgotten how to draw....this video was great as a starter video. Thanks for the post it really helped me to get an Idea of where to begin in my Dream Floor Plan.

  • @shaeshae3420
    @shaeshae3420 4 ปีที่แล้ว

    Dude who are you what a explanation I learned everything from here for my stupid exams

    • @tedrussell3679
      @tedrussell3679 3 ปีที่แล้ว

      This is Ted in the video. I hope your exams went well.

    • @shaeshae3420
      @shaeshae3420 3 ปีที่แล้ว

      It went well, thx for asking

  • @sparkparker
    @sparkparker 7 ปีที่แล้ว

    This was super helpful! Thank you so much for posting! Airbnb requires me to post a floorplan. The online software programs I found were way too complicated. This is perfect.

  • @mazharaltaf4899
    @mazharaltaf4899 4 ปีที่แล้ว

    Very informative

  • @mhusain7732
    @mhusain7732 9 ปีที่แล้ว

    Thanks engineer, and very useful

  • @jimmiddleton5093
    @jimmiddleton5093 6 ปีที่แล้ว

    Great video, thank you. I was hand drawing a plan for a birdhouse and this will help 👍

  • @eliosantillo4253
    @eliosantillo4253 2 ปีที่แล้ว

    Wow
    Thank you very much

  • @grupolosunicosdelrio3934
    @grupolosunicosdelrio3934 2 ปีที่แล้ว

    now i am in a good mood

  • @pluzsizebeauty09
    @pluzsizebeauty09 6 ปีที่แล้ว

    Great video. This was what I was looking for. Thank you.

  • @marvinratchford7913
    @marvinratchford7913 ปีที่แล้ว

    thanks, superb!

  • @goodtimestoshare7066
    @goodtimestoshare7066 7 ปีที่แล้ว

    Nice work Ted!