Column Headers are numeric as the Row Headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A co-worker opened an existing workbook she authored. She noticed that all of
the Column Headers were numeric, like the Row Headers. All worksheets within
the workbook are like this. With this arrangement, she cannot enter formulas
because of the conflicts in range/cell identification. I checked out the
'Options' under the Tools dropdown and there wasn't anything in there that
looked 'abnormal". Any ideas or suggestion?

Thanks!
Mark
 
Tools/options/general tab remove the tick in the r1c1 reference
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Your welcome

There are soooo many options they are easy to miss
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top