How to remove a table from excel but keep all the formatting and text and formulas

Question

I have a database of patients on excel. It has all their addresses and information which pulls through to a mail merge on word.

I want to remove one of the tables as it won't let me resize it and it will no longer automatically add lines to the table. However, I want to keep all the information, all the formatting, and all the formulas. Is there a way I can do this?

Please help!

Answer 1

Support page var varSegmentation = 0; var varClickTracking = 0; var varCustomerTracking = 1; var varCustomerCookies = ["msresearch"]; var varAutoFirePV = 0; var Route = '16000'; var Ctrl = '010'; var OOGlobal = { BaseDomain: location.protocol + "//" + location.host, Culture: "en-US", LCID: "1033", Platform: navigator.platform, MixOembedUrl: "https://mix.office.com/oembed/", MixWatchUrl: "https://mix.office.com/watch/", Theme: "colorful", HostOrigin: "" }; var toggleActionLocalizedStrings = { on: "On", off: "Off", onAriaLabel: "{0} On", offAriaLabel: "{0} Off" }; var buttonActionLocalizedStrings = { enabledAriaLabel: "{0} enabled", disabledAriaLabel: "{0} disabled" }; (window.awa)||document.write('<script src="/socbundles/jsll"><\/script>'); Convert an Excel table to a range of data

After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.

Important: In order to convert to a range, you must have an Excel table to start with. For more information, see Create or delete an Excel table.

Windows macOSWeb

1. Click anywhere in the table and then go to Table Tools > Design on the Ribbon.
2. In the Tools group, click Convert to Range.
3. -OR-
4. Right-click the table, then in the shortcut menu, click Table > Convert to Range.
5. 
6. Note: Table features are no longer available after you convert the table back to a range. For example, the row headers no longer include the sort and filter arrows, and structured references (references that use table names) that were used in formulas turn into regular cell references.

Answer 2

Hello, Josie,

I spent a long time trying to explain a possible solution, but Wyzant keeps rejecting the submission with a nondescript "There was an error creating your answer. Please try again." I did, and once again, but gave up. Perhaps I have too many screenshots for the space allocation.

I uploaded it to the web: https://docs.google.com/document/d/e/2PACX-1vSfLPsiCzVKlCihRyv4npHwdLnm80uqMMRIX2-7uD15i_4h_ParrY4rOBgcWP_s7cGPwI2jhn8nkNag/pub

I hope you can find something that will help,

Bob