How To Rapidly Copy Formulas?

Discussion in 'Excel' started by Jaxxxom, Aug 5, 2017.

  1. Jaxxxom

    Jaxxxom

    Joined:
    Jan 22, 2016
    Messages:
    2
    Likes Received:
    0
    Before I begin, PLEASE bear with me. I'm VERY new at Excel. Only using it a few times in the past. So what I learned then I've forgotten. So, I have Office 2016, and I wish to make a simple spread sheet to track income from multiple sources. I'm looking to do monthly totals for each source then a combined daily total from all sources. And that's what took me too long to do tonight. It was a very simple formula of =sum(number1:number2). But 31 days in August I had to type that out 31 times changing each row number. It's done now, but I'm REALLY want to learn Excel, how could I have done this faster without all the typing?
     
    Jaxxxom, Aug 5, 2017
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. davebonallack

    Naming formulas

    davebonallack, Oct 12, 2011, in forum: Excel
    Replies:
    0
    Views:
    262
    davebonallack
    Oct 12, 2011
  2. chel
    Replies:
    0
    Views:
    541
  3. marste7

    Copy and Paste Formula

    marste7, Aug 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    794
    XLPadawan
    Jun 16, 2016
Loading...