Format: Before you started to enter the data in MS-Excel Worksheet, you may find yourself needing to expand or reduce cell's row widths and column heights in purpose, there are several ways to adjust them. By default, when you create a new workbook in Excel, the row height and column width is always the same for all cells. However, you can easily change the height and width for one or more rows and columns. For example, the new Excel workbooks have set it up with default row height for all the rows is 15points and the default column width for all the columns is 8.38points. However, you can choose a specific height for any of the rows as well as a specific column width for any of the columns. The height can be different for different rows and the width also can be different for different columns. If you want to adjust only one row or one by one as your needs, you can move the cursor-(mouse) over the bottom border of the row heading until it turns into a bar with a double arrow. Then, click on the border and drag it up or down to change the height of the row above the border. As you drag the cursor, the changing height displays in a popup. Row Height: When it’s needed to do adjustment in row heights for selected rows, you can do by using row height tool in the Format ribbon of the Cells section. And there is one more tool is calling AutoFit Row Height, with this tool you can change height of the rows of contents automatically. How to increase height for selected rows only? Select rows that you want to increase height => Select Home Menu => Click Format Tool => Click Row Height => Type size “20” that you want => Click OK. For more understanding, look at the screenshot please: Column Width: When it’s needed to do adjustment in column width for selected columns, you can do by using column width tool in the Format ribbon of the Cells section. And there are two more tools are calling AutoFit Column Width and Default Width and with the Default Width tool, you can bring back width of columns for default that you are selected. How to increase width for selected columns only? Select columns that you want to increase width => Select Home Menu => Click Format Tool => Click Column width => Type size “11” that you want => Click OK. For more understanding, look at the screenshot please:
0 Comments
|
Archives |