How to Draw to Scale in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to draw to scale in Excel? We can draw in any scale we want in Excel, adjusting the row and column size. Here, you will find 2 ways to draw to scale in Excel.


How to Draw to Scale in Excel (2 Easy Ways)

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.


1. Using Border Options to Draw to Scale in Excel

In the first method, we will show you how to draw to scale in Excel using different kinds of Borders. Go through the steps to do it on your own.


Step-01: Setting Up Row Height & Column Width

Now, we will set up the Row Height and Column Width of the cells to draw to scale in Excel.

Follow the steps given below to do it on your own.

  • Firstly, click on the Box in the left corner to select all the Rows and Columns of the Excel Worksheet.

Setting Up Row Height & Column Width to Draw to Scale in Excel

  • Then, go to the Home tab >> click on Cells >> click on Format >> select Row Height.

  • Now, the Row Height box will appear.
  • After that, insert 9 as the Row Height.
  • Next, click on OK.

Setting Up Row Height & Column Width to Draw to Scale in Excel

  • Again, go to the Home tab >> click on Cells >> click on Format >> select Column Width.

  • Next, the Column Width box will appear.
  • Then, insert 1 as Column Width.
  • After that, click on OK.

Setting Up Row Height & Column Width to Draw to Scale in Excel


Step-02: Drawing Walls to Scale Using Borders in Excel

Now, we will draw a Floor Plan of 25 X 35 sq ft using Borders in Excel. Here, we will use a scale of 1 square unit (Cell) equivalent to 1 square foot.

Go through the steps given below to draw to your own preferred scale in Excel.

  • In the beginning, select Cell range B4:Z38.
  • Then, go to the Home tab >> click on Borders.

Drawing Walls to Scale Using Borders in Excel

  • Next, select More Borders.

  • Now, the Format Cells box will open.
  • After that, from the Border tab in Style options choose any Border of your choice. Here, we will select the Double-line style.
  • Then, add this Border to the Bottom, Top, Left, and Right of the Cell range.
  • Next, click on OK.

Drawing Walls to Scale Using Borders in Excel

  • Now, you will get the External Wall of the Floor Plan.

  • After that, select Cell range B4:N14.
  • Then, go to the Home tab >> click on Borders >> select More Borders.

Drawing Walls to Scale Using Borders in Excel

  • Again, the Format Cells box will appear.
  • Now, from the Border tab in Style options choose any Border of your choice. Here, we will select the Double-line style.
  • Then, add this Border to the Bottom and Right of the Cell range.
  • Next, click on OK.

  • After that, you will get the walls of a room of 13’ X 11’ in scale.

Drawing Walls to Scale Using Borders in Excel

  • Now, to create a gap for the door, select Cell range L14:N14.
  • Then, go to the Home tab >> click on Borders >> select More Borders.

  • Next, the Format Cells box will open again.
  • After that, from the Border tab unselect the Border from Bottom.
  • Then, click on OK.

Drawing Walls to Scale Using Borders in Excel

  • Thus, you can create a gap between the walls for the door.


Step-03: Using Rectangles Adding Text in the Drawing

In the final step, we will show you how to add text to the Drawing using Rectangle from Shapes. Follow the steps given below to do it on your own.

  • Firstly, go to the Insert tab >> click on Illustrations >> click on Shapes >> select Rectangle.

Using Rectangles Adding Text in the Drawing to Draw to Scale in Excel

  • Then, insert a Rectangle and right-click on it.

  • After that, select Edit Text.

Using Rectangles Adding Text in the Drawing

  • Next, type any description you want to add in the Rectangle. Here, we will type Master Bedroom 13’ X 11’ in the Rectangle.

  • Now, select the Text.
  • Then, go to the Home tab >> select Middle and Center Alignment.

Using Rectangles Adding Text in the Drawing

  • Next, select the Rectangle.
  • After that, go to the Shape Format tab >> click on Theme Styles.

  • Then, select any Theme Style of your preference. Here, we will select Colored Outline – Blue, Accent 5.

Using Rectangles Adding Text in the Drawing

  • Now, you will get a room drawn in scale with a description in a Rectangle.

  • Similarly, draw other rooms in scale and add descriptions to the rooms.
  • Thus, you can draw to scale in Excel using different kinds of Borders.

 How to Draw to Scale in Excel Using Borders

Read More: How to Draw Shapes in Excel


2. Applying Fill Color to Draw to Scale in Excel

Now, we will show you how to draw to scale in Excel using Color. Here, we will use a scale of 1 square unit (Cell) equivalent to 1 square foot. Additionally, we will use walls of 1ft width and add color to them.

Go through the steps given below to do it on your own.

Steps:

  • Firstly, set up the Row Height and Column Width of the cells following the same steps shown in Method 1.

Applying Color to Draw to Scale in Excel

  • After that, select Cell range B4:AC4.
  • Then, go to the Home tab >> click on Fill Color.

  • Now, select any Fill Color of your choice. Here, we will select Blue, Accent 1, Darker 50%.

Applying Color to Draw to Scale in Excel

  • Next, select Cell range B4:B43.
  • Then, go to the Home tab >> click on Fill Color.
  • Now, this will automatically select the Fill Color we selected previously.

  • After that, select Cell range C43:AC43.
  • Again, go to the Home tab >> click on Fill Color.

Applying Color to Draw to Scale in Excel

  • Then, select Cell range AC5:AC42.
  • Next, go to the Home tab >> click on Fill Color.

  • Now, you will get the External Wall of the Floor Plan.

Applying Color to Draw to Scale in Excel

  • After that, select Cell range P5:P16.
  • Next, go to the Home tab >> click on Fill Color.

  • Then, select Cell range C16:L16.
  • Again, go to the Home tab >> click on Fill Color.

Applying Color to Draw to Scale in Excel

  • After that, you will get the walls of a room of 13’ X 11’ in scale.

Applying Color to Draw to Scale in Excel

  • Next, insert a Rectangle and add text to it following the same steps shown in Method 1.
  • Now, you will get a room drawn in scale with a description in a Rectangle.

  • Similarly, draw other rooms in scale and add descriptions to the rooms.
  • Thus, you can draw to scale in Excel using different kinds of Borders.

Applying Color to Draw to Scale in Excel

Read More: How to Make Fishbone Diagram in Excel


Practice Section

In this section, we are giving you a blank Worksheet to practice on your own and learn to use these methods.

Practice Section


Download Practice Workbook


Conclusion

So, in this article, you will find 2 ways to draw to scale in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles


<< Go Back to Drawing in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo