Excel Restore Default Cell Size: Quick Steps

To restore the default cell size in Excel, select all cells (Ctrl+A), then set Row Height to 15 and Column Width to 8.43 on the Home tab. This resets the standard dimensions for a new workbook, which are 15 points high and 8.43 characters wide (about 64 pixels).

Formula

The default row height in Excel is 15 points, and the default column width is 8.43 characters (based on the standard font, Calibri 11). The formula to reset is simply:

Row Height = 15 points
Column Width = 8.43 characters

These values are what Excel uses for a new, blank worksheet. The row height is measured in points (1 point = 1/72 inch), and column width is measured in characters of the default font. If you have changed the default font, the character width may differ, but 8.43 is the standard for Calibri 11.

Worked Example

Using the default values from the calculator above (finish time = 50 minutes, distance = 10 km):

1. Calculate pace: 50 min ÷ 10 km = 5.00 min/km
2. Calculate speed: 10 km ÷ (50 min ÷ 60) = 10 ÷ 0.8333 = 12.00 km/h

The calculator returns an average pace of 5.00 min/km and an average speed of 12.00 km/h.

Why Default Cell Size Matters

Excel’s default cell size is designed for readability and compatibility. The 15-point row height accommodates the standard 11-point font with a bit of padding, and the 8.43-character column width shows about eight to nine characters clearly. When you change these dimensions, it can affect printing, copying data, and how charts or formulas display. Restoring defaults is useful when you’ve resized rows or columns manually and want to return to a consistent, standard look.

How to Restore Default Cell Size in Excel

Follow these steps to reset all cells to the default size:

1. Open your Excel worksheet.
2. Click the square at the intersection of the row numbers and column letters (or press Ctrl+A twice) to select the entire sheet.
3. Go to the Home tab.
4. In the Cells group, click Format.
5. Under Cell Size, choose Row Height and enter 15.
6. Again under Format, choose Column Width and enter 8.43.
7. Press OK. All cells now have the default size.

If you only want to reset a specific range, select that range instead of the whole sheet.

Using the Calculator to Understand Pace and Speed

While restoring cell size is a common Excel task, you might also use Excel to calculate running pace or speed. The calculator above helps you convert a finish time and distance into average pace and speed. For example, if you run 10 km in 50 minutes, your pace is 5 minutes per kilometer, and your speed is 12 km/h. This is useful for training plans, race predictions, or comparing performances.

Common Mistakes and How to Avoid Them

• Not selecting the whole sheet: If you only select a few cells, the reset won’t apply everywhere. Use Ctrl+A twice to select all.
• Using the wrong units: Row height is in points, not pixels. Column width is in characters, not inches. Don’t confuse them.
• Forgetting the default font: If you changed the default font, the character width may differ. Reset the font to Calibri 11 for the true default.
• Mixing up row and column: Row height affects vertical size, column width affects horizontal. Enter the values in the correct fields.

Limitations and Additional Tips

The default size is a starting point, not a rule. You may need to adjust for specific content, like long text or merged cells. Also, when you copy data from another sheet, the cell sizes don’t automatically copy—you can use Paste Special to match destination formatting. If you want to set a new default for all future workbooks, you can modify the default font and then save a template, but the standard default remains 15 and 8.43.

Frequently Asked Questions

How do I reset only one row or column to default?

Select the specific row(s) or column(s), then go to Home > Format > Row Height or Column Width and enter the default values (15 or 8.43). This will not affect other cells.

Why is my column width showing 8.43 but not exactly?

Excel may display 8.43 as the default, but the actual width can be slightly different due to font metrics. For most purposes, 8.43 is the standard. If you need pixel-perfect, use the View tab and switch to Page Layout view to see measurements in inches.

Does changing the default font affect cell size?

Yes, the default column width is based on the default font. If you change the font to a wider one, the character width changes, so the default column width may not display as many characters. Resetting the font to Calibri 11 will restore the standard.

Can I set a custom default cell size for all new workbooks?

Yes, you can change the default font or row height/column width in a template. Go to File > Save As and choose Excel Template (.xltx). Then set the sizes you want and save. New workbooks based on that template will use your custom defaults.

What is the default row height in pixels?

In Excel, the default row height of 15 points is approximately 20 pixels (at 96 DPI). Column width of 8.43 characters is about 64 pixels. These values can vary slightly depending on screen resolution and zoom level.

Related

• Samsung SRF9400BFH: Buy for Capacity, Not Screen
• UPI vs Cards: Merchant Fees & Customer Choice
• VLC Record Screen With Audio: Full Guide

in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2