What's New on Excel2007.Tips.Net

The following are the newest excel2007-related articles on Excel2007.Tips.Net. Click the article's title (shown in bold) to see the associated article.

Stopping Help from Using Online Resources. Excel relies upon the Internet to grab help information. If you don't want Excel to seek help online, you can configure the program using the information in this tip. (February 03, 2009)

Using Data Validation to Limit Data Entry. When creating a worksheet, you may need to limit what can be entered into a particular cell. Using data validation you can easily limit input to numeric values within a certain range. (January 29, 2009)

Using AutoComplete. Entering data in a worksheet can be time consuming. One of the tools that Excel provides to make entry easier is AutoComplete, described in this tip. (January 27, 2009)

Specifying Vertical Cell Alignment. Excel allows you to adjust not only the horizontal alignment of values in a cell, but also the vertical alignment. This tip shows how. (January 22, 2009)

Shading Odd and Even Values. You can use conditional formatting to add shading to various cells in your worksheet. This tip shows how you can shade cells based on whether a value is odd or even. (January 20, 2009)

Arranging Windows. Got a lot of workbook windows you want to arrange? It's easy to do if you start by using the Arrange or Arrange Windows dialog boxes. (January 15, 2009)

Getting Rid of Insert Options. When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Here's how to get rid of it. (January 13, 2009)