Quote:
Originally Posted by Karen615
I added the date entry (9/2/24), but not sure what I did wrong.
|
I added a date below the bottom of your table and it switched the month/day values around. I don't know why! However, it stopped doing that when I formatted the whole table's Date column to the format I wanted.
How to do that (this is for you to do, not the user):
Hover the mouse over the Date label header and when it turns into a black down arrow left-click.
2024-10-03_202151.jpg
This will select the whole table's Date column, then go into
Format cells… and choose your number format.
2024-10-03_202724.jpg
Quote:
Originally Posted by Karen615
On the Original Grocery List tab, is it wise that I added borders all the way to row 20,000? Only problem, if the user prints this, it will print 477 pages. Is there a better way to do this?
|
Now that you've opted to use proper Excel tables you can do this by adding a border around the table. See below.
Quote:
Originally Posted by Karen615
A few questions:
On the Grocery-Supplies Log tab:
• I sorted a column and now my banded rows are not consistent. How do I set up the table so I ensure that the banded rows stay consistent after sorting any column?
|
Select a cell in the table, then goto the
Table Design tab of the ribbon and untick the
banded rows checkbox:
2024-10-03_203035.jpg
However, you can kill two birds with one stone by removing the banding and putting a border around the whole table in one operation by setting up your own table design, roughly as follows:
Select a cell in the table, in the
Table Design tab of the ribbon, in the
Table Styles section, then choose the one to the left of the current selection.
2024-10-03_203733.jpg
This alone gets rid of the banding but now we're going to make a new table style with a border around that you'll be able to use on other tables:
Click on the drop down:
2024-10-03_204524.jpg
and choose
New Table Style…
can't add more pictures, see next message.