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

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