Forum Discussion
Excel Tables
Hi Joe, after hitting 'yes' can you still see 'Table Tools' (at the top right of the sheet) when clicking any cell on the table?
Yes, 3 items in Cells tab - Insert, Delete, Format
Joe
Hi Joe, Excel keeps orginial formatting of the table after converting it to range, and it may not be apparent at first glance that the table has been converted. The 'Insert', 'Delete' & 'Format Cells' would appear on the shortcut menu both for the table and the range. It is the presence of the 'Table' command on the shortcut menu that would tell you if you still have table. Could you please confirm if you can still see the 'Table' command on right-click on any cell of the table range after you have done the conversion?
Hi Joe,
How do you know the table is not converted? In addition to what Yury asked you may right click on any cell where your data is (i.e. table or range). If you see Table item within Quick Analysis group of opened menu - you are still with table. If no such item - it was converted.
Hi Sergei,
Don't know if you saw my message (below) to Yury, perhaps I have to reply to individaul messages!
When I right click in any cell I am given the option to convert to range, also if I go to insert "table" is Greyed out, I also have tried under "Design" and convert to range an option which is not available unless it is a Table. This is happening to any sheets which are in this work book. This only happens in some workbooks, others work perfectly.
Many thanks Sergei and hopefully you can help further.
Best regards
Joe
