Excel Tables

Question

I have data ina table when I click on "convert to range" and then "yes" to convert nothing happens. Your help greatly appreciatedThanksJoe&nbsp;

yury tokarev · Answer

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?

joe dunne · Answer

Yes, 3 items in Cells tab - Insert, Delete, Format&nbsp;Joe&nbsp;

sergeibaklan · Answer

Hi Joe,&nbsp;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.

yury tokarev · Answer

Hi Joe, Excel keeps orginial formatting of the table after converting it&nbsp;to range, and it may not be apparent&nbsp;at first glance that&nbsp;the table has been converted. The 'Insert', 'Delete' &amp;&nbsp;'Format Cells'&nbsp;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?

joe dunne · Answer

Hi Sergei,Don't know if you saw my message (below) to Yury, perhaps I have to reply to individaul messages!&nbsp;&nbsp;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 regardsJoe

Forum Discussion

Excel Tables

Share

Resources