Office Software Thread, calculating cells without draging selection in Technical; Hi,
I have want to create 2 columns of data which extend over thousands of cells, to simplify say i ...
1st July 2010, 10:29 AM #1
calculating cells without draging selection
I have want to create 2 columns of data which extend over thousands of cells, to simplify say i want to create a formula which is:-
Cell A1A =1
how do i replicate this formula down to thousands of cells without having to drag the selection box down forever.
Is there a way to specify a reference grid to copy formulas to i.e: A1A:A16000
1st July 2010, 10:35 AM #2
i think if you fill in the first 2 rows or so correctly the copy them select row 3 then scroll to row 9999 and shift click then paste that should work
1st July 2010, 11:25 AM #3
Fill in the first couple of cells
Press F5 (Goto) and enter the ref for the final cell
Press Shift END <up arrow> and you will highlight from where you are up to the bottom cell which contains data. You can then just use Fill Down to fill the range.
If you're filling to the right from where you are then basically the same - press F5, goto the last cell and press Shift END <left arrow>
1st July 2010, 12:01 PM #4
Cheers for that, it worked, saves a heck of a lot of scrolling, this student had like 15000 rows to fill.
Originally Posted by srochford
By My220x in forum General Chat
Last Post: 28th July 2008, 12:12 PM
By park_bench in forum Coding
Last Post: 30th June 2008, 09:52 AM
By Gibbo in forum General Chat
Last Post: 2nd May 2008, 04:06 PM
By sixfootsy in forum MIS Systems
Last Post: 15th January 2008, 05:47 PM
By G_Money in forum Windows
Last Post: 21st June 2007, 09:33 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)