Adds the ability to split a cell along the diagonal in order to show labels for both the column header and row header.
Download latest release
Use the link above to download a .zip that contains the add-in file (CornerLabels.xlam) and install.bat. Copy the files from the zip into a temporary directory. Double-click on install.bat to run it. After that, it is OK to delete the .zip and the temporary directory.
Install.bat simply copies CornerLabels.xlam to "%appdata%\Microsoft\AddIns\".
To enable the add-in:
- Open Excel and select a blank workbook (or any workbook).
- Click the File tab, click Options, and then click the Add-Ins category in the left pane of the Excel Options dialog.
- In the Manage dropdown box, select Excel Add-ins, and then click Go. This will open the Add-ins dialog and close the options dialog.
- In the Add-ins available list, select the check box next to Cornerlabels, and then click OK.
You will now have a new section on the Home tab bar called Diagonal Split containing an Add/Edit button.
It is best to add the split cell after you have set up your column and row headers. This is because the split cell will default to using the formatting from those headers. However, you can use the Copy buttons within the Add/Edit dialog to copy the header formatting later.
Published under the GPL v3 license.
Copyright (C) 2018 Evan Barr <http://github.com/evanbarr>
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
Microsoft®, Windows®, Office, and Excel® are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.