Excel tips and tricks: How to draw a floor plan tutorial
47.5 هزار بار بازدید -
4 سال پیش
-
In this video tutorial I
In this video tutorial I discuss some Excel tips and tricks on how to draw a floor plan. This is a fun project and the advantage of using excel for this is that Excel makes it easy to draw your floor plan to scale. You could use this Microsoft Excel floor plan to design a garden, position a house on a plot of land, lay out a room in a house like a kitchen for instance. This video also shows how to use Microsoft Excel to draw shapes. The following Excel tips and tricks are discussed in this tutorial:-
1. Set your zoom slider (bottom right of screen) at the halfway mark, that is 100% or 1:1 ratio. This allows you to adjust the scale of the floor plan both ways. Click and drag slider left to reduce the size or right to enlarge.
2. At the top left of the spreadsheet (where the columns and rows meet) is a small triangle. Left click on this to select all the cells in the spreadsheet.
3. Move right along the letters at the top of the columns until the division between columns A and B. A double arrow will appear. Left click, hold down and drag left or right to change the width of all the cells. Use the value for pixels in brackets above the curser to record the width. In this case we used 40 pixels. Let go the left mouse button.
4. Now move to the division between rows 1 and 2. When the double arrow appears left click and drag up or down to adjust the height of all the cells. Set the pixel value as the same as the column width, in this case 40 pixels. Then Let go the left mouse button. Now all the cells in the spread sheet will be squares of the same size.
5. Go back to the zoom slider at the bottom left of screen. Move left or right until all the squares are of a suitable size for your particular floor plan. Record the % of the slider on the floor plan so you can recreate it exactly. Decide on a value for each square metres, feet, centimetres or any value you like and record that next to the % value of the slider.
6. Select an area for the outline of the floor plan. It is good to leave a clear border all around so that your floor plan border does not get confused with the spreadsheet border.
7. Under the HOME Icon at the top of the Excel screen select BORDERS then THICK BOX BORDER to put a border all around your selected area.
8. Give your selected area a background colour by selecting HOME then COLOR FILL and choose a colour.
9. To place elements in your floor plan just select an area. Select HOME then BORDERS then MORE BORDERS. Here you can select the type of border and which sides of the selection should be bordered. These elements should be colour filled with a different colour and perhaps labelled with text.
10. To type vertically first select the area and type the word (it will appear horizontally). Then select HOME and under ALIGNMENT select ab with the slanting arrow then select Vertical Text. Then select MERGE&CENTER.
11. To add a shape for a particular element on your floor plan. Under the INSERT icon select SHAPES and select a particular shape then click on the floor plan where you want the shape to be. You can click and drag the shape around and resize or colour it.
Comments are most welcome, try this and send us some feedback☺️
Why not watch the whole Excel tutorial course of 7 videos for beginners here:
Excel beginner's tutorial: create you...
Comments are most welcome, if you decide to try this please send us some feedback☺️ Why not visit our channel and browse through our other videos? annerasmus
Video Chapters time stamps
Here are some time stamps for browsing the content of this video:
00:00 Beginning
00:48 Changing Excel cell size and shape so that gridlines suite floor plan scale
02:50 Selecting the outline of the floor plan and placing a border around the area in Excel
03:55 Select ' more borders' to draw a customised border to suite shape of the Excel floor plan
05:41 How to shade Excel floor plan with different colours like paving or lawn
05:56 How to simulate lawn and paving in Excel floor plan
07:05 How to insert doors and windows in the Excel floorplan
07:55 How to Insert separate rooms into excel floor plan
08:37 How to insert trees and flower beds in the garden of the Excel floor plan
09:20 How to insert text on Excel floor plan
09:32 How to insert vertical text in an Excel floor plan
The text for this topic can be viewed on the blog article: https://basiclowdown.com/excel-tips-a...
Short Disclaimer/disclosure: My videos/articles are for informational and educational purposes only, you should consult with a professional before attempting anything seen or done in my videos/articles. Please read full disclaimer here: https://basiclowdown.com/disclaimer-d...
1. Set your zoom slider (bottom right of screen) at the halfway mark, that is 100% or 1:1 ratio. This allows you to adjust the scale of the floor plan both ways. Click and drag slider left to reduce the size or right to enlarge.
2. At the top left of the spreadsheet (where the columns and rows meet) is a small triangle. Left click on this to select all the cells in the spreadsheet.
3. Move right along the letters at the top of the columns until the division between columns A and B. A double arrow will appear. Left click, hold down and drag left or right to change the width of all the cells. Use the value for pixels in brackets above the curser to record the width. In this case we used 40 pixels. Let go the left mouse button.
4. Now move to the division between rows 1 and 2. When the double arrow appears left click and drag up or down to adjust the height of all the cells. Set the pixel value as the same as the column width, in this case 40 pixels. Then Let go the left mouse button. Now all the cells in the spread sheet will be squares of the same size.
5. Go back to the zoom slider at the bottom left of screen. Move left or right until all the squares are of a suitable size for your particular floor plan. Record the % of the slider on the floor plan so you can recreate it exactly. Decide on a value for each square metres, feet, centimetres or any value you like and record that next to the % value of the slider.
6. Select an area for the outline of the floor plan. It is good to leave a clear border all around so that your floor plan border does not get confused with the spreadsheet border.
7. Under the HOME Icon at the top of the Excel screen select BORDERS then THICK BOX BORDER to put a border all around your selected area.
8. Give your selected area a background colour by selecting HOME then COLOR FILL and choose a colour.
9. To place elements in your floor plan just select an area. Select HOME then BORDERS then MORE BORDERS. Here you can select the type of border and which sides of the selection should be bordered. These elements should be colour filled with a different colour and perhaps labelled with text.
10. To type vertically first select the area and type the word (it will appear horizontally). Then select HOME and under ALIGNMENT select ab with the slanting arrow then select Vertical Text. Then select MERGE&CENTER.
11. To add a shape for a particular element on your floor plan. Under the INSERT icon select SHAPES and select a particular shape then click on the floor plan where you want the shape to be. You can click and drag the shape around and resize or colour it.
Comments are most welcome, try this and send us some feedback☺️
Why not watch the whole Excel tutorial course of 7 videos for beginners here:
Excel beginner's tutorial: create you...
Comments are most welcome, if you decide to try this please send us some feedback☺️ Why not visit our channel and browse through our other videos? annerasmus
Video Chapters time stamps
Here are some time stamps for browsing the content of this video:
00:00 Beginning
00:48 Changing Excel cell size and shape so that gridlines suite floor plan scale
02:50 Selecting the outline of the floor plan and placing a border around the area in Excel
03:55 Select ' more borders' to draw a customised border to suite shape of the Excel floor plan
05:41 How to shade Excel floor plan with different colours like paving or lawn
05:56 How to simulate lawn and paving in Excel floor plan
07:05 How to insert doors and windows in the Excel floorplan
07:55 How to Insert separate rooms into excel floor plan
08:37 How to insert trees and flower beds in the garden of the Excel floor plan
09:20 How to insert text on Excel floor plan
09:32 How to insert vertical text in an Excel floor plan
The text for this topic can be viewed on the blog article: https://basiclowdown.com/excel-tips-a...
Short Disclaimer/disclosure: My videos/articles are for informational and educational purposes only, you should consult with a professional before attempting anything seen or done in my videos/articles. Please read full disclaimer here: https://basiclowdown.com/disclaimer-d...
4 سال پیش
در تاریخ 1399/07/10 منتشر شده
است.
47,545
بـار بازدید شده