ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i change the top line of worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/219595-how-do-i-change-top-line-worksheet.html)

sahara

how do i change the top line of worksheet?
 
can some help me please as my 20 mth old son as done something to change the
top to numerics from alpha, how do i get it back

muddan madhu

how do i change the top line of worksheet?
 
go to tools | options | general tab | uncheck R1C1 reference style |
ok


On Feb 8, 12:01*am, sahara wrote:
can some help me please as my 20 mth old son as done something to change the
top to numerics from alpha, how do i get it back



John[_22_]

how do i change the top line of worksheet?
 
Hi Sahara
Goto ToolsOptionsGeneral and unselect R1C1
HTH
John
"sahara" wrote in message
...
can some help me please as my 20 mth old son as done something to change
the
top to numerics from alpha, how do i get it back



Rick Rothstein

how do i change the top line of worksheet?
 
Go to Tools/Options on the menu bar, select the General tab on the dialog
box and uncheck the "R1C1 reference style" check box.

--
Rick (MVP - Excel)


"sahara" wrote in message
...
can some help me please as my 20 mth old son as done something to change
the
top to numerics from alpha, how do i get it back



sahara

how do i change the top line of worksheet?
 
thank so much, knew it had to be something simple

"sahara" wrote:

can some help me please as my 20 mth old son as done something to change the
top to numerics from alpha, how do i get it back



All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com