Excel automatically adjusts the Row Height and sets the default Row Height

Excel automatically adjusts the Row Height and sets the default Row Height

Abstract: This article introduces how to automatically adjust the Row Height and the default Row Height in Excel.

First, the method for Automatically Adjusting the Row Height in Excel is as follows:

Excel2010, the default line height is 14.25. To adjust the height of a row, select the row whose height is to be adjusted, and click Start> row height. The "Row Height" dialog box is displayed, and enter a number. If the row height is 0, the row is hidden.

If the cell already contains content, you need to adjust the Row Height automatically based on the content in Excel. If the cursor changes to the double cross arrow, double-click the arrow to automatically adjust the Row Height. To set the Row Height for all rows in the worksheet, click "select all" and set the Row Height.

Second, set the default Row Height in Excel

The settings described in the first part are not the default Row Height for Excel settings. Valid only for the current worksheet. If you need to open all the worksheets in the future, the default Row Height is set just now. Follow the steps below.

Create an Excel worksheet, set the Row Height, save it as a template, and set this module as the default template. Save the Row Height file to the c: \ windows \ Documents and Settings \ current user name \ Application Data \ Microsoft \ Excel \ xlstart folder by default. This document mode will be automatically called when it is opened later, so that the default row height can be set in Excel.

Excel automatically adjust the Row Height and Excel settings default line height, more related knowledge reference: http://www.ittribalwo.com/search.asp? Keyword = % D0 % D0 % B8 % DF & stype = title & submit3 = + % B2 % E9 % D5 % D2 +

Source Document