Need Help with Strategy to Document Excel Workbooks
Posted on 2015-02-20
I'm trying to build in some workbook/worksheet identifiers, such as workbook title, worksheet title, rev #, last updated date, worksheet developer name, etc. at the top of each worksheet in a workbook used by many people in an organization.
Putting that information in the top few rows of each worksheet is easy enough but then I end up fighting the column width issues and constantly moving the header information around to suit the visual formatting (in some cases it just doesn't work out, if for whatever reason say my first column in a given worksheet needs to be very wide).
I can alternatively create a worksheet I can call, say, 'Cover' and keep that type of metadata info on that sheet but that doesn't help users when they are on a given worksheet (they'd have to go clicking back and forth between the worksheet and cover page for example to click on the worksheet developer's name or check the worksheet revision number etc.)
I can also put that info into the Print Header but then it's not visible to users and updates are less likely to be made to the hidden Print Header information.
Is there some other more elegant strategy I can use to accomplish what I want to do?
What I'm looking for is more or less equivalent to have the first few rows of a given worksheet totally independent from the rows below so that resizing the width of a column in the first few rows doesn't affect the width of the columns below (I know I can't do that but am looking for a workaround strategy). Merging as and where needed is not practical since, with some merged columns in the top few rows, every time a column needs to be added or deleted in the rows below, it causes issues, especially for less experienced users.
I realize this would be easier to do with a custom designed MS Access solution but that isn't practical in this case to use that approach every time I want to provide some informational structure to corporate workbooks.