How do I undo a table?

**botaurus11** · 02-19-2018, 06:22 AM

Hi - My Custom Views (under View tab) is greyed out, apparently because I have a table in my worksheet. How do I undo the table? Thanks!

**AliGW** · 02-19-2018, 06:24 AM

Select the table and select convert to range fr.om the table options.

**botaurus11** · 02-19-2018, 07:25 AM

Hi Ali, I looked under Format as table, and couldn´t find how to convert to range. Thanks

**sandy666** · 02-19-2018, 07:30 AM

Right click inside the table and select:

converttorange.jpg

**botaurus11** · 02-19-2018, 09:45 AM

Hi - I´m sorry, but I don´t understand. I´m not sure how to select the table to right click inside. The Custom Views is greyed out even when I´ve selected a cell outside a table, but reappears when I open up a new workbook.

**xlnitwit** · 02-19-2018, 09:51 AM

Do you know where the table is located in your workbook?

How do I undo a table?

LinkBack

Thread Tools

Rate This Thread

Display

How do I undo a table?

Re: How do I undo a table?

Re: How do I undo a table?

Re: How do I undo a table?

Re: How do I undo a table?

Re: How do I undo a table?

Thread Information

Users Browsing this Thread

Similar Threads

Hope this is not impossible. An Undo Handler/ Macro to undo using keyboard shortcut

[SOLVED] Undo command has changed to Can't Undo

Undo VBA code repeats only on table header for some reason. Can't figure out why.

[SOLVED] Undo Table format

Copy Row, RtClick Row, Insert Copied Cells - pauses and auto undo! No undo path

Undo function to undo Visual Basic commands

Undo Linked Fields in Excel 2003 Pivot Table

Bookmarks

Bookmarks

Posting Permissions