My spreadsheet is quite huge. I am requested to generate reports using only some of the columns contained within the total data base. How can I configure my...

Hello Having problems with files being read only. Excel tells me the file is in use by another user, but i know this is not the fact. The document is stored...

I frequently print to different printers and I'd like to have different print buttons for specific printers so I don't have to always use "Print.....". Thanks...

My mind has gone blank. I have a Macro which I want to have run automatically every time I open any Workbook, but I have forgotten how to make it do...

Why won't a file (excel 97) from another PC open up and work on my laptop? I take a file from desktop PC to alptop (via a memory card) and double click on it...

How do I create a non printing watermark in excel? I saw a worksheet with each page watermarked with Page # where # is the corresponding page in that...

About a month ago, I was using Excel, and closed the program in the normal manner and everything was fine. I tried to open the program about an hour later (not...

i'm trying to create error bars but i don't seem to have "selected data series" in my format menu. can anyone help?

I have a workbook that has 6 sets of worksheets - each for a different user. I have protection on each worksheet that limits access to a range of cells. How...

I could not reconcile GETPIVOTDATA with a date format criterion, so I changed the dates (I only need the month) to text, i.e., Nov 03. However, this does not...

By VBA, How to know User has selected one or several entire rows orther than some cells? --- Message posted from http://www.ExcelForum.com/

I am not sure how do nest several functions together. Which would go on the inside first? If I wanted several IF statements together, how would I do that? ...

Sorry for all the posts, but i just found this forum, and i have quite a few issued i've been "working around" rather than finding answers to. this forum is...

I am trying to find out the difference between two dates. I want it in number of years, they are all actually between 1 to 5 years only. Do I need to keep the...

Is it possible to have 2 or more hyperlinks in one cell. For example, if I have a 2 number list in a cell, and I want to link one number to a worksheet and the...

I am having trouble converting a data type on a file that I received. It is supposed to display the date as mm/dd/yyyy, but it is formatted as a number. When...

I have the following table with fields "Name", "State", and "price": Name State price Mary OH 14.94 Mary OH 15.01 Joe WA 12.17 Joe WA 18.95

When I have a formula entered in a cell I want the back ground to change to a color. How do I do that with conditional formatting or is there a different...

I want to write a formula, say in cell E2 that picks the correct price based on valume Entered in Cell D1. Suppose I have a table set up with volume vs price....

cell C19 = product code drop down list cells N1:O449 = description of prod associated w/ dropdown list cell E19 = product description column cell I19 = price...