hi if i want to do a "drop down",if thats the word, in a cell. how do i do ?. where do i start ? i want to make a drop down list in a cell, so i can pick from...

I am trying to print out some paperwork with borders in it and the cell borders ar not printing. I have tried everything and nothing is working.

I need to create a macro to sort 659 rows by 46 columns. The rows contain numeric values that need to be sorted for lowest (left) to highest (right). When...

In using Excle 2007, I am asked to convert to a new file format. for the most part I have complied since is a requirement at work. In doing so I have...

How can I put a formula in a cell that will give me a multiplication result with a variable criteria.In other words I have a product function in 1 cell then...

I am a beginner where excel is concerned. I have created a worksheet that has a running balance of my checking account, and I have been able to create the...

Hi, I posted a couple days ago in the general questions board on name mirroring. I've been searching for 3 days now, and any help would be appreciated. ...

OK, need help with the following: Mod(10e+11;97) returns #NUM!, anything higher it blows. But if I use Mod(n;d)=n-d*INT(n/d) I can go until Mod(10e+15;97),...

I cannot format excel 3 to print gridlines even after meticulously following all formatting instructions.. Has anyone had and found a way around this problem...

Hello I would like to use a macro to name the sheets in a workbook. I want the tabs to be named Jan & year through Dec & year. I know I don't have to ask if it...

Given a column of numbers, is there a formula to return the number of cells containing a non-zero value? ie. Cells can be empty, contain zero, or contain a...

I have a shared document that needs to be set up so that individuals can access only the worksheet for them (no others) as well as protected cells within...

I have a large table, 5 columns by about 1200 rows, populated with sequential numbers. the numbers are ordered smallest to largest, left to right and top to...

my formulas aren't recalculating in excel. (i used to be able to copy and paste and change numbers and it would recalc) the formula is correct when you look...

This is what I'm trying to do: =Sum(A1:D1) with the result being in A5 - Now I want to copy or drag, so I don't have to keep retyping, the formula in A5 to...

I have created a workbook template where I have a 'master' page for an Order Acknowledgment/Confirmation for a Purchase Order for items that are purchased...

I am trying to create my own invoices - however I'm having no luck with generating new invoice numbers. For instance I process invoice 001 and save, followed...

How do i count the number of cells in a column that do not contain a certain word or words.

When I try to change cell formats, there's a pop-up coming up; "Too many different cell formats" . I have tried to clear some not importent sheets with...