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...

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.

How to Split Multi Sheet Workbook Excel Into Single Excel File using Excelsplitter?

Work with hundreds of sheets in one excel file,instead of copying and pasting every sheet in a new file one by one.

Excel,how do i key in a function to fixed staff off's day on my excel sheet?

If you have the dates, You can use the weekday function to determine what day it is. Next you create some fancy compound formula like=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=7…