I used to be able to hold down the shift key to bypass the auto_open macro in older versions of MS Excel, this does not appear to work in MS Excel 2007. How...

Thanks! I was getting flustered. "Dave O" wrote: Enter it like this: $1:$6 .... to indicate rows 1 thru 6.

We have a master excel file that I do not want overwritten. I always want it saved under a different name. How do I do this? Would I make it "read only"?...

Below is the formula I currently have. I want to get a "1" if the logical test answer returns a number not equal to 2-16 (a range). So if the number is less...

i have an excel file that i open in 2007 which contains images and text boxes. when i typed in the text box the typing is delayed and it appears excel 2007...

Greetings all - I have a sheet with 45,364 rows, consisting of four fields in two columns. IOW, A B 1 Name Smith 2 Account ...

I have a spreadsheet when 2500 rows of information, in one of the columns there is some data that should be in the next column. Is there a way I can find...

Column A is Resource Titles, such as Expert, Mid-level, Low-level -- with a seperater blank row then Onsite Resources. So Column A4 starts with Offshore...

Hi Boffins, I'm stuck :( My collegues take multiple plant readings on an oil rig, and enter them into several spreadsheets within a workbook. Each piece of...

I have not found it in these new iconic menus/ribbons.

I need to format or change the way my date values are entered in Excel. Currently they are 4/9/2009 - I need them to be 04092009. I created a custom format...

Currently, after I opened an Excel worksheet, if I click on another Excel worksheet to open it, it will be open within the same windows or Excel...

Hey guys, I need your wisdom as this is driving me mental: I need to compile a list of results for supplier categories. There are only 4 Categories...

Hello I want to extract the word or words before the " /" example the cell reads University of Texas/TX so I need to extract University of Texas . I...

I would like to know if anyone knows how to create a auto numbering formula in a cell so that when you open the workbook/worksheet each time it either...

I have list of cell that I am combining. I need some help in placing a RETURN so that the combined cells are on more then one like. example. From: Project...

I have some data, like this 090308 4213 090308 4213 090308 4213 090308 4214 that have interior spaces and I need them removed without removing the leading...

Hi, i have some issues to blanking the whole column. Let's say J1 to P28 is a set of value and J1 to J28 are months from 1 to 24th. If my key data is compute...

When I attempt to enter text as (c) it automatically replaces it with a small "c" inside a circle. How do i disable it from doing this?

I'm using the auto-filter option in my data base and need to count the number of cells (either numbers or text) selected and when I use the COUNTA function...