+ Reply to Thread
Results 1 to 3 of 3

Sum is auto filling into multiple cells except just the one cell intended

  1. #1
    Registered User
    Join Date
    05-09-2022
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    2

    Sum is auto filling into multiple cells except just the one cell intended

    when I take C2:C13 with the sum function for G2 it auto fills G2-13. In the function bar everything is greyed out and the "table" is highlighted in a blue box. How do I get rid of this blue box and auto fill?
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    05-09-2022
    Location
    USA
    MS-Off Ver
    Not sure
    Posts
    2

    Re: Sum is auto filling into multiple cells except just the one cell intended

    Nevermind! Apparently I was having a massive brain fart and was adding sum after the = mark lol.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,742

    Re: Sum is auto filling into multiple cells except just the one cell intended

    Hello sPopp410. Welcome to the forum.

    Please do find and update your profile with the information requested. Members tailor solutions with those factors in mind.

    To find your version click 'File' in the menu bar. Click 'More' then 'Account'. In the right hand pane you will see Product Information.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cells Auto-filling considering criteria (cell contains)
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-27-2017, 04:57 AM
  2. Auto-filling HH:SS:MM into some cells
    By airhoodz in forum Excel General
    Replies: 1
    Last Post: 10-17-2014, 08:45 AM
  3. [SOLVED] Problem with macro intended to copy cells to a different worksheet based on cell value
    By Crangiopharengoma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2013, 02:47 AM
  4. Skipping Cells When Auto Filling
    By brockco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2013, 08:22 AM
  5. Excel 2007 : Auto filling work log cells
    By finton in forum Excel General
    Replies: 13
    Last Post: 09-01-2010, 09:27 AM
  6. Auto Filling Cells
    By dinesti in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-06-2006, 06:26 AM
  7. Auto Protecting cells & auto filling date
    By ccarmock in forum Excel General
    Replies: 7
    Last Post: 09-30-2005, 05:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1