tag:blogger.com,1999:blog-8864666002840991252.post4653273443877954718..comments2024-03-24T12:07:55.646-05:00Comments on IHeart Organizing: How To: Plan a Project Using Microsoft ExcelIHeart Organizinghttp://www.blogger.com/profile/05084013302005288836noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-8864666002840991252.post-15123594464236062182016-08-08T09:55:14.386-05:002016-08-08T09:55:14.386-05:00On the menu bar at the top of the screen, select F...On the menu bar at the top of the screen, select Format -> Column -> Width and then you can type in the exact dimensions you want. For row height select Format -> Row -> Height and do the same thing. (I'm on a Mac so it may be a bit different on a PC.)Katiehttps://www.blogger.com/profile/11290412342093865175noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-11536316906577546312016-08-08T09:52:56.414-05:002016-08-08T09:52:56.414-05:00Instead of filling the whole page with white, you ...Instead of filling the whole page with white, you can also just hide the gridlines. On a Mac, go to the Page Layout tab at the top of the screen and unclick the check box next to View Gridlines. I find that to be easier than turning all the cells white, especially if you're using other colors. Katiehttps://www.blogger.com/profile/11290412342093865175noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-61852088201425370512016-07-25T12:32:32.997-05:002016-07-25T12:32:32.997-05:00This is awesome! I basically live in excel, and w...This is awesome! I basically live in excel, and would love to add one more reason to use it. I do have one technical question, that hopefully you or one of your amazing readers can answer. When I click to change the size of my row/column, it shows the dimension in pixels (14.40 / 24 pixels). How can I change the pixels to inches?Anonymoushttps://www.blogger.com/profile/00412193531202407511noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-35234437071847147122016-07-17T12:37:23.435-05:002016-07-17T12:37:23.435-05:00You should try Google Sketch up. It's easy to ...You should try Google Sketch up. It's easy to learn and you can find many tutorials online. You can easily transform a plan into a 3d. I just don't know if you can use it on a Mac....https://www.blogger.com/profile/03821501288456657372noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-54072957363820496772016-07-14T07:10:31.869-05:002016-07-14T07:10:31.869-05:00Wow. Just wow. I have been using excel since the b...Wow. Just wow. I have been using excel since the beginnng of time but never like this. Thank you SO much for sharing this!Anonymoushttps://www.blogger.com/profile/04317356758184468455noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-66929545412380260722016-07-13T12:30:33.809-05:002016-07-13T12:30:33.809-05:00Whoa! How wonderful for you to share such an indep...Whoa! How wonderful for you to share such an indepth blog showing all the details that you did. I have use excel for years and never knew it could be used for laying out space.Anonymoushttps://www.blogger.com/profile/02274144739488872268noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-227057058344367042016-07-13T07:52:08.103-05:002016-07-13T07:52:08.103-05:00I love that you are showing your readers how to ro...I love that you are showing your readers how to room drawings using a software that is common and often quite accessible to everyone! :)Anonymoushttps://www.blogger.com/profile/08792468651713853625noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-84561811051206241702016-07-12T10:02:57.689-05:002016-07-12T10:02:57.689-05:00. . . And this my friends, is the entire reason fo.... . . And this my friends, is the entire reason for me checking this blog D A I L Y. #learningsomethingneweveryday<br /><br />I appreciate this post, it's something I will print and retain just in the event this post evaporates. . . Thank you Jennifer!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-31252719211112082962016-07-11T13:40:25.299-05:002016-07-11T13:40:25.299-05:00I would love to know which software is easy to lea...I would love to know which software is easy to learn. I am all about learning something new, but haven't personally found anything that is easy and quick. Thanks for any recommendations you have.IHeart Organizinghttps://www.blogger.com/profile/05084013302005288836noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-9713990957672267272016-07-11T12:50:40.176-05:002016-07-11T12:50:40.176-05:00Its a shame, you should learn to use a drawing sof...Its a shame, you should learn to use a drawing software, it`s easy and much better than the awful drawing you can do with excellAnonymoushttps://www.blogger.com/profile/11947183067725102855noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-18471622883672231122016-07-11T12:32:51.858-05:002016-07-11T12:32:51.858-05:00THANK YOU! That will save me even more time, love...THANK YOU! That will save me even more time, love it! The painter tool is one of my favorites.IHeart Organizinghttps://www.blogger.com/profile/05084013302005288836noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-62590697432264924382016-07-11T11:44:11.284-05:002016-07-11T11:44:11.284-05:00Another fun tip, if you double click the Format Pa...Another fun tip, if you double click the Format Painter, rather than single, you can change the format on several things at a time without going back to recapture the desired format. Anonymoushttps://www.blogger.com/profile/06584798909761733895noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-34544500065315899592016-07-11T09:48:28.286-05:002016-07-11T09:48:28.286-05:00Cool! Glad it worked. I'm an accountant and sh...Cool! Glad it worked. I'm an accountant and short-cuts make my world go round! :)Caseyhttps://www.blogger.com/profile/11844752009349650621noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-42501003337415111182016-07-08T22:36:02.517-05:002016-07-08T22:36:02.517-05:00I've been an Excel user for years, and never h...I've been an Excel user for years, and never had any idea I could use it for space planning. No more running out of graph paper! Thanks for such an amazing and detailed post on how to do it!Anonymoushttps://www.blogger.com/profile/11065527135809015829noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-45257820667365181052016-07-08T12:19:27.560-05:002016-07-08T12:19:27.560-05:00This is such a smart way to plan a space! I've...This is such a smart way to plan a space! I've never used excel for this (I've just done rough sketches on paper), but I'm going to have to start. The pretty pictures at the end and having everything laid out may also help me talk my engineer-brained husband into my crazy ideas! :)Anonymoushttps://www.blogger.com/profile/02929835179702941373noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-37158450916687307362016-07-08T09:51:39.808-05:002016-07-08T09:51:39.808-05:00What font are you using in your snapshots? I reall...What font are you using in your snapshots? I really like it!Anonymoushttps://www.blogger.com/profile/02086902003818589777noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-60415711598669747522016-07-07T12:47:21.970-05:002016-07-07T12:47:21.970-05:00Thanks for the extra tip Casey! I just gave it a ...Thanks for the extra tip Casey! I just gave it a try and the "option" key on a Mac does the same thing, love it!IHeart Organizinghttps://www.blogger.com/profile/05084013302005288836noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-11011235157127280412016-07-07T04:12:23.730-05:002016-07-07T04:12:23.730-05:00Unbelievable tutorial Jen! I can't believe you...Unbelievable tutorial Jen! I can't believe you give this away this away for free. Thank you so much! Organised Chaoshttps://www.blogger.com/profile/16699840712189570001noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-44951278167086425842016-07-07T04:10:29.880-05:002016-07-07T04:10:29.880-05:00Amazing. ;)Amazing. ;)Lara Tradutorahttps://www.blogger.com/profile/16344515210774641132noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-71781541280657940852016-07-07T01:01:30.668-05:002016-07-07T01:01:30.668-05:00OMG! Insane and genius! Thank you!OMG! Insane and genius! Thank you!Катиусhttps://www.blogger.com/profile/12817109162189072706noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-14927275977293416362016-07-06T21:18:29.951-05:002016-07-06T21:18:29.951-05:00Thank you for all of this great information! I'...Thank you for all of this great information! I'm trying to lay out a very small office and this is exactly what I needed. My excel skills are good enough to do It! I tried the IKEA layout online but couldn't get it to work.Diannehttps://www.blogger.com/profile/10227778448858978502noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-37160308533385147162016-07-06T20:08:22.512-05:002016-07-06T20:08:22.512-05:00On a PC if you hold 'Control' and drag the...On a PC if you hold 'Control' and drag the tab to the right it will make a copy in the workbook. I don't know if that shortcut works on a Mac but it's a little time-saver. :)Caseyhttps://www.blogger.com/profile/11844752009349650621noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-26804468091726329342016-07-06T17:58:26.104-05:002016-07-06T17:58:26.104-05:00I have used Excel for years and really appreciate ...I have used Excel for years and really appreciate a planning tool in a program I am already familiar with. Now, to find time to use it. Who knew retirement could be so busy.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-87424820059544421802016-07-06T12:03:01.816-05:002016-07-06T12:03:01.816-05:00Thanks for sharing! I use MS Excel at work constan...Thanks for sharing! I use MS Excel at work constantly, and had no idea it could be utilized for space planning! I'll definitely be using it in the future!Anonymoushttps://www.blogger.com/profile/01908215432181604679noreply@blogger.comtag:blogger.com,1999:blog-8864666002840991252.post-22618002863008224372016-07-06T10:35:55.818-05:002016-07-06T10:35:55.818-05:00You are such a genius! I never would have guessed...You are such a genius! I never would have guessed that this was done on Excel. Thanks so much for sharing your process with us!Jamie | anderson + granthttps://www.blogger.com/profile/08871374691770204046noreply@blogger.com