CTPC logo CTPC logo

Background color changer

                             
CTPC logo CTPC logo

Toward a Better Computing Experience

Smart Computing magazine

Smart Computing Tip

Take A Shortcut In Excel

If you use Excel frequently, you're probably already familiar with many basic Excel keyboard shortcuts. However, there are some little-known shortcuts that can help you work even more efficiently in selecting ranges and moving around a worksheet. For example, you can quickly select an entire data region (a range of data cells bordered by empty cells) by clicking one of the cells and then holding down CTRL-SHIFT-* (asterisk). Another way to select a data range is to place your cell pointer in the range and then press CTRL-A; press CTRL-A a second time to select the entire worksheet. You can also press CTRL-Spacebar to select the column where your cell pointer is located. Another helpful keyboard shortcut is to press END followed by an Up, Down, Left, or Right arrow key to efficiently move the cell pointer to the outermost edge of a data range.

Save The Page

If you're using Internet Explorer and you come across a Web page with information you want to preserve, there are two good ways to keep the information without having to use a Web browser to bring it back up. The first and simplest way is to print it; it never hurts to have a hard copy of information you need. Another method is to save the Web page as an .MHT (Multipurpose Internet Mail Extension) file, which is essentially just a snapshot of the page. In this format you can send the page to others or double-click on it to open it directly. To make a .MHT file from a Web page, click File (press the ALT key to reveal the File menu if you don't see it), click Save As, and in the dialog box be sure to select the .MHT file type. Tell the computer where to put the file and click Save.

Here’s a tip not from Smart Computing.

www.ChangeDetection.com

This site provides a useful service that you might be interested in as explained on their website, www.changedetection.com:

  • ChangeDetection.com provides page change monitoring and notification services to internet users worldwide. Anyone can use our service to monitor any website page for changes. Just fill in the form below, we will create a change log for the page and alert you by email when we detect a change in the page text. We've been doing it since 1999. It's free.
  • A great way to know when we post new information on the CTPC website or other sites you visit regularly.

    Mike Alcorn, CTPC Editor


    Reprinted with permission from Smart Computing. Visit www.smartcomputing.com to learn what Smart Computing can do for you and your user group!

    Top of Page
    Return to TOC