I think your layout is better for how you want to see it, but it is not in the style of a proper excel table.
In your example you would need to keep the date you type visible until you are done then hide it, not perfect but how often will you need to hide/show?
Usually data is entered as data, you then you spend time making it look nice - 1 sheet for data entry, 1 sheet for showing
Maybe a couple of more ideas.
Excel Table
On the attached i have added an 'Alternative sheet' - this is how i would add the data. Roll, Subject, Subject date then the 'show date'. This can be filtered to show what is on row 1 for example. But i have also added a pivot table on sheet2 which can be filtered and refreshed as you add data.
Or....
Outline Grouping (which is on the data tab)
On your Print films sheet i have added Grouping on the Subject date column (its simular to hiding but a bit easier to show
You can click the plus at the top of the column to unhide 1 column or the number of the left to show all of them, tab still skips them but it might work better for you.
Personally i would so with the proper excel table layout, but that is just my preference.
|