I've got a workbook with about 85,000 rows of data. This data is in a range (created via a mysql data connection)
To the right of this range I've got some formulas. I'd like to fill the formulas down to the last row.
In the past when I'd type in a formula next to a range, it would automatically fill down to the last row. But in this case its not doing so.
I know there are macros to do this kind of work, but if possible I'd rather use a formula.
Any advice?
Thanks
Hi jrtaylor- You were probably working with Tables, which do automatically fill formulas down. If the data in the next column is continuous (no blanks), just double-click on the "drag handle" (the tiny green box on the bottom-right corner of the selected cell). Excel will auto-fill down to the last contiguous data row.
If the data has gaps, then select the top row containing the formulas, press CTRL+C to copy, drag the scroll box down to the bring the last row on to the screen, then hold down shift while selecting the last cell in your paste area. Now paste.
Last edited by leelnich; 02-17-2018 at 01:14 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
You cannot "copy" formulas using a formula. If the formulas are/is next to a column of filled data, dbl click the bottom-right corner of the 1st formula, and it should copy all the way down for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks