I have two columns of data as follows
1       teama
2       teamb
3       teamc

I have made a table with orientation from right to left.
Now I want to change the direction, in other words I want to reverse the
direction of table.
Is there an easy way to do this job.

Would it be possible to audit a reference to a cell in another sheet with
the Tools Audit and get the exact cell location ie: Sheet2!C23.
scooper

Greeting all.
I have a table with two columns -
Medal Name - Monarch
Column 1 has the data entered.

Hey guys
It annoys me that I constantly have to ajust my prints to 1 page tall/
wide by using the printing tools, and put my self together in
intention to program a little piece of macro that will give me joy and

I have 2 columns. in column A I will enter a name. in column b I will enter a
number from 1 to 10. The names are not entered in the order 1 to 10 but
randomly. Example I can enter number 5 then 2 then 9 then 1 and so on. How
can I track the order in whick I names are entered. Can ...

Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

how can I insert image to the cell, preferably from the clipboard?
when I paste from the image in the windows clipboard, the image is
layered. I mean the image is not in the right cell.
how can I insert the image into the CELL?

I am trying to make a following conditional formatting
Change the color of a cell in a range, if its value is maximum of the range.
The maximum value of the range is calculated through
Tools/Data/Analysis/Descriptive Statistics, which I have not reside in the

how do i perform student t test for scientific experiment to compare between
control and tested groups

If anyone out there knows how to put a medical spell check on excel 2003 that
would be great! Thanks

Windows XP ,Office 2003
I have designed a form in which certain cells are protected.
In some rows there is more than one unprotected cell, in others, only one
unprotected cell.

In Excel 2007, when I have added a Page Header to a spreadsheet, it has told
me that Page Layout view is not compatible with Freeze Panes.
Is it not possible to have
(a) Frozen Columns/Rows while in Normal mode, AND

In my column A, I have duplicate data. I known that I can use the
advanced filter and put unique values, but I need to do it with a vba
code, until now it's everything ok!
But I don't know how I will exclude the line of the duplicate data,

I need to execute some code in worksheet_change then I did it:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
Call return_accounting_code