strange function in excel

  • Thread starter Thread starter Majid
  • Start date Start date
M

Majid

Hi

i found a function which is {=TRANSPOSE(INDIRECT(O2))}, whenever i highlght
the cell i see it as =TRANSPOSE(INDIRECT(O2)),

i dont know how to add these brakets before (=) sign and after the equation

i dont know what exactly do they make.
the intersting thing is that i cant change the cell and i cant copy the cell.

whenever i copy and past it i get (#VALUE!).

the question:
i have been given axample in one cell, now i want to copy and past it to a
range of cells, how can i do it???
 
Majid said:
Hi

i found a function which is {=TRANSPOSE(INDIRECT(O2))}, whenever i
highlght
the cell i see it as =TRANSPOSE(INDIRECT(O2)),

i dont know how to add these brakets before (=) sign and after the
equation

i dont know what exactly do they make.
the intersting thing is that i cant change the cell and i cant copy the
cell.

whenever i copy and past it i get (#VALUE!).

the question:
i have been given axample in one cell, now i want to copy and past it to a
range of cells, how can i do it???
Click to expand...

Majid,
This discussion group is for the Microsoft database product, Access. You
need to ask in an Excel group.
Here's how to find an appropriate group.

As you appear to be using a web interface, try this:

http://www.microsoft.com/communities/newsgroups/en-us/

In the tree on the left, open English, then open Office and Desktop
Applications. In the Office and Desktop Applications
subcategory, find and open the subcategory for Excel, and find a group
there for your post.
 
Back
Top