Apr 05 2023 03:30 PM
Hello,
Does anyone know how to add a line to where the formula will continue, at the bottom of a group, without having to click and drag the line above it? I inserted an example of the table below. Any help would be appreciated.
Account Number | Description | Adopted Budget | Balance |
1012284-5051004 | MATERIALS & SUPPLIES | 10,000.00 | |
PO# or Credit Card | Vendor | Amount | |
10,000.00 | |||
10,000.00 | |||
This is the last line and I want to add a line below that will automatically carry the formula down | 10,000.00 | ||
1012284-5051005 | SAFETY EQUIPMENT | 10,000.00 | |
PO# or Credit Card | Vendor | Amount |
Apr 05 2023 05:14 PM
If what you have is an official Excel Table--which, frankly, it might not be, given how you show it--formulas typically DO continue to populate in new rows. That presumes that they're present in every row above in whatever column contains the formula.
Is it possible for you to post the actual spreadsheet in this instance, not just a replica of it. Post it on OneDrive or GoogleDrive with a link pasted here that grants edit access.
Apr 06 2023 06:47 AM