+ Reply to Thread
Results 1 to 11 of 11

Clicking on SUM in bottom toolbar in microsoft excel 2021.

Hybrid View

  1. 05-10-2023, 04:05 AM #1
    jienan
    jienan is offline
    Registered User
    Join Date
    05-10-2023
    Location
    philippines
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Clicking on SUM in bottom toolbar in microsoft excel 2021.

    Screenshot 2023-05-10 160238.png

    please teach me how to click this in microsoft excel 2021.
    Last edited by AliGW; 05-10-2023 at 04:10 AM. Reason: Thread title improved - please make your thread titles explicit & not generic in future.
    Reply With QuoteRegister To Reply
  2. 05-10-2023, 04:09 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,106

    Re: microsoft excel 2021.

    Welcome to the forum.

    Firstly, please update your forum profile - it says Office 16, but should say Excel 2021.

    Secondly, why do you want to click the sum and what are you expecting will heppen when you do?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-10-2023, 04:28 AM #3
    jienan
    jienan is offline
    Registered User
    Join Date
    05-10-2023
    Location
    philippines
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: microsoft excel 2021.

    i want to click because i need to paste value . I need it for my job to encode quickly thank you
    Reply With QuoteRegister To Reply
  4. 05-10-2023, 04:12 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,553

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    If you click it, it copies the VALUE to the clipboard (not the formula leading to the value)
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  5. 05-10-2023, 04:29 AM #5
    jienan
    jienan is offline
    Registered User
    Join Date
    05-10-2023
    Location
    philippines
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    You are right because I need encoding so that I can work quickly
    Reply With QuoteRegister To Reply
  6. 05-10-2023, 04:31 AM #6
    jienan
    jienan is offline
    Registered User
    Join Date
    05-10-2023
    Location
    philippines
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    Thank you for helping the solution.
    Reply With QuoteRegister To Reply
  7. 05-10-2023, 04:14 AM #7
    MGadAllah
    MGadAllah is offline
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    this place is not clickable, it is what @Glenn said.
    you can have the same result in any cell by typing the sum formula inside that mentioned cell.
    Reply With QuoteRegister To Reply
  8. 05-10-2023, 04:36 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,106

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    Please update your profile, as I requested earlier.

    You can use the SUM function within the worksheet: https://support.microsoft.com/en-us/...2-07b23e057f89

    There is also the autosum feature: https://support.microsoft.com/en-us/...7-7d1bb85fe706
    Reply With QuoteRegister To Reply
  9. 05-10-2023, 04:43 AM #9
    jienan
    jienan is offline
    Registered User
    Join Date
    05-10-2023
    Location
    philippines
    MS-Off Ver
    Microsoft Office 2021
    Posts
    5

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    Thank you AliGW i know the formula but i need to click then i paste value if i click the sum. thank you
    Reply With QuoteRegister To Reply
  10. 05-10-2023, 04:45 AM #10
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,553

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    You're welcome.


    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  11. 05-10-2023, 04:57 AM #11
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,106

    Re: Clicking on SUM in bottom toolbar in microsoft excel 2021.

    So it's now working for you as expected - yes? Or not?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 3 Criteria Lookup in Excel 2021
    By Etax in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-03-2023, 12:50 AM
  2. [SOLVED] Half Yearly plan Chart with horizontal-axis lables as H1-2021, H2-2021 ...
    By Sum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-17-2022, 02:34 PM
  3. Excel 2021 Scrapbook
    By johnnymargo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-03-2022, 05:06 PM
  4. VBA in the 2021 Excel for Mac compared to 2016 or 2011 versions
    By jvbeaupre0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2021, 01:51 PM
  5. How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06
    By rddt in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 01-10-2021, 05:01 PM
  6. How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06
    By rddt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2021, 04:32 AM
  7. [SOLVED] Formulating 1/1/2021-1/2/2021, 1/3/2021-1/9/2021 etc through one row.
    By jbposey86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2020, 08:27 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1