USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Onthe Data tab, select Name Cells.
|
|
|
On theHome tab, select Cell Styles.
|
|
|
On thePage Layout tab, select Name Range
|
|
|
On theFormulas tab, select Define Name
|
Detailed explanation-1: -Create a named range On the Formulas tab, in the Defined Names group, click Define Name. In the New Name dialog box, in the Name box, type the name you want to use for your reference. Note: Names can be up to 255 characters in length.
Detailed explanation-2: -Select the range you want to name, including the row or column labels. Click Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header.
Detailed explanation-3: -Define names from a selected range Select the range you want to name, including the row or column labels. Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.