I hope you can help me with the following task below. I am struggling with the second part of the question but i will be happy for assistance on both. A...

Rick Rothstein and I had similar experiences recently: posting responses that failed to appear on the MSNews server. Of course, there can be many factors...

Why should I use templates and not, for instance, a read-only workbook? What are the specific advantages of templates in terms of ease of use, protection of...

I have a problem that when I copy some cells from a 97-03 workbook to another 07 workbook, the excel consider what I copied as an object. Besides, the pasted...

Hello, If I clicked on a square/cell how could I get it to color a 4 X 4 cell "8 cells all together" area with the cell that was clicked being the bottom...

View lengthy text from one cell to another cell without widening cell width of the other cell I used the = sign to display a long text in cell A1 in cell H1...

I've used Excel 2003 on my XP computer for a number of years. In the course of time, I created several macros with associated buttons, to perform certain...

Hello, I have an 'addin' (Autochart) in one of my workbooks that I want to use with a different workbook. Do I have to re-load it into the 2nd workbook, or...

After the formula in a cell has calculated a value I would like to reset the cell for the next use by deleting the value but keeping the formula in the...

My problem is that when people send me an excel file which was created with Vista Excel I can't open it up with my older version of excel on my desltop unit....

Hello ! I'm running Excel on a Portuguese Windows XP system. I'm trying to create some array constants but haven't been able to do it. As for VERTICAL...

Am trying to get the agedays based on today and 20th dec , excluding weekends( Saturday and Sunday) , Can some help me quickly

When I do a page preview, each cell in the worksheet appears as a separate page, and when I try to change the page layout, I can not get past a "margins do...

Hi I have a named range, called Servers (B2:I50). Within this range I want to count how many entries begin with New, so figure I need to use Left somehow, but...

Hi Is it possible to change the background and foreground colour frm the standard grey and black to say white and red? Thanks

Can you make a drop down list appear within your original drop down list? I have a list of items: box, ball, aplle, scissors, stalper. (for example) and I...

I'm pretty uneducated on excel but am trying to develop a master list of coded infomation that I can simply type a "code number or item number" which will...

How can I limit input of A1 to a specific date format i.e. dd.mm.yy From cell A1, I would like to extract the month and display as mmm in cell A2 Thanks

while attempting to access an Open XML format based spreadsheet we get the error message: “Microsoft Excel has encountered a problem and needs to close. We...

dear as we mail merge in word from excel, can we mail merge in coral draw from excel, My data is in excel. pls help, its urgent