collapse excel ribbon - Free Excel Tutorial

How to Sum for Cell Contains Formula Only in Excel

Sometimes values are created by formulas in cells. If we want to sum values which are created by formulas from a range, but some values which are hardcoded also list in the same range, how can we filter out matched data and only sum the filtered values correctly? By the way, if we want to… read more »

How to Count Cells that Contain X or Y in Excel

This post will guide you how to count the number of cells that contain X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain… read more »

How to Highlight Cell if Same Value Exists in Another Column in Excel

This post will guide you how to highlight cell if same value exists in another column in Excel. How do I highlight cell if value is present in any cell in another column in Excel 2013/2016. Highlight Cell If Same Value Exists in Another Column Assuming that you have a list of data in range… read more »

Excel Ribbon

Contents: Ribbon Tabs  | show or hide the ribbon  | customize the ribbon | add ribbon tab and groups | rename ribbon tab | add ribbon command to custom group | reset ribbon tabs to default | Customize quick access toolbar on ribbon | Add developer tab to ribbon The Ribbon is the strip of buttons and icons located above the work… read more »

Sidebar