I am trying to link a group of cells that have no content, but that all have a blue pattern background into a new file. When I link the cells, zero comes up...

I have created a worksheet in which I would like to enter through cells. The worksheet has a series of questions where you type in the answers. The...

I currently have the following data in column A: Column A: 123-456-7890 123-456-7890 456-789-0123 / FAX:...

Hi, I have a file with a number of spreadsheets. I have a master spreadsheet with all the information I need on it, regarding personnel, their department, what...

Hi, I am having trouble trying to work out how to sum some non-contiguous ranges in Excel 2000. The data is on sheet 1. It is budget data for a number of...

I'm using the formula below to calculate the values in each row. Its not working and I'm stummped as to why. Note that there are blank cells in the ranges...

I have created a cell and added a diagonal line across the cell, from bottom left to top right corner. How can I enter data into the two divided...

I would like to apply Page Setup settings (margins, header/footer, etc.) to all sheets of an existing Excel file without going into each sheet. I know I can...

so I have an if then statement in a cell and it will not let me format the cell to center the contents. It adjusts to the left of the cell only. Thanks

Is there a formula for deriving the great circle distance between two points on the earth's surface when you have their latitude and longitude? The format I...

I have several large spreadsheets linked to other large spreadsheets. I looked in Help and found "Change the way a linked object is updated On the Edit menu,...

how do i create a cursor that at all times highlights the row/column that i am working in?

My spreadsheet looks like this A B C D E 1 ABC Wireless 500 300 50 2 Hi-Tech ...

I am using the following formula to look up a value (in column A) that has multiple corresponding values in column B. However, when I insert an additional row...

How do you add to a pre-existing drop down list?

With some spreadsheets, I get an indication of how many records are returned when using AutoFilter. But somketimes I get no such indication. How can I turn...

Need your help from you experts. Please give me suggestion how to fix the problem with my excel file. I'm not able to add or remove worksheet from my existing...

Does anyone know how to do this? Thanks -- rmccoy0025 ------------------------------------------------------------------------ rmccoy0025's Profile:...

I like the way that Page Break Preview blocks out in grey the rest of the worksheet that you're not using. I understand that in Page Break Preview, the...

Hi I need a code which allows me to locate a word (which is repeated numerous time which I am not aware how many) and once the word is found I need it...