no row numbers or column letters DISPLAYED

Help! I have one document where I can't see my row numbers or column letters
on my spreadsheet. This makes it difficult to select rows or columns to cut
and paste elsewhere. Is there a way to display the column letters and row
numbers (not on printed output, but on monitor)? This document was created
by a former co-worker and I have to modify it every year. There are numerous
formulas and details to start from scratch.

<Tools> <Options> <View> tab,
And make sure to *CHECK*
"Row & Column Headers".

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"joelle" <[email protected]> wrote in message
news:[email protected]...
Help! I have one document where I can't see my row numbers or column
letters
on my spreadsheet. This makes it difficult to select rows or columns to cut
and paste elsewhere. Is there a way to display the column letters and row
numbers (not on printed output, but on monitor)? This document was created
by a former co-worker and I have to modify it every year. There are
numerous
formulas and details to start from scratch.

On the menu if you'll click >Tools >Options and look at the View tab,
there's a checkbox for "Row and Column Headers". Make sure that box is
checked- should solve the problem.

Joelle,

Look at Tools - Options - View - Row and Column headers. Should be checked.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"joelle" <[email protected]> wrote in message
news:[email protected]...
> Help! I have one document where I can't see my row numbers or column
> letters
> on my spreadsheet. This makes it difficult to select rows or columns to
> cut
> and paste elsewhere. Is there a way to display the column letters and row
> numbers (not on printed output, but on monitor)? This document was
> created
> by a former co-worker and I have to modify it every year. There are
> numerous
> formulas and details to start from scratch.

but for Office 2010 / Excel the location is under the Page Layout tab - Page Setup - Sheet tab - Row and column headings checkbox. Make sure this checkbox is checked to get the Row and column headings to appear on your spreadsheet (and if you have made it a Table be sure to change it back by doing the Convert to Range on the Table Tools - Design tab (Tools area).