I'm looking a way to write a formula at the head of a column, and that will be good to apply for all the rest of the complete column, including future inserted lines.
Instead of copying the formula from the first to the last case and for every newly inserted lines. I have a list of at least 13000 lines.
Like when you put the complete line or column yellow using the heads.
Thanks!
Can you not simply use a row # larger than anything you'd ever expect to use for your data, e.g.
=SUM(A2:A99999)
or even the end of the column, which for modern version of Excel is row 1,048,576?
=SUM(A2:A1048576)
Hi.
Convert your data to a table.
Select all your data. Got to the home menu, select insert and then table.
If you enter data on a new line. Excel automatically inserts the formulas from the line above.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks