I am using VBA to find a specific value. The problem is that humans have not used the standad form and have changed the thing that I want found. I want to...

the setting in Tools==Options==Calculation (Automatic or Manual) , can it be applied to a single worksheet within a workbook or at least single...

I have some data that contains some noise, then good data then noise again. I need to know how to perform a calculation on the good data while ignoring the...

I'm trying to set-up a one page form with 3 separate sections in Excel 2007. I want to be able to adjust the row and column sizes independently in each of...

In my Excel 2007 workbook the Get External Data buttons are grayed out. Why are they disabled and how can I enable them? I am in Compatibity Mode.

How do I stop cells with no data entered, from showing the formulas as it looks untidy. Can I have the cells clear until I input the figures? Many thanks, Dave

Hi everyone. Um ... I recently installed my Office 2003 sp3 Small Business Edition software to my new computer. (Vista 64 bit, Anthalon x2, 8 gigs Ram, 500...

How do we convert positive numbers into negative ones under one column?

I have created a spreedsheet with a formula in CELL G133, which enters a text sring contained in another Cell(s) dependant on the condition (result) of a...

1+3+5+7+9+11+13+15+17+19=100 Choose 5 numbers from these 10 figures so there sum is = 50

Hi folks. I've attempted to copy an email address to the clipboard then paste it directly into a cell within Excel. For some reason today Excel starts to...

I exported some data from a program I use at work. the whole spreadsheet has cells filled with percentages that I can't format, add together, etc.. I try to...

How do remove the graph paper in the backround of exel?

Hi, I have a database with IP address and hostname of a server. Now the problem here is some of the servers are running in cluster and have duplicate...

Does anyone have any suggestions on how to display the current directory for existing worksheet in cell A1? Thanks in advance for any suggestions Eric

Hi Folks, Apparently my display name has changed, where do I go to change it back? TIA, SD

I'm trying to do conditional formatting for an entire column of times, to show the time in red if it is outside of a range of time. Column D, E and F all...

I have a worksheet that I've imported a report into (useing docview, if it matters)... The report consists of building reserve locations and any items that...

Hi, Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data...

I want to format cell A1 to turn red if the date in cell A1 is not within the current or previous quarter date specified in cell B2 with:...