I want to center a tittle across the top of five columns. I don't want the heading to be separated by lines.

I am trying to fill column in sequence stepping ten each time. Ex. a10, a20, a30 If I put the sequence in the first two cells and extend down and click...

How do I define an array constant as a name? I tried to insert a name as follows Name: 2006!AgeRange Refers to: ={16,17-18,19-49,49} and it advised that the...

I don't know if I am using the correct terminology but this is what I want to do: I have placed formulas in multiple columns that calculate my sales numbers...

I have three checkboxes on a spreadsheet, yes, no, unsure. I want to allow the user to only click on one of these - how do i do that?

I have a sheet named "lookUp" that has 3 columns emp No Name Mobile No. 11111 Bruce, Jack lincoln 0404 126 561 and I...

Why is the merge cells function grayed out in a shared workbook? Anyone got a fix?

I'm working at a Marina and trying to make a comparison chart for different types of boats. I am trying to make a list, and based upon the users selection of a...

with out VBA can I create a combo box in Excel that displays 2 columns

Hello, Does anybody know which type of correlation is used by Excel's Data Analysis tool? Is it a Pearson correlation? Thanks for the help!

I have a workbook with financial information listed. There are several columns that I do not want people to see, so I've hidden them and protected the...

On the rectangular box along with the figure there is a green triangle ypside down. What does it means.

I'm moving a large amount of text from word documents to an excel spreedsheet, and I have a few questions: 1. When I copy/paste text from the document to the...

I want to keep text color from my excel file to a merged list. It seems to disappear (to black). How do I make sure the color transfers from the excel to the...

I am trying to copy a sheet in a worksheet but keep getting message that the name is already used as a formula or range. I cannot find this. And worse, It...

What I am trying to do is copy column A-D from "scheduled" worksheet to "test" worksheet if column X has an "X" in the column. Is this possible and if so how...

1- I want make a sub list in the excel. I make the dop down list in the cell A1 contain: Eua, Brazil, Ingland, Canada. And i want that in the cell B2 apeard:...

If text is input into some cells referenced by a formula I want the formula to ignore whatever text it finds and just calculate the result of the numbers in...

Well I'm full of questions today...I'm really starting to understand Excel and I'm enjoying working with it. I'm making a sheet that will keep track of...