…continued
So select
New Table Style…
2024-10-03_204825.jpg
Then in the next dialogue box:
Select
Whole table, and click
Format:
2024-10-03_205524.jpg
then in the next dialogue chose the
Border tab, select a line style for your border, click on the
Outline icon and click
OK, then
OK again.
2024-10-03_205926.jpg
you now have a new custom table style you can click to select:
2024-10-03_210421.jpg
The border will always adjust to the table's size.
Quote:
Originally Posted by Karen615
• My drop-down in column D is not extending when I make a new entry. It's picking up the “StoresRestaurants” named range. Not sure how to fix this.
|
If, when adding a new entry to the
Grocery-Supplies Log table (it's called
Table4 in your file) below the bottom of that table, the first thing you add should be in a column which does NOT have data validation. As soon as you do that, a new row gets added to the table and all the data validations are added to all the other columns in that new row . This means you don't need Data Validation in any cells below the extents of the table; in fact this is a waste of resources and I'd recommend you delete
everything below that table; Formatting/Data Validation, the lot.
As far as setting a print range for printing out this data-entry table
Table4, (ArviLaanamet's suggestion) the fact that it's now a table means that there already exists a dynamic range you can use to set the print area; it's called
Table4[#All] and you can add it as the print area:
2024-10-03_211834.jpg
(The
[#All] bit is just to include the headers)
I wish I could say the same about pivot table print areas; these are not so easy to set automatic print areas for.