4.2.1 Practice Ex 3 & 4; Column Width/Row Height Adjustments – Intro to Excel 2016

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).

​​
STEP 3C: After the height increases to 30.00, stop the mouse dragging and release the mouse button (FIGURE 7).

                                                   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