Quote:
Originally Posted by Karen615
It is easier to read across with banded rows. Is it possible to add them and be able to sort? If it works, how can I have the lightest gray fill.
|
If the manual colouring you added was only for readability (I thought it was to highlight certain rows for your own reasons) then remove all your manual banding, add banding (right-click the style and choose
Modify…) to your own table style (it's the
Second Row Stripe) and choose your own colour for the fill and tick the Banded Rows checkbox on the ribbon. I did this in the attached. Sorting won't affect the banding.
I also, for demonstration, removed the freeze panes on the
Grocery-Supplies Log sheet to show, when the selection is somewhere in the table, that the headers remain visible showing in the column headers instead of A, B, C etc. You may want to reinstate the freeze panes to keep your slicer visible.
I've also added a dynamic named range called
GrocerySuppliesPrintArea (it's 4 columns wider than the table itself) and set the sheet's print area to that in its
Page Layout. It doesn't seem to 'stick' sometimes though.
I thought, now that you have the pivot table, you'd be using that for your print-outs rather than your original log.
If you were to allow the file to be macro enabled (extension .xlsm or .xlsb) we could maintain some/all of these print areas more easily and automatically without user interventoin.