07x Rows, Columns and Freeze Panes

Exercise 1

  1. Open a new book in Excel.
  2. Insert the word Row in cell A4.
  3. Insert a row below row 3 so that row 4 becomes row 5. The word Row that you typed in should move down a row to cell A5.
  4. Insert the word Column in cell D1.
  5. Insert a column after column C so that column D becomes column E. The word Column that you typed in should move along to cell E1.
  6. Change the height of rows 1 to 5 to size 10.
  7. Change the width of columns A to E to size 20.
  8. Cut the text from cell E1 and paste it into cell B2.
  9. Close the document without saving it.

Exercise 2

  1. Open a new book in Excel.
  2. Insert data to as shown below:



  3. Resize the columns so that all the data is visible.
  4. Set a freeze pane so that the headings in row 1 remain visible while you scroll down the worksheet, as follows:
    1. Click on label row 2.
    2. On the menu bar click on Window.
    3. In the pop-down menu click on Freeze Panes.
  5. Scroll down the worksheet and ensure the Freeze Pane is active:


 

Back to Excel Home Page