Excel Spreadsheet question

jeffiepoo
jeffiepoo used Ask the Experts™
on
Hey guys,

In Excel, I can make a table look really cool using the "Design" Tab. Unfortunately, I didn't make it a table before I inserted all the information into excel so it is not in a "table" (isn't excel a huge table anyway), and I can't make it look cool using the design tab! Please help me out. I don't want to make a table and re-insert everything. And I want that Design tab to make my table look cool! Thanks for any help!

-Jeff
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You do not have to reinsert everything.

Create the table format using the design tab.

Then copy the data and paste-special in the table with the option "Values".

Author

Commented:
I don't have a design tab!
You can try

Format > Autoformat

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial