Here, we will select the Double line style. Now, from the Border tab in Style options choose any Border of your choice.Again, the Format Cells box will appear.Then, go to the Home tab > click on Borders > select More Borders.Now, you will get the External Wall of the Floor Plan.Then, add this Border to the Bottom, Top, Left, and Right of the Cell range.After that, from the Border tab in Style options choose any Border of your choice.Then, go to the Home tab > click on Borders.In the beginning, select Cell range B4:Z38.Go through the steps given below to draw to your own preferred scale in Excel. Here, we will use a scale of 1 square unit (Cell) equivalent to 1 square foot. Now, we will draw a Floor Plan of 25 X 35 sq ft using Borders in Excel. Step-02: Drawing Walls to Scale Using Borders in Excel Next, the Column Width box will appear.Again, go to the Home tab > click on Cells > click on Format > select Column Width.Then, go to the Home tab > click on Cells > click on Format > select Row Height.Firstly, click on the Box in the Left Corner to select all the Rows and Columns of the Excel Worksheet.Now, we will set up the Row Height and Column Width of the cells to draw to scale in Excel.įollow the steps given below to do it on your own. Step-01: Setting Up Row Height & Column Width Go through the steps to do it on your own. In the first method, we will show you how to draw to scale in Excel using different kinds of Borders. Using Border Options to Draw to Scale in Excel In this article, we will draw a Floor Plan to show you how to draw to scale in Excel using different kinds of Borders and Fill Colors.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |