I am trying to format a worksheet using the Format as Table tool: enter image description here

However I am receiving an error: "A table can't overlap another table".

My worksheet was previously formatted using Format as Table, so it makes sense that I would need to remove it before re-formatting it. I attempted to clear it via the Home -> Editing -> Clear -> Clear Formats option.

[enter image description here

And that certainly seemed to work visually, but when attempting to re-apply Format as Table, I receive this error: [enter image description here

I'm assuming that the Table format is still there but without any visible formatting. How do I delete the actual table format so that I can apply a new table format?

I am using Microsoft Excel for Office 365: 16.0.12026.20194 64-bit.

1

1 Answer

I think the format as a table/clear format is just formatting, it doesn't create/remove the actual underlying table. Use the convert to range under table design

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy