Numbered Rows and Columns

K

kc68

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
 
D

David Biddulph

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.
Click to expand...

Tools/ Options/ General
Uncheck "R1C1 reference style"
 
N

Niek Otten

Hi Ken,

Tools>Options>General tab, Uncheck R1C1 Reference Style


--
Kind regards,

Niek Otten
| 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
|
 
Top