Select an area for the outline of the floor plan. 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. Record the % of the slider on the floor plan so you can recreate it exactly. Move left or right until all the squares are of a suitable size for your particular floor plan. Go back to the zoom slider at the bottom left of screen. Now all the cells in the spread sheet will be squares of the same size.ĥ. Set the pixel value as the same as the column width, in this case 40 pixels. When the double arrow appears left click and drag up or down to adjust the height of all the cells. Now move to the division between rows 1 and 2. Use the value for pixels in brackets above the curser to record the width. Left click, hold down and drag left or right to change the width of all the cells. Move right along the letters at the top of the columns until the division between columns A and B. Left click on this to select all the cells in the spreadsheet.ģ. At the top left of the spreadsheet (where the columns and rows meet) is a small triangle. Click and drag slider left to reduce the size or right to enlarge.Ģ. This allows you to adjust the scale of the floor plan both ways. Set your zoom slider (bottom right of screen) at the halfway mark, that is 100% or 1:1 ratio. ![]() The following Excel tips and tricks are discussed:-ġ. You could use this 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 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. ![]() In this tutorial I discuss some Excel tips and tricks on how to draw a floor plan.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |