USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1 to 7 > Right click in Row 1 > Row Height > Enter 15
|
|
|
Select Columns A to G > Right click in Column A > column width > Enter 25. Select Rows 1, 5 and 7 while holding the Ctrl key > Right click in Row 1 > Row Height > Enter 15
|
|
|
Select Columns A to G > Drag right border of Column G to the right until it display the value 25. Select Rows 1, 5 and 7 > Drag the border bottom of the row header downwards until it displays the value 15
|
|
|
Select Columns A to G > Format tab > Column > Width > Enter 25. Select Rows 1 to 5 > Format tab > Row > Height > Enter 15
|
Detailed explanation-1: -Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.
Detailed explanation-2: -On the first column click A to select the column, and then right click and select Column Width. Type the width that you want for your column. Click OK.
Detailed explanation-3: -Adjust the column width To increase the column width quickly and easily, you can move your mouse to the far-right edge of the column label area until you see the crosshairs (see below). You then just double-click your mouse, and the column is adjusted to fit the width of the largest content.