Forum Discussion
Excel Tables
I have data ina table when I click on "convert to range" and then "yes" to convert nothing happens. Your help greatly appreciated Thanks Joe
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?