1 / 23

A few tricks to take you beyond the basics of Microsoft Office 2007

A few tricks to take you beyond the basics of Microsoft Office 2007. GCPS Tech Tips. Microsoft Excel 2007: Watch Windows Keep Cells Visible. EXCEL 2007: Watch Windows Keep Cells Visible.

zeroun
Download Presentation

A few tricks to take you beyond the basics of Microsoft Office 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office 2007 GCPS Tech Tips Microsoft Excel 2007: Watch Windows Keep Cells Visible.

  2. EXCEL 2007: Watch Windows Keep Cells Visible When an Excel worksheet contains a lot of information, it gets longer and longer. You could waste a lot of time scrolling up and down to remind yourself about cell information in another part of the worksheet.

  3. EXCEL 2007: Watch Windows Keep Cells Visible If there is data in one particular cell of a worksheet that you need to refer to over and over, you can put it in a Watch Window so that it stays visible no matter where you scroll. You can even create a Watch Window to show you data from other worksheets.

  4. EXCEL 2007: Watch Windows Keep Cells Visible To make a Watch Window , first click on the particular cell you want to watch.

  5. EXCEL 2007: Watch Windows Keep Cells Visible Then click on the Formulas tab at the top of your screen.

  6. EXCEL 2007: Watch Windows Keep Cells Visible In the Formula Auditing group, click Watch Window

  7. EXCEL 2007: Watch Windows Keep Cells Visible and your Watch Window appears.

  8. EXCEL 2007: Watch Windows Keep Cells Visible A Watch Window is a little frame that floats on top of a worksheet. No matter where you scroll, the Watch Window stays right on your screen.

  9. EXCEL 2007: Watch Windows Keep Cells Visible You can resize it.

  10. EXCEL 2007: Watch Windows Keep Cells Visible You can drag it around.

  11. EXCEL 2007: Watch Windows Keep Cells Visible And then you can close it when you no longer need it.

  12. EXCEL 2007: Watch Windows Keep Cells Visible As you scroll through the worksheet, the Watch Window stays on screen.

  13. EXCEL 2007: Watch Windows Keep Cells Visible If you make changes to the data referenced in the watch cell, the changes appear immediately in the Watch Window.

  14. EXCEL 2007: Watch Windows Keep Cells Visible If you want to add a second cell to the Watch Window, click “Add Watch.”

  15. EXCEL 2007: Watch Windows Keep Cells Visible The “Add Watch” dialog box appears.

  16. EXCEL 2007: Watch Windows Keep Cells Visible Select the cell or cells you want to add.

  17. EXCEL 2007: Watch Windows Keep Cells Visible Click on the word “Add”...

  18. EXCEL 2007: Watch Windows Keep Cells Visible And Excel inserts the additional cell or cells into the Watch Window.

  19. EXCEL 2007: Watch Windows Keep Cells Visible To remove any cell from the Watch Window, click the cell name in the window...

  20. EXCEL 2007: Watch Windows Keep Cells Visible and click “Delete Watch.”

  21. EXCEL 2007: Watch Windows Keep Cells Visible Excel removes the cell from the watch list.

  22. EXCEL 2007: Watch Windows Keep Cells Visible When finished with the Watch Window, click the “Close” button and the Watch Window disappears.

  23. EXCEL 2007: Watch Windows Keep Cells Visible That’s all there is to it. Now, if you would like a copy of the step-by-step directions for keeping cells visible with Watch Windows in Excel 2007, just print this last page. Have fun with your Watch Windows!

More Related