How to Make a Floorplan in Excel : Microsoft Excel Tips

Поділитися
Вставка
  • Опубліковано 6 жов 2024

КОМЕНТАРІ • 401

  • @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.

  • @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.

  • @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.

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

  • @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.

  • @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.

  • @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.

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

  • @freeholdcottage5508
    @freeholdcottage5508 9 років тому +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!

  • @kalingahhh80
    @kalingahhh80 8 років тому +5

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

  • @fernandosanjose8691
    @fernandosanjose8691 9 років тому

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

  • @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.

  • @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.

  • @khanghua6276
    @khanghua6276 24 дні тому

    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"

  • @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.

  • @mail06513
    @mail06513 6 років тому +3

    Didn't even think of using the border option in excel for drawing floor plans. Very cool.

  • @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

  • @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.

  • @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

  • @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.

  • @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

  • @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.

  • @alandsouza2421
    @alandsouza2421 Рік тому +1

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

  • @cherylglackin923
    @cherylglackin923 6 років тому +21

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

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

  • @mahala77
    @mahala77 5 років тому +1

    thank you Ted, you are a great teacher

  • @amount2nothin244
    @amount2nothin244 4 роки тому +1

    Thanks for posting this. Perfect for what I needed

  • @tinyyogis6260
    @tinyyogis6260 4 роки тому

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

  • @weevictor4906
    @weevictor4906 7 років тому

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

  • @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.

  • @muoshoo1
    @muoshoo1 10 років тому +1

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

  • @rahulsantosh_Insp
    @rahulsantosh_Insp 4 роки тому

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

  • @westfour3116
    @westfour3116 5 років тому +1

    This is just what I was looking for

  • @christinatorres4910
    @christinatorres4910 11 років тому +1

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

  • @rogerr6534
    @rogerr6534 5 років тому +150

    1.00 inch is 96 pixels yall

  • @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.

  • @greenblood5640
    @greenblood5640 4 роки тому

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

  • @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.

  • @jeaninebenenati6967
    @jeaninebenenati6967 8 років тому +1

    Thanks Ted! You are a big help!

  • @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.

  • @lanacahe
    @lanacahe Рік тому

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

  • @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.

  • @aWiseThinkingMan
    @aWiseThinkingMan Рік тому

    Thank you, simple but very usefull and accurate

  • @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

  • @xhoxhajfeta5166
    @xhoxhajfeta5166 4 роки тому

    Thanks Ted, Simple and useful explanation.

  • @StaxxxInMyJeans
    @StaxxxInMyJeans 8 років тому

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

  • @luvtheno
    @luvtheno 11 років тому +7

    Thank you Ted! You've been very helpful!

    • @tedrussell3679
      @tedrussell3679 3 роки тому

      Thank you, Janice! I really enjoyed doing these video, which my son produced.

  • @alittax
    @alittax Рік тому

    Excellent explanation and presentation!

  • @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.

  • @alexanderboaza8900
    @alexanderboaza8900 4 роки тому

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

  • @nancyermert9683
    @nancyermert9683 5 років тому

    Thank you! this was easier than I expected, your instructions were easy to follow , I'm not computer savy, but I actually did it! you made my day! Thanks!!

  • @allisongarcia8799
    @allisongarcia8799 2 місяці тому

    Thank you so much Ted.

  • @dirkdigler8992
    @dirkdigler8992 4 роки тому

    Found this very helpful for the new build

  • @ALVIN722
    @ALVIN722 Рік тому

    luar biasa sangat membantu salam dari Indonesia,..

  • @lifetalkz4548
    @lifetalkz4548 8 років тому

    Good information Ted for a quick floor plan. Thanks.

  • @NelsonRoodfromFlorida
    @NelsonRoodfromFlorida 5 років тому +1

    Thank you Ted. I needed that!!

  • @a123464
    @a123464 3 роки тому

    Thank you Ted.

  • @christiaanopperman3247
    @christiaanopperman3247 Рік тому

    Extremely helpful, thanks

  • @jimmiddleton5093
    @jimmiddleton5093 6 років тому

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

  • @hillaryirungu5055
    @hillaryirungu5055 4 роки тому

    thank you. it works magic.

  • @johnquinn2982
    @johnquinn2982 3 роки тому

    Thank you Ted, Very helpful.

  • @MrRypoc
    @MrRypoc 2 роки тому

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

  • @nnhutube
    @nnhutube 10 років тому

    Good Technique. Very Useful. Thanks.

  • @NilSonkamble
    @NilSonkamble Рік тому

    Good job sir, very simple

  • @duythinhnguyen6705
    @duythinhnguyen6705 Рік тому

    Worked , thanks a lot!

  • @howardtran5904
    @howardtran5904 4 роки тому

    Thank you very much for this useful information.

  • @clfung2008
    @clfung2008 4 роки тому

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

  • @kahtamt9538
    @kahtamt9538 3 роки тому

    Thankyou. It helps.

  • @AftenSummers-bh5eg
    @AftenSummers-bh5eg 9 років тому

    Fantastic and soooo easy! Thanks, Ted!

  • @mdupotey
    @mdupotey 3 роки тому

    Great, Thanks Ted !

  • @DeltaMuse
    @DeltaMuse 11 років тому

    Thanks You helped so much! Had to do this for an assignment!

  • @OneJennifer247
    @OneJennifer247 3 місяці тому

    Thank you for this

  • @ReneeVanDohren
    @ReneeVanDohren 9 років тому +3

    Thank you so much! You've helped me greatly with an assignment!!

  • @sahntlewilliams5800
    @sahntlewilliams5800 4 роки тому

    this was so helpful thank you ted

  • @foxwyrick1
    @foxwyrick1 3 роки тому

    Very helpful, thank you!

  • @playlist3319
    @playlist3319 8 років тому

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

  • @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.

  • @JDK45ACP
    @JDK45ACP 3 роки тому

    Useful, indeed. Thanks.

  • @pluzsizebeauty09
    @pluzsizebeauty09 6 років тому

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

  • @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 ?

  • @MrSkribanto
    @MrSkribanto 9 років тому

    I've learned something new today.

  • @franciscobravo2831
    @franciscobravo2831 4 роки тому

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

  • @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?

  • @davidkei2114
    @davidkei2114 4 роки тому

    Thank you for your guide!

  • @jaydenleeroyndlovu1167
    @jaydenleeroyndlovu1167 4 роки тому

    Thank you ted

  • @possingham1
    @possingham1 8 років тому

    Thanks Ted, most useful.

  • @mohdgous1
    @mohdgous1 4 роки тому

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

  • @lindam2642
    @lindam2642 8 років тому

    Thanks Ted this was a tremendous help!

  • @waynemurray2966
    @waynemurray2966 10 років тому

    Cheers Ted - very helpfull and easy to use!!

  • @Zenconstructions
    @Zenconstructions 4 роки тому

    Wow.. fantastic!!

  • @SJCordery
    @SJCordery 10 років тому

    Excellent! Like most brilliant ideas, it is simple but effective.

  • @Koumondji
    @Koumondji 7 років тому

    Thanks, Ted. I appreciate the information. Very helpful to me...

  • @josephwalker138
    @josephwalker138 4 роки тому

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

  • @jamesimanwel5089
    @jamesimanwel5089 8 років тому

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

  • @Two_Buck
    @Two_Buck 4 роки тому

    Very cool, thanks.

  • @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.

  • @sheliaferrentino9392
    @sheliaferrentino9392 5 років тому

    Thank you Ted. It was very helpful.

  • @mazharaltaf4899
    @mazharaltaf4899 4 роки тому

    Very informative

  • @fallfestcoordinatorsusantr5654
    @fallfestcoordinatorsusantr5654 9 років тому +1

    Thank you. I just figured out how to create a map for a school street fair!!!!

    • @tedrussell3679
      @tedrussell3679 3 роки тому

      That is really nice to hear. This is Ted in the video.

  • @begood5294
    @begood5294 10 років тому

    thanks for your time sharing your knowledge..I.appreciate it much...very helful