Column Headers are numeric as the Row Headers

M

Mark Bursian

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
 
J

john

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)
 
M

Mark Bursian

Excellent! That worked perfectly! I overlooked that option. Thank you very
much.
 
J

john

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum and Dmax with structured references 1
Copy Columns based on Header name 1
Sort on 3 columns when number of rows vary daily 1
Lookup values based on column headers? 5
Returning Column Header based on Row and Value 3
Selecting header rows with macro. 1
Import errors importing Text into existing table, header vs no hea 3
how to assign a table row as a header? 1

Top