Close Menu
    Facebook X (Twitter) Instagram
    Tech Chacho
    • News
    • Mobile
    • Gadgets
    • Enterprise
    • Security
    • Reviews
    • Startups
    • How To’s
    • More
      • Fintech
      • Education
      • Cryptocurrency
    Facebook X (Twitter) Instagram
    Tech Chacho
    Home » How to Copy Values From the Status Bar in Microsoft Excel
    How to Copy Values From the Status Bar in Microsoft Excel
    How To's

    How to Copy Values From the Status Bar in Microsoft Excel

    April 25, 2022Updated:April 25, 2022No Comments2 Mins Read
    Share
    Facebook Twitter LinkedIn Pinterest Email

    The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what’s better than viewing those values is being able to use them. Here’s how copy directly from the Status Bar.

    Note: As of this writing in April 2022, the ability to copy values from the Status Bar is slowly rolling out to Excel on Windows users beginning with Office Insiders. So if you don’t see the feature yet, you should soon.

    Choose Your Status Bar Calculations

    Because you can customize the elements that appear in the Excel Status Bar, you’ll need to confirm that those you want to view and copy are selected.

    Right-click the Status Bar in Excel to see the available items. Those with checkmarks are the ones visible in the Status Bar. So if you want to see the average, for example, be sure to select it to place that checkmark next to it.

    How to Copy Values From the Status Bar in Microsoft Excel

    Select the Cells to View the Calculations

    Calculations like average, sum, minimum, maximum, and others only display in the Status Bar when they apply. This means you’ll need to select the cells in your sheet to show those calculations.

    Select a range of cells and when you look down to the Status Bar, you’ll see the values for the calculations you’ve selected.

    How to Copy Values From the Status Bar in Microsoft Excel

    Copy the Status Bar Values

    Once you select the cells and see the calculations at the bottom, simply click the value you want in the Status Bar. This places it on your clipboard. You can then paste it directly in your sheet or another application.

    To paste it into your spreadsheet, select the cell where you want the value and then do one of the following:

    Right-click and choose “Paste.”

    Go to the Home tab and click “Paste” in the Clipboard section of the ribbon.

    Use the keyboard shortcut Ctrl+V.

    How to Copy Values From the Status Bar in Microsoft Excel

    Sometimes small updates to applications we use daily like Microsoft Excel are the best kind. This handy feature allows you to add calculations to your spreadsheets easier than ever before.

    VIA howtogreek

    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email

    Related Posts

    How to Cancel Your Netflix Subscription

    April 27, 2022

    How to Insert and Animate 3D Models in Microsoft PowerPoint

    April 27, 2022

    How to Edit or Delete Contacts in Gmail

    April 22, 2022
    Ad

    Samsung Galaxy Z Fold 6 Appears in Renders Again With No S-Pen Slot

    February 28, 2024

    ProPakistani Unveils Tecno Innovations at MWC 2024: A Glimpse into the Future of Technology

    February 28, 2024

    University of Management and Technology Hit by a Massive Hacker Attack

    February 28, 2024

    PTCL Group Announces Shoq TV Box Powered by Android TV at Mobile World Congress

    February 28, 2024

    All You Need to Know About Stylish and Feature-Packed vivo Y17s Diamond Orange Edition

    February 28, 2024

    HMD Teases Its First Self Branded Phones Instead of Nokia

    February 28, 2024

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    • Facebook
    • Twitter
    • Instagram
    • YouTube
    Mobile

    Samsung Galaxy Z Fold 6 Appears in Renders Again With No S-Pen Slot

    By QuartulainFebruary 28, 20240
    Mobile

    ProPakistani Unveils Tecno Innovations at MWC 2024: A Glimpse into the Future of Technology

    By QuartulainFebruary 28, 20240
    Facebook X (Twitter) Instagram YouTube
    • About
    • Terms Of Use
    • Privacy Policy
    • Disclaimer
    • Affiliate Disclaimer
    © 2026 Designed by Chunk Labs Hosted on Host Chacho.

    Type above and press Enter to search. Press Esc to cancel.

    Go to mobile version