Rachel Hill23 said:Picture this: you're dealing with massive spreadsheets with thousands of rows. You need to write a formula and drag it down through, say, 4500 rows. To avoid the nightmare of dragging all the way to the bottom... just use this one little trick Excel lets you do. Hover your mouse over the bottom right corner of the cell where you wrote the formula. Once you see the Fill Handl—that little cross icon—just double-click it. The formula will automatically shoot all the way down to the last row that actually has data in it...........................does anyone else have a workaround?
This works perfectly fine in Excel 2007.
Let's try a different way.
- Type your formula into the first cell in Excel, then copy it into Notepad.
Let's say your formula is in B1 and looks like this: =IF(A1>0;A1*2;"")
- Go back to Excel and select all the cells in column B where you want that formula to live (or just grab the whole column)
- Paste the formula into the formula bar (Ctrl+V)
- Hold down CTRL and hit Enter
- Now all those formulas should be sitting in the column, stopping wherever the data in the previous column ends.
Same result as before, just more steps.
