Operations on Worksheets

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Operations on Worksheets

The Sequence of Worksheets

By default, worksheets are positioned in a numbered format that makes it easy to count them. More often you will find that, after creating a few of them, you are not satisfied with their positions. You should be able to reposition them in a manner that suits your particular scenario.

To move a worksheet, click and hold the mouse on its tab, then move the mouse in the direction of your choice. While you are moving the worksheet, the mouse pointer will turn into a white piece of paper and a small down-pointing triangle will guide you. Once the small triangle is positioned in the desired location, release the mouse.

Practical Learning Practical Learning: Controlling Worksheets Positions

  1. Click and hold the mouse on the Request For Time Off tab
  2. Move the mouse in the right direction. Notice that the mouse pointer turns into a white piece of paper and there is a small triangle that guides you
  3. Once the small triangle is positioned between Tuition Reimbursement and Time Sheet, release the mouse
     
    Moving a Worksheet
  4. Now we will move the Time Sheet worksheet because that is the form that employees are using on a regular basis before anything else.
    Click the hold the mouse on the Time Sheet tab
  5. Move the mouse in the left direction
  6. When the small triangle is positioned to the left of Tuition Reimbursement, release the mouse
  7. Save the file

Adding New Worksheets

As mentioned already, when Microsoft Excel starts, by default, creates three worksheets. We also mentioned that you can change this default number in the Excel Options dialog box. You can add a new worksheet anytime if you judge it necessary.

Some workbooks are quite complete with just one worksheet, but others need as many worksheets as possible. The number of worksheets you use in a particular workbook is conditioned by your needs and the memory of your computer.

To add a new worksheet to a workbook:

  • Click the small tab on the right side of the existing tabs
     
    Adding a New Worksheet
  • Click the worksheet tab that will succeed the new worksheet and press Shift + F11
  • On the Ribbon, click Home. In the Cells section, click the arrow under the Insert button and click Insert Sheet
     
    Insert Sheet
  • Right-click a sheet tab and click Insert... This would display the Insert dialog box:
     
    The Insert Dialog Box

    From the Insert dialog box, you can choose to insert a blank worksheet or insert one of the existing templates as a worksheet:
     

Practical Learning Practical Learning: Adding Worksheets

  1. To start a new workbook, press Ctrl + N
  2. On the Ribbon, click Home if necessary. In the Cells section, click Format and click Rename Sheet 
  3. Type Students Info
  4. Double-click the Sheet2 tab to highlight it
  5. Type Emergency Information
  6. Right-click the Sheet3 tab and click Rename
  7. Type 6th Grade and press Enter
  8. Right-click the 6th Grade tab and click Insert…
  9. In the Insert dialog, make sure that the General property page is selected; if it is not, click it and click Worksheet
     
  10. Click OK
  11. Right-click the new Sheet4 tab and click Rename
  12. Type 5th Grade and press Enter
  13. In the Cells section of the ribbon, click the down-pointing button under Insert and click Insert Sheet
  14. To change the name of the current worksheet, in the Cells section of the Ribbon, click Format -> Rename Sheet 
  15. Type 4th Grade and press Enter
  16. Press Shift + F11
  17. Double-click the new Sheet tab to highlight it
  18. Type 3rd Grade and press Enter
  19. Press F4 to add a new worksheet
  20. Double-click the new sheet tab to rename it
  21. Type 2nd Grade and press Enter
  22. Press Shift + F11 to insert another worksheet
  23. Right-click the new sheet tab and click Rename
  24. Type 1st Grade and press Enter
  25. Press F12 to save the workbook
  26. Set its name to Solstice Academy1 and press Enter

Removing Worksheets

As your work progresses, you will decide how many worksheets you need for your particular workbook. Just as we learned to add worksheets, you can delete or remove the worksheets you don't need anymore. Since a worksheet is not a file, when you delete a worksheet, it is permanently gone. If one or more cells of the worksheet contain data, you will receive a confirmation message to decide.

To delete a workbook:

  • You can right-click its tab and click Delete
  • In the Cells section of the Home tab of the Ribbon, click the arrow of the Delete button and click Delete Sheet

Practical Learning Practical Learning: Deleting Worksheets

  1. To delete a worksheet, right-click the Emergency Information tab and click Delete
  2. Move and arrange the worksheet so that from left to right you will have Student Info, 6th Grade, 5th Grade, 4th Grade, 3rd Grade, 2nd Grade, and 1st Grade
  3. Save the file

Hiding or Revealing a Worksheet

As mentioned already, by default, Microsoft Excel makes three worksheets available to you. We also reviewed how you can add new ones or delete some of them. Instead of deleting a worksheet, you can hide it for any reason you judge necessary. If the workbook contains more than one worksheet, you can hide one or more worksheets or even the entire workbook.

To hide a worksheet in a workbook, click any cell in that worksheet to make it active:

  • Right-click the sheet tab and click Hide
  • In the Cells section of the Home tab of the Ribbon, click Format, position the mouse on Hide & Unhide, and click Hide Sheet
     
    Hide

 

The worksheet’s tab will disappear from the screen although it is not deleted. To hide a group of worksheets, select them and proceed in the same way. 

To unhide the hidden worksheets:

  • Right-click any tab and click Unhide...
  • In the Cells section of the Ribbon, click Format, position the mouse on Hide & Unhide, and click Unhide Sheet...

This would open the Unhide dialog box with a list of the the names of the hidden worksheets:

If you have more than one hidden sheet, select the desired worksheet and click OK.

Practical Learning: Hiding a Worksheet

  1. Right-click the Student Info tab and click Hide
  2. Click the 3rd Grade tab
  3. Press and hold Ctrl
  4. Click the 1st Grade tab
  5. On the Ribbon, click Home if necessary.
    In the Cells section, click Format, position the mouse on Hide & Unhide, and click Hide Sheet
     
    Hiding Some Worksheets
  6. To unhide the worksheets, right-click any sheet tab and click Unhide...
  7. In the Unhide dialog box, click 1st Grade and click OK
  8. In the Cells section of the Ribbon, click Format, position the mouse on Hide & Unhide, and click Unhide Sheet...
  9. In the Unhide dialog box, click 3rd Grade and click OK
  10. Right-click any sheet tab and click Unhide...
  11. In the Unhide dialog box, click OK
  12. Close Microsoft Excel. If asked whether you want to save, click No

Worksheets and the Web

You can publish the content of a worksheet to a web page. In Microsoft Excel, you can publish just one worksheet or the whole workbook. To perform publishing, first decide on what you want to publish, a worksheet or the whole workbook.

To save a file for the web, click the Office Button, position the mouse on Save As and click Other Formats. In the Save As Type combo box, select Web Page (.html). Specify whether to save the whole document or only some worksheets. Click Save. Read the message box and click Yes.