Microsoft Office Tutorials and References
In Depth Information
Important Tools for Any Business
Transposing Tables with Formulas (without Absolute
There are many occasions when you’ll have tables that reference lists of information and the
formulas don’t have absolute referencing. Now, in the likely event you’ll have to view the
information in a new format, you may have to spend countless hours applying an absolute
reference to all the formulas—or you can use this undocumented trick. Select the region with
the formulas as shown in Figure 2.15. From the Edit menu, select Replace. Under Find what
type . Under Replace with type < .
Select the region
with the formulas to
transpose the table.
Select and copy the entire table to transpose the table as shown in Figure 2.16.
Copy the entire table
to transpose the table.