Hi there, I am experiencing this in Excel 2007 or it's just too blud-e early in the morning to realize my own stupidity. I am trying to add a hyperlink to...

Hello, I would like to reference a cell for data, however if that cell is blenk then look at the next cell, etc. For example: In P1 I would like to...

Hello all, I want to pull cells from 10 Excel files on pc into one new file. Can I do this with a simple cell reference to the path and filename where the...

I am using Excel 2007 (thought I posted this earlier, but can't find it - even with google group search). I need to sort an inventory list according to the...

This is not an Excel question but I know there are experts here who I know will provide an answer. There is an estate of a deceased person to...

I have a two page excel worksheet, I always want the first page to print, but if there is a lot of information and the second sheet becomes active, I want...

Is there anyway to lock the content, format, and formula -separately or jointly- of a given cell? If so, how

I know how to split cell contents to columns, but how do you tell excel to take the cell contents and insert into new rows. Each name is separated by a...

Can you freeze in two direction in excel, along rows and colums?

Hi All, I do not know how below copy-paste will show on the post, but I will try to depict the question in self-explanatory way, so you will gatch what's my...

I have a large excel file with 12K records of companies, addresses., etc I want to eliminate duplications where company and city are duplicated but not...

I am trying to share a workbook with colleagues. Review/Share workbook/click additional users. Unfortunately, everytime I click additional users, i receive...

Hi Guys I got one for you. I have a sheet that I record football match results in, by entering a score in one cell like this: 1-1 or 2-1 or 2-2 I have a...

I want to enter data in a cell in sheet1, data entered will accumulated in sheet2 every time I save. Thus, a summary table is created in sheet2. Is this...

In Excel 2007, I need the to add data from column L's cells 2-93 with the data from column M's cells 2-93 and have it total in Column N's cells 2-93. I'm...

I have a table with 2 by n entries. On the 1st column I have continuous values on the 2nd they're random. I want to search the minimum value on the 15 entries...

I have an e-mail box above worksheet - need to make it disappear.

Hi, I was hoping someone would be able to assist me. I am looking for a formula where if I6G6 then 0 BUT if I6G6 then I6-G6. Basically if I6 is greater...

Hello Can anyone help on this small query. I want to enter a year in a cell in this format "2006/07" I have several cells linked to this which will then...

Is there a way to alphabetize worksheet names in a workbook without having to manually move each one?