Forum home » Delegate support and help forum » Microsoft Excel Training and help » Format as table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Format as table
Resolved · Urgent Priority · Version 2007
Reply Mon 14 Mar 2011, 09:44Delegate Sandra said...
Sandra has attended:
Excel Advanced course
Excel Advanced course
Format as table
When I format my cells as a table it puts an additional row at the top of my cells and calls them column 1, column 2 etc. I have to put blanks in not to show them. How do I get rid of them, or set the settings for format as a table, with out getting these headings?
For upcoming training course dates see: Pricing & availability
RE: Format as table
Hi Sandra,
When you format cells as a table, you get prompted with a question about whether you have headers. You say no, and Excel gives you the column1 etc row at the top. This is because Excel assumes you will want to filter the data you have, but if you don't want to, there is a tick box in the middle of the Table Tools Design Tab, which you untick. This should solve your problem, but it will leave a blank row above your table.
Hope this helps
Clare
RE: Format as table
Hi Sandra
Thank you for your question -I will certainly try and help. Does your first row contact heading data or does it begin with the first record of data?
Kind regards,
Andrew
|