You are here: Home / Archives for December 2009

How to install and load the Analysis Toolpak in Excel 2007

December 27, 2009 By admin Leave a Comment

To install and load the Analysis Toolpak in Excel 2007 follow these steps:

  1. Click the Office button. XL7OffButton
  2. Click Excel Options, the Excel Options window will open.

    3. XL7Addin1

  3. In the left pane of Excel Options click Add-Ins, The right pane will show a list of Active and Inactive  Add-ins.
  4. At the bottom of the right pane there is a combo box (drop-down) labeled Manage. Select Excel Add-Ins from the drop-down then click GO. The Add-Ins window will open.

    5. XL7Addin2

  5. In the Add-Ins window select the check box that says: Analysis ToolPak, then click OK.

Filed Under: Customization, Excel 2007, General Tagged With: Customization, Excel 2007

Hide rows based on cell value in Excel 2007

December 18, 2009 By admin Leave a Comment

To hide rows based on cell value in Excel 2007 follow these steps:

  1. Prepare your data including a header row.
  2. In the Home tab, Editing group, click Sort and Filter then select Filter from the menu.
  3. Your data will now look like this:

XL7HideRows1

In this example we want to hide rows where the sales are greater than or equal to 2000. I.e. we will only show rows where the sales are less than 2000.

  1. Click on the filter arrow next to Sales.
  2. Point to Number Filters and select Less Than.

    3. XL7HideRows2

  3. The Custom AutoFilter window will open.

    4. XL7HideRows3

  4. Enter 2000 in the Combo box to the right and click OK.
  5. Now all rows with values greater than or equal to 2000 will be hidden. Here is the final result:

XL7HideRows4

Note:

If your data is text then you will see Text Filters instead of Number Filters in the menu.

Filed Under: Data, Excel 2007 Tagged With: Autofilter, Data, Excel 2007, Excel help