Special welcome gift. Get 30% off your first purchase with code “Eduma”. Find out more!

    Get Started
    HomeMicrosoft OfficeExcel

    How to apply formula to entire column without using AutoFill in Microsoft Excel 2016?

    admin November 10, 2024 No Comments

    In Microsoft Excel , you can use the AutoFill feature to apply the same formula to the entire column by just dragging it.

    How to apply formula to entire column without using AutoFill in Microsoft Excel 2016?

    You can use the Ctrl + Enter keyboard shortcut key for this.

    Assume that you have columns A and columns B and you need to apply the formula on Column C cells. Simply select the whole column C and enter the formula and press Ctrl + Enter key at the same time.

    You should immediately notice that the formula would be applied to the entire column.

    image

    Tag:
    Share:

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8

    You May Also Like

    See more

    How to Find Blank Cells in Excel?

    In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
    Read more

    Gauge Chart in Microsoft Excel

    In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
    Read more

    How to Move Columns in Excel ?

    Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...
    Read more