How to Use a List of Options in Excel on a Different Sheet?

Answer Microsoft Excel Data Validation can be used to make drop-down lists. These lists can refer to a single cell or a range of cells. This range can be present in a different worksheet within the same w... Read More »

Top Q&A For: How to Use a List of Options in Excel on a Diff...

Find date on different Sheet in excel and perform some actions?

As long as the dates in column A are really in the MS-Excel Date data type (and not plain Text), then the DATE() function may be used to obtain the current computer date and compare against a cell ... Read More »

How do i print addresses from a microsoft excel list onto an avery lable sheet?

First, make sure you have a header row for the titles of your columns in the Excel sheet. Then, go into Word, and use Tools->Letters & Mailings->Mail Merge. This will bring up a wizard in the rig... Read More »

Excel on Mac: I only have access to a limited set of options (not Chart Options or tradeline) What can I do?

Find someone that has a PC with Microsoft Office installed on it.Then use their MS-Excel application which will have everything you need, and probably quite a bit more.

Excel 2007: How to Import Data From One Excel Sheet to Another?

In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just one of the many programs that is capable of creating and working with ... Read More »