This guide describes how to grey out unused cells in Excel in Windows 11/10, apply a solid fill color, use Conditional Formatting, or hide unused rows/columns.
On Windows 11, you can now create tables with the expansion of the Markdown support in Notepad, and here's how to get started ...
To clean up the messy data, it needs to be loaded into the Power Query Editor.