+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1
    tinmanjo's Avatar
    Join Date
    Mar 2010
    Posts
    16
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    calculating cells without draging selection

    Hi,

    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
    Cell B1A=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

  2. #2


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    7,059
    Thank Post
    232
    Thanked 926 Times in 795 Posts
    Rep Power
    309
    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

  3. #3

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,159
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    125
    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>

  4. #4
    tinmanjo's Avatar
    Join Date
    Mar 2010
    Posts
    16
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by srochford View Post
    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>
    Cheers for that, it worked, saves a heck of a lot of scrolling, this student had like 15000 rows to fill.


    Thanks.



SHARE:
+ Post New Thread

Similar Threads

  1. Calculating days to next birthday?
    By My220x in forum General Chat
    Replies: 3
    Last Post: 28th July 2008, 12:12 PM
  2. VB code to colour cells in a word table
    By park_bench in forum Coding
    Replies: 4
    Last Post: 30th June 2008, 09:52 AM
  3. Calculating Battery charger times
    By Gibbo in forum General Chat
    Replies: 0
    Last Post: 2nd May 2008, 04:06 PM
  4. Calculating a variety of % in SIMS
    By sixfootsy in forum MIS Systems
    Replies: 6
    Last Post: 15th January 2008, 05:47 PM
  5. Excel Not Recognizing Cells of Equal Value
    By G_Money in forum Windows
    Replies: 2
    Last Post: 21st June 2007, 09:33 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •