I know that you can create drop down lists in Excel but I forgot how to do it. Is there anyone that can refresh my memory on this subject? Thanks,

I am trying to refer to various cells in sheet1, I can click and point to most cells but several cells when clicked in do nothing. I checked formating and...

Can anyone help me do this when the range is across worksheets? I have a worksheet for each month, each row in an invoice with the amount in column I and the...

I am working in a excel program that I DID NOT create. However i would like to have the bottom Sheets hidden and i want to create a button on the home page...

I have an Excel 2007 spreadsheet for mileage & fuel gallons on the same worksheet. Mileage is formatted as a whole number. Fuel gallons I want formatted with...

I have created a spreadsheet for a schedule and I would like the dates to up date on there own instead of manuallly changing them every schedule. Is there a...

I have been keeping monthly spreadsheets for a small home business and have always inserted rows and added more Dates and finances to the sheets. Today, I...

I have a heading in column A. There are several transactions listed in columns B,C,D etc. (there are several rows of these under each column A heading) I...

Hello all! Does anyone know how I may be able to search a string and extract text from it using the MID and FIND function with multiple FINDS? I have a...

I know I have seen this before so please excuse me for requesting it again. But how is a watermark inserted into an excel worksheet... Thank You in Advance for...

I am trying to do an if/then function to see if there are duplicates on 2 different sheets in a table but cannot find the function which is correct. First...

I am struggling with a spreadsheet listing 50 presentation start and stop times and duration. I need a formula(s) so when a duration for a presentation...

I am trying to insert a date and time in a column to indicate the date and time the information in a row is being entered. I set up a macro to insert date and...

Is there anyway of naming cells in a worksheet? What I am trying to do is within a worksheet be able to put in an amount and call that amount brand or...

Is there a way to look in a cell and find a particular string of data and categorize that as "TRUE" if the string is found and "FALSE" if not? I've tried...

Good morning... I have a workbook that I have saved as a manual calculation which does NOT save before closing. I had to set it up this way because I have SO...

Is there a way to set up a spreadsheet so that it will copy one worksheet from one workbook to another without having the difficulty of losing formats? The...

Hello all: I need to rearrange my columns into rows. I've got column headings like this: Heading1 - Heading2 - Heading3 - Heading4 Data1 - Data2 -...

I need to create a workbook that will play a .wav file then automatically close. Is there anyway to do this without having "Enable Macros" dialog box pop up...

for example 100 A-B 7 C-D 56 A-b 65 A-b