Practice Exercise 3: Perform worksheet column width and row height adjustments using a mouse
|
NOTE: EXCEL ONLINE USERS: the mouse symbol looks slightly different when adjusting column width/row height (two vertical lines instead of one)
We are going to widen Column A to fit the width of your full name. STEP 1A: Move the mouse up to the divider between Column A and B. (FIGURE 1) |
 FIGURE 1
|
|
STEP 1B: Click and drag mouse to the right to widen column to size 30.00. As you drag the mouse, a Width box will appear indicating the changing width (FIGURE 2).
|
 FIGURE 2
|
|
STEP 1C: After the width increases to 30.00, stop the mouse dragging and release the mouse button. This is the manual way of widening a column. (FIGURE 3)
There is an easier way shown in the next step. |
 FIGURE 3
|
|
STEP 2A: Move mouse up to the divider between column A and B. Double-click the mouse. (FIGURE 4)
|
 FIGURE 4
|
|
STEP 2B: Column A automatically resizes to fit your full name. This is the fastest and most efficient way to resize a column. (FIGURE 5)
|
 FIGURE 5
|
|
EXCEL ONLINE USERS: The mouse symbol looks slightly different when adjusting column width/row height (two horizontal lines instead of one).
STEP 3A: Increase the row height by moving the mouse over to the divider between row 1 and row 2 (FIGURE 6). STEP 3B: Click and drag downward to increase the row height size to 30.00. As you drag the mouse, a height box will appear indicating the changing width (FIGURE 6). |
 FIGURE 6
 FIGURE 7
|
Practice Exercise 4: Perform worksheet column width and row height adjustments using the Ribbon
|
(NOTE: EXCEL ONLINE USERS-Mouse symbol resembles a hand pointing with index finger instead of an arrow)
STEP 1A: To increase the column width using the Ribbon, first select column A by moving the mouse up to the column A header. You will see a black downward pointing arrow (FIGURE 8). STEP 1B: Click the mouse on the column header to highlight all of the column A cells |
 FIGURE 8
|
|
STEP 2A: On the Ribbon, using the Home tab, locate the section Cells (FIGURE 9). Locate and mouse click the icon for the command Format. Notice it has a downward pointing arrow, indicating it provides a drop-down menu. On the drop-down menu select the choice, Column Width.
|
 FIGURE 9
|
|
STEP 2B: In the Column Width dialog box, enter 50. Press OK button (FIGURE 10).
|
 |
|
FIGURE 10
|
|
STEP 2C: Column A has now increased its width to 50 (FIGURE 11).
|
 FIGURE 11
|
|
STEP 3A: To increase the row height using the Ribbon, first select row 1 header by moving the mouse over to the row header. You will see a black rightward pointing arrow. Click the mouse on the row header to highlight the row 1 cells.
|
 FIGURE 12
|
|
STEP 3B: On the Ribbon, using the Home tab, locate the section Cells. Locate and mouse click the icon for the command Format. Notice it has a downward pointing arrow, indicating it provides a drop-down menu. On the drop-down menu select the choice, Row Height (FIGURE 13).
|
 FIGURE 13
|
|
STEP 3C: The Row Height dialog box will appear. Enter 50 and press OK button.
|
 FIGURE 14
|
|
STEP 3D: Row 1 now has a row height of 50.
|
 FIGURE 15
|
Section completed. Go to Module 4 Section 4.2.2 Practice Exercise 5 and 6; Inserting and Deleting Columns/Rows