I have linked sheets in a workbook, when i go to edit a worksheet i get the message to "edit worksheet" option come up as normal, but i also have "edit links...

I was wondering if someone can help me. This task may be simple for some, but I'm having some trouble. I have an Excel document, and it isn't "too" complex,...

Does anyone know of a way that I can replace a portion of a formula throughout a worksheet without changing the other part? I have been able to find the...

I create schedules in excel for four different clincal sites. I change the header on the schedule save the file and e-mail to the instructor. when the...

I want to multiply column B by 5 if Col A is not equal to Red or White or Blue. Column A can have 100 distinct values and Red or White or Blue can be 20...

I apparently have done something that when I go to print, the area which is printed on a page does not change, only the size of the page. ie; in the print...

Hi, I'm doing a Excel 2007 VSTO template where I load a worksheet with between 10.000 to 15.000 rows of data, and was counting on using the built-in excel...

Hello, MS EXCEL 2003 on XP PRO. I have a couple of simple files used for upload to an access database (they are external linked table). They are very...

I have several thousand Material Description entries that contain a mix of text and numerals. For example: Gasket, high-melt, DLL84848 In the example I...

I just upgraded to excel 2007 but I still can't figure out what I need to do! I need to come up with a way to count non-blank cells by font color. I have a...

Hello, I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have...

I want to create a pop-up box that displays a range of cells when a macro button is pushed. Any input would be appreciated.

i installed the camera icon on the QAT last week and experimented with it. got the message "The picture is too large and will be truncated". Now i get that...

I’m trying to use the conditional formatting, traffic light feature with dates and am finding the new Edit Formula Rule app to be rather limiting. Hopefully...

Using Excel 2003 Is there a way to hide the formulas, but still be able to make changes to the cells without the formulas. I followed the below instructions...

I am developing a work book. I find that when I insert a value in a cells, nearby cellsm, with no direct or indirect connection, change. What do I need to...

I have a simple spreadsheet and have inserted a small picture (original file is about 12kb) When I print I get everything printed except the picture. How can...

I have data that is being exported into Excel from a bank database. I'd like to use a sumproduct formula to establish totals, however the exported data is...

How do you make the cells remember - Like I start to type 'Phoenix' and the word just pops in like it remembered the word. Is this random or does it have to...

I want to import and display up to 100 addresses (within a three county area) on a map that I can enlarge and print to a plotter. Can this be done with...