I have a spreadsheet with some conditional formatting. How can I copy the appearance of the cells without the formatting condition?

I have a timesheet I wish to create. Below is the format I wish to send it out in. I need ot be able to sort final data by (employee, department, project,...

Is there a way to add a new entry to a right mouse click dropdown list? When I right mouse click on a cell in the drop down list of available commands, I want...

I have made a Line-chart containing 8 different series. I now want to change 2 of the series to Bars, but in the same chart. How do I proceed to pick the...

I want to do some kind of look up of a named range that will be equal to the name of the name the user selects. For example: if somebody chooses red from the...

Is it possible to disable the Save button automatically on the Excel toolbar only when a particular workbook is opened? I have problems with my forms being...

Guys Can you tell me if it is possible to filter rows identified by colour plz? If so, how do you do this?? Any help would be most welcome Thanks Dave

when rent+late fee = total amount paid so far, I want "paid in full" to equal "yes" This is pretty easy with if functions, but the next day my late fee goes...

Can somebody help me to make a formula for following? X a 45 b 15 c 40 d 35 e 60 f 100 g ...

Hi, I want that when i launch my userform the activesheet saved location is shown in a text box (textbox1) How can this be done? cheers steve

I want to have a way to print the sheet tabs only... If one has a number of sheets .. and each sheet tab a "label".. and you want to print them only or get...

How do I cause a count to increment when the spreadsheet recalculates (F9)? Every time I recalc the count gets reset back to 0. I have tried several of the...

I have upgraded laptop and Office software but cannot find the add in for Report Manager on this latest version. On 2000 it came on the disc, on 2002 I...

Hello all, new to this forum, hope someone can help me. Have used query within Excel for a long time to extract data from various SQL databases and tables,...

Using Conditional Formatting I was trying to do an end of the month check on a preceding cell date entry to control whether or not the cell after that one...

I know how to change a file location in Excel for the default location on the general tab. My problem is that location no longer exists, so I need to change...

Is it possible to change positive to negative balances through formatting? I have around 3000 cells that need to be changed to negative from positive.

Is there a way to strip the html in an entire column? I do it using regular expressions in access but not sure how to do it here. I guess if I knoew how to...

Im trying to right a look up which does the following Looks in an array which consists of 3 columns. If it finds two specifed values in the 1st two columns,...

I have the following sample information in one column. I would like to eliminate the three digit number at the beginning (and the space after the number) and I...