Jul 26 2021 07:31 AM - edited Sep 03 2021 09:09 AM
I have an Excel spreadsheet that I created with imported data (Data>From Text>Selected .txt File). Removed the external connection to the .txt file by deleting it using the Name Manager. Added headers and tried to format as a table (Home>Format as Table>Table Style Medium 20). Excel opens the "Format as table" wizard and automatically puts the dashed lines around all the headers and data. I checked the "My table has headers" box. Then I hit OK.
Nothing happens. The Format as table box stays, the data stays with the dashed lines, but I do not get a table. I don't get the spinner, only my data with a dashed line around it and a Format as table box asking OK or Canclel.
Excel has formatted tables for me under these conditions before so I don't understand why this is not working. I am using MS Office Professional Plus 2016.
Jul 26 2021 08:40 AM
Jul 29 2021 01:26 AM
Aug 05 2021 12:02 PM
Aug 05 2021 01:52 PM