How to Reset Cell Size to Default in Excel (5 Easy Ways)

In this article, we will learn to reset cell size to default in Excel. A cell has a rectangular shape that has a width and a height. We can change the height and width to default using different methods. Sometimes, when we copy or download a dataset, the cell size of the dataset can be different. Today, we will try to reset the cell size to default. In excel, the default height of a cell is 15 and the default width is 8.43.


Download Practice Book

Download the practice book here.


5 Ways to Reset Cell Size to Default in Excel

To explain these methods, we will use a dataset that contains information about the department, working hours, and age of some employees. Our dataset has different column widths and its row height is 20.


1. Restore Cell Size to Default with Format Option in Excel

In the first method, we will use the format option to restore cell size to default. We can use this method to reset the size of selected cells as well as restore the size of all cells.

Let’s follow the steps below to learn this method.

STEPS:

  • Firstly, select the cells that you want to resize. We have selected Cell B4 to E10.
  • To select all cells, click on the Select All button or press Ctrl A.

Restore Cell Size to Default with Format Option in Excel

  • Secondly, go to the Home tab and select Format.
  • A drop-down menu will occur. Select Row Height from the drop-down menu.

Restore Cell Size to Default with Format Option in Excel

  • After that, a Row Height window will appear. Type 15 in the Row height field and click OK.

Restore Cell Size to Default with Format Option in Excel

  • After clicking OK, you will see results like below.

Restore Cell Size to Default with Format Option in Excel

  • Again, go to the Home tab and select Then, select Column Width from the drop-down menu. The Column Width window will occur.

Restore Cell Size to Default with Format Option in Excel

  • Now, write 8.43 in the Column width field and click OK.

Restore Cell Size to Default with Format Option in Excel

  • After clicking OK, you will see results like below.

Restore Cell Size to Default with Format Option in Excel

  • Finally, to display the texts fully, change the font size.

Restore Cell Size to Default with Format Option in Excel

Read More: How to Make a Cell Bigger in Excel (Easiest 7 Ways)


2. Excel VBA to Reset Cell Size to Default

VBA is very helpful to perform different tasks quickly. We can use VBA to reset cell size to default in excel. Here, we will use the same dataset.

Excel VBA to Reset Cell Size to Default

Let’s pay attention to the steps below.

STEPS:

  • In the beginning, go to the Developer tab and select Visual Basic.
  • The Visual Basic window will appear.

Excel VBA to Reset Cell Size to Default

  • Now, go to Insert and select Module.
  • Then, type the code in the Module window.
Sub Resize_Cell_Size()
Dim sheet As Worksheet
Set sheet = Worksheets("VBA")
With sheet
    .Cells.UseStandardHeight = True
    .Cells.UseStandardWidth = True
End With
End Sub

Excel VBA to Reset Cell Size to Default

Here, this code will set the height and width of the cells of a sheet to standard height and width. You need to write the name of the worksheet inside the parentheses of Worksheets(). We also need to use the double quotation.

  • After that, press Ctrl + S to save the code.
  • Next, select Macros from the Developer tab. It will open the Macro window.

Excel VBA to Reset Cell Size to Default

  • Following this, select the code from the Macro window and hit Run.

Excel VBA to Reset Cell Size to Default

  • Finally, you will see results like below.

Excel VBA to Reset Cell Size to Default

  • Ultimately, change the font size to show the full texts.

Excel VBA to Reset Cell Size to Default

Related Content: How to Autofit in Excel (7 Easy Ways)


3. Rescale Cell Size to Default in Excel by Dragging

In this method, we will rescale the cell size to default by dragging. It becomes very easy when you are using a mouse. We can use this method to resize all cells. To explain the steps, we will use the same dataset here.

Let’s observe the steps below to know more.

STEPS:

  • In the first place, click the Select All button.

Rescale Cell Size to Default in Excel by Dragging

  • After clicking the Select All button, you will see all the cells are selected.

Rescale Cell Size to Default in Excel by Dragging

  • Now, put the cursor on the borderline of two columns. We placed it on the borderline of Columns A B.

Rescale Cell Size to Default in Excel by Dragging

  • Then, drag the line until it displays 8.43 on the screen.

Rescale Cell Size to Default in Excel by Dragging

  • After that, put the cursor on the borderline of Rows 1 2.

Rescale Cell Size to Default in Excel by Dragging

  • Then, drag the line until it displays 15 on the screen.

Rescale Cell Size to Default in Excel by Dragging

  • Next, select any cell in your dataset to see results like below.

Rescale Cell Size to Default in Excel by Dragging

  • Finally, to display full texts change the font size.

Rescale Cell Size to Default in Excel by Dragging

Related Content: How to Increase Cell Size in Excel (7 Methods)


Similar Readings:


4. Use Context Menu to Resize Cell Size to Default in Excel

There is another way to change the cell size in excel. And that is the use of the context menu. We can use this method for a single cell or all cells. Again, we will use the same dataset.

Let’s follow the steps below.

STEPS:

  • Firstly, select a column. We have selected Column D here.
  • Then, right-click on the mouse to see the context menu.
  • Select Column Width from the context menu.

Use Context Menu to Resize Cell Size to Default in Excel

  • A Column Width will appear.
  • Now, write 8.43 in the Column width field and click OK.

Use Context Menu to Resize Cell Size to Default in Excel

  • After clicking OK, you will see the column width of Column D has decreased to 8.43.

Use Context Menu to Resize Cell Size to Default in Excel

  • Next, select a row. We have selected Row 9 here.
  • Right-click on the mouse to see the context menu.
  • Select Row Height from there.

Use Context Menu to Resize Cell Size to Default in Excel

  • Now, type 15 in the Row height field and click OK.

  • Instantly, Cell D9 reset to the default size.

  • To apply the same thing to all columns, press Ctrl and select the columns.
  • Then, right-click on the mouse to see the context menu.
  • Select Column Width from there.

  • The Column Width will occur. Type 8.43 in the Column width field and click OK.

  • Next, press Ctrl and select the rows.

  • After that, right-click on the mouse to see the context menu.
  • Select Row Height from there.

  • Write 15 in the Row Height window and click OK.

  • Finally, you will see results like below.

  • In the end, change the font color to show full texts like below.

Read More: How to Make Cells Independent in Excel (5 Methods)


5. Reset Cell Size to Default in Excel from File Tab

In this last method, we will discuss how we can reset the cell size using the file tab. This method is applicable at the start of creating any dataset. You need to apply these settings before starting your work on a new worksheet.

Let’s follow the steps below.

STEPS:

  • Firstly, go to the File tab.
  • Secondly, select Options.

  • The Excel Options will appear.
  • Next, select General from there.
  • Use Body Font as the default font and set the Font size to 11.

  • Finally, click OK.
  • Now, if you create any new worksheet, the cell size will be set as the default. The row height should be 15 and the column width should be 8.43. If it doesn’t show the desired results, you can use Method-1.

Read More: How to Make All Cells the Same Size in Excel (5 Quick Ways)


Things to Remember

The row height depends on the font size. So, when we reset cell size to default, the cells may not display full texts. You need to change the font size to show the full texts.


Conclusion

Here, we have discussed 5 easy and quick ways to reset cell size to default in excel. We have also used a VBA code to solve this problem. I hope these methods will help you to reset cell size to default very easily. Furthermore, we have also added the practice book at the beginning of the article. You can download the practice book to exercise more. Last of all, if you have any queries or suggestions, feel free to ask in the comment section below.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo