RNW wrote:

In Excel 2007, I used "format as table", but now I need to turn if off. ... How do I turn it off??!![/quote]

Thank you for the suggestion, "Design, tools, Convert to range." That does most of what I want. Oddly, it leaves me with a spreadsheet with no grid lines. Even though I turn grid lines On in the view tab, the spreadsheet, which was converted to a table, then back to a standard range, has no grid lines.

How would I make the grid lines visible after using "Design, tools, Convert to range"?

Thank you for any help.

Lee