My spreadsheets open with numbers both along the rows and at the top of
the columns. I was copying and pasting a pivot table when this
occurred (it has happened before). I tried a number of solutions, even
to the point of shutting down the computer and opening an empty
spreadsheet. How do I solve this problem. Thanks.

Ken

Go to Tools, Options, General Tab, and uncheck R1C1 reference style.


" wrote:

My spreadsheets open with numbers both along the rows and at the top of
the columns. I was copying and pasting a pivot table when this
occurred (it has happened before). I tried a number of solutions, even
to the point of shutting down the computer and opening an empty
spreadsheet. How do I solve this problem. Thanks.

Ken

wrote in message
oups.com...
My spreadsheets open with numbers both along the rows and at the top of
the columns. I was copying and pasting a pivot table when this
occurred (it has happened before). I tried a number of solutions, even
to the point of shutting down the computer and opening an empty
spreadsheet. How do I solve this problem. Thanks.

Tools/ Options/ General
Uncheck "R1C1 reference style"
--
David Biddulph

Hi Ken,

ToolsOptionsGeneral tab, Uncheck R1C1 Reference Style


--
Kind regards,

Niek Otten
wrote in message oups.com...
| My spreadsheets open with numbers both along the rows and at the top of
| the columns. I was copying and pasting a pivot table when this
| occurred (it has happened before). I tried a number of solutions, even
| to the point of shutting down the computer and opening an empty
| spreadsheet. How do I solve this problem. Thanks.
|
| Ken
|