Sorry to doubt what you way, but I don't think it is possible to have row headings without column headings.
Maybe you have row numbers in column A?
Or maybe the window of the worksheet is not maximised within the Excel window and the title bar and column headings are above the visible area of the Excel window (though I can't find a way to make that happen).
You don't mention which version of Excel, it always helps.
In excel 2003 or earlier try:
Window > Arrange > Cascade
Tools > Options > View > Row and Column Headers
In 2007 or 2010:
View > Arrange All > Cascade
View > Headings
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
I just figured it out. The person who created it had splt the screen and I couldn't see it. Thanks for your help.