Freezing and Unfreezing Excel Panes

  Freezing the Panes Occasionally a worksheet is so large, you cannot view the column or row headings and all the data at the same time. When this happens, it is difficult to view the headings for the data in the worksheet. For example, in a worksheet containing...

Using the VLOOKUP Function in Excel

You can easily create a function to look up information! The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and...