Just moved from Excel 2003 to 2007.
On an existing worksheet I was able to insert a row, now 2007 tellm me
"cannot move objects off sheet"?  Have tried cntrl end then going to a1 and
saving, but to no avil.  Have check worksheet for data past the cntrl end and

People,
I thought I understood that the text wrap limit for any given cell was
1024 and indeed when I look at the specification for Excel, it states
that only 1024 text characters will display in a cell. However, I have

Is there a way to filter out all the values in a column that only appear
once, leaving just items that appear 2+ times? I know there's a way to get
rid of duplicates, but I haven't been able to find a feature that would do
the opposite. Thank you for your insight!

I have data on a template (Sheet1) and I need to output some data to a
summary table (Sheet2).  On Sheet1, every 7th cell (starting with A2)
is the cell I want (i.e. non-contiguous) and I want to populate these
values into Sheet2, starting with B2 and continuing contiguous (i.e.

I have just used some vlookups to find some information on a Unique
ID. Unfortunely each week a few of these ID's are delelted and some
are added- so a vlookup can not find information pretaining to them.
The good news is that the data is sorted in such a way that when a

I have just used some vlookups to find some information on a Unique
ID. Unfortunately each week a few of these ID's are deleted and some
are added- so a vlookup can not find information pertaining to them.
The good news is that the data is sorted in such a way that when a

I have a seating chart for a group of students. I want to show each first
and last name in a single cell in the following fashion, without changing
the font size or cell length.
Last Name,

Is there a way to format a cell to display twelve alphanumeric characters to
look like a MAC address?
For example, if the cell contents are:  0003FF411153
I want it to display like this:  00-03-FF-41-11-53

I am looking for a formula to count unique occurances of column (A) where
column (B) equals a certain value.  Any help would be appreciated.
I have the formula
=SUMPRODUCT(('data'!A3:A6<>"")/COUNTIF('data'!A3:A6,'data'!A3:A6 &"")),

I am using the following formula (and varients of it) to produce a table
showing the top two and bottom two locations (the place names and their
relevant percentages):
=INDEX('Q4'!H5:H36,MATCH(LARGE('Q4'!H5:H36,1),'Q4'!H5:H36,0))

I am trying to rank order a list of numbers, so that I can use them in an
Offset functions.
I am aware that I have some duplicate ranks in my data and have therefore
used the following formula to try to take account of these duplicates:

Is there anyway to find any line that has a + in it and delete that whole
line?!
I'd also like to do the same for *.
I have a list of about 1300-1500 names and addresses. Some of them have a

hi everybody there,
I have a workbook containing multibple worksheet said 35 sheet. I want
to see all of them at a timem so dont bother myself scrolling across
them.

I have a sheet with 10 columns and several hundred rows. How do I (in Excel
2007) highlight the highest value in each row. I know I can apply
conditional formatting to each row individually but this would take far to
long and is impractical. Any help would be greatly appreciated.

Runtime Error in Excel 2007    
Everytime I open a .xls file I get a message that says Runtime Error
R6025-pure virtual function call and when I click OK the program closes down.
Unable to work on any files. I have installed all the updates available.