Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: copy/paste formula down entire column?

  1. #1
    Join Date
    11th November 2004
    Posts
    16

    copy/paste formula down entire column?

    Hi,

    Very simple but I can't figure out how to do it. Ninety percent of the time I paste, it is a formula which is copied from the top row and pasted down to the "bottom". The bottom defined as the previous column's last row with data in it. I work with large datasets, and pasting by scrolling down is time consuming.

    I wonder if this is one of the super obvious things that therefore is never mentioned?

    Thanks for any input on this issue.

    Thanks,
    Getty7

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: copy/paste formula down entire column?

    Double click on the bottom right of the cell containing the formula.

    This should autofill the formula according to entries in the column to the left.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    11th November 2004
    Posts
    16

    Re: copy/paste formula down entire column?

    Hi norie,
    Works great. Thanks,
    Getty7

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 25
    Last Post: November 25th, 2010, 03:18
  2. Find Value In Column & Copy Entire Row
    By honu in forum EXCEL HELP
    Replies: 9
    Last Post: March 24th, 2008, 07:09
  3. Copy Entire Row & Paste To Another Row
    By djlysuc in forum EXCEL HELP
    Replies: 5
    Last Post: September 26th, 2007, 17:37
  4. Copy Entire Column Based on Cell Value
    By koenraadvdc in forum EXCEL HELP
    Replies: 2
    Last Post: January 11th, 2006, 04:22
  5. Copy and paste formula in the next empty column
    By pinto19 in forum EXCEL HELP
    Replies: 1
    Last Post: June 17th, 2005, 17:16

Bookmarks

Posting Permissions

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