excel tips

Quickly inserting the time into the current cell.

To quickly insert the time into the cell that is currently selected in Excel, simply press Ctrl + Shift + ; (semicolon)

Having Excel automatically enter consecutive numbers.

You may want to enter consecutive numbers in a row of cells. Excel has a nice feature that will do it automatically for you. To do this:

  • Enter the first number of the string into a cell.
  • Press and hold the Ctrl key.
  • While the Ctrl key is pressed, click the cells fill handle (the small black square) and drag it over the range in which you want it to fill in consecutive numbers automatically.
  • Let go of the mouse button.
  • Let go of the ctrl key.

Now, your consecutive numbers will be automatically filled in.

Accessing the Internet directly from Excel.

If you are working in Microsoft Excel 97 and need to grab something off the web, don’t waste time opening your browser, let Excel do it for you. To access the Internet directly form inside Excel:

  • Click the Web Toolbar button from the Standard Toolbar.
  • Now, you can either click search the web or type in the URL of your choice into the text box.

Press Enter and Excel will connect to your Internet Service Provider, open up your browser and bring you right where you want to be.

Quickly pasting in Excel.

To quickly paste something in Excel, select the range of cells you want and copy them by pressing Ctrl + C. Then, move to where you want to paste and press Enter.

Basic keystrokes for getting around Excel.

Here are some basic keystrokes to quickly get around Excel 97.

Enter Move down to next cell
Tab Move right to next cell
Shift + Enter Move up to next cell
Shift + Tab Move left one cell
Alt Select pull down menu
Ctrl + Tab Cycle through toolbars
Ctrl + Shift + Tab Cycle through toolbars upward
 

Creating shortcuts to Internet sites.

To make a shortcut to an Internet site, simply drag and drop its link directly onto your desktop.

Who can read cookies?

You might think of cookies as a security threat. Only the issuers of the cookies can read them. Other sites cannot read them.

Using the Start menu to access websites.

You can access a website simply by using the Run feature from the Start menu. To do this:

  • Click the Start button.
  • Click Run.
  • In the Open field, type the URL of the web site you wish to go to (For example, http://www.anysite.com.)
  • Then, click OK and your default browser will load the specified website.

Running the grammar check in Word

If you want to check the grammar of your Word document, you have to choose what type of checking you want to have done.

  • Go to the Tools menu in the toolbar, and pick Options.
  • Then select the Grammar tab (at the top of the screen).
  • Then you have to click the down arrow that is to the right of the Use Grammar and Style Tools list box to view the lists.
  • You can now choose the type of testing that will correspond to the type of document you have.

More about VBiz services >>