Blog Posts on MS Excel
This blog post is about 4 different methods to Display Formulas in Excel. Following is the screenshot of the data used to explain the different ways for displaying formulas. Show Formulas button To display all those formulas used in a worksheet, go to the Formulas tab in the Excel ribbon and click on Show Formulas…
In this tutorial, I will show you 5 different ways to Extract only Numbers from a list of Strings. Following is a Table containing Text as well as Numeric Values and we will be using this data for explaining the different methods. FILTER Function to extract Numbers The ISNUMBER function in Excel can be used…
Changing the Column Width or Row Height automatically to fit the contents is called AutoFit in Excel. 4 different methods to AutoFit Rows and Columns in Excel are explained in this blog post and the following is the data used for explaining these methods. AutoFit Rows and Columns manually Select the entire Worksheet by clicking…
Following are 3 different methods to copy a Table from Excel to Word. Simple Copy and Paste To copy data from an Excel Worksheet to a Word Document, select the cells containing data > right-click > Copy go to the Word Document > right-click > select the first option (keep source formatting) listed under Paste…
Slicers are floating filters associated with PivotTable, PivotChart and official Tables in Excel. Apart from filtering data, Slicers also provide the current filtering status. In this blog post, we will see how to add Slicers for PivotTables and Excel Tables. We will also cover how to ‘Connect a Slicer to two or more PivotTables.’ Add Slicer for an…
In this blog post, I will show you how to hide the formulas used in an Excel Worksheet and display only the results of those formulas. Following is an Excel Worksheet used by a H.R Manager, for generating the Payslips of his colleagues. Before sharing this workbook with other executives, the H.R manager wants to…
There are 3 different types of protection in Excel. Protecting the Workbook, Protecting the Worksheet and Protecting the structure of the Workbook Protect an Excel File We can protect the content of an Excel Workbook by adding a Password to it. Go to the File tab in the Excel ribbon > Info > click on…
This blog post is about replacing a cell background color with other, using the Find and Replace tool in Excel. Let’s say, I want to replace the Yellow color in the following data with Green. in the Home tab of the Excel ribbon > Find and Select > Replace The Find and Replace dialog is…
By default, the references in Excel are Relative. This means when a formula is copied from one cell to other, the references in the formula will update according to the position of the cell in to which the formula is pasted. We have the following formula in the cell C4 of a worksheet. =C2*C3 When…
We can create a forecast based on Historical data using the Forecast Sheet option in Excel. This option is available from Excel 2016 and is placed in the Data tab of Excel ribbon Let’s see how to forecast the price of Petrol in India for the next few years, based on on the historical data…