Excel2003 ... Range H14:DC120 contains Formulas I wish to Protect. Cells in Range are "Locked" ... WorkSheet is Protected. Issue ... During Protection if I...

I use Excel 2007. I have a huge page number in the middle of my worksheet. It covers about a dozen cells and is dark gray. It is apparently not in the...

Hello, Is there a trick to preserve the formatting (ex column width) for pivot table cross 'Refresh Data!" option ? I've setting up several pivot tables...

Hello, First let me say that the problem at hand is very difficult to investigate if you don't have multiple virtual machines to play with and roll back when...

Hello, I'm viewing an .xls file in MS excel 2007 that contains a large formatted table. When I insert a new copied row, my data in other cells disappear. To...

Hi everyone, I'm trying to find the back transformed values of my log10 transformed standard error values. The mean is 4.5857. I did 10^4.587 which gave me...

Hi all, i have a worksheet with 'col A' a list of dates and 'row 14' a list of names. under the names appears the text "late" to line up with a date. I have a...

I'm teaching a college course and would like to convince my students that Excel is used by "regular" business users, that is, accountants, salesmen and...

I have a list of names in cells A2:A30 and in cells B2:B30 I need to enter £ for example money paid each week. I need on a seperate worksheet (sheet2) a...

Dear, I need you help in creating some excel macros and assigning to a command button for running the macro. I have used the formula =Today() for getting...

I've seen ways to do this with conditional formatting (http:// www.cpearson.com/excel/banding.aspx), but I'd like to do it with VBA. How do I modify the below...

Excel 2007 I am using the following formula; =VLOOKUP(C14,Sheet2!$A$1:$C$295,3,FALSE) but I do not want #N/A to show up in the unused cells - can i hide this?

I've had two workbooks just disappear today after I worked on them. They are not in the original folder. One just had data in it and it was fairly easy...

I have A1:A5 which typically fill with data in a sequential manner, i.e. first A1 would contain a value, then A1 & A2 would contain values, then A1, A2 & A3...

how can i nest more than 7 IF funcyion in formula bar in office 2003 ?

Recently all my spreadsheets column heading have changed from letters to numbers. Could anyone explain why this is and how do I change it back to how it was.

Hi all I have the following criteria: planned = 4; 1 hour above planned = 3; 2 hours above planned = 2; 3 hours above planned = 1 I need a formulae to...

Using OL'07, I have special-selected a range which is only numbered formulas (goto, special). I now have the range. I need to scroll through cell by cell,...

ok i have a list of people from 1st, 2nd and 3rd shifts. I have a drop down box to select the shift(A2), and a drop down to select names(B2). One workbook...