Selecting a preset format

[tomlinsn]

Hello,

Working in Office 365 I am looking for how to format a table area in my worksheet without having to convert to a table. There used to be options that would allow you to pick preset formatting for your worksheet, but can't locate. I like a format in the Format as a Table, but don't want it to be a table.

Thoughts appreciated.

Thank you,
Tom

 

[tomlinsn]

I discovered that I can select Format as Table, select format desired, then convert back to text. Formatting preserved.

Hope this helps someone else.

Best,
Tom