Tips and Tricks in Excel
This blog post is about 4 different methods to import Text files into an Excel Worksheet. Open dialog To open a Text file stored in a specific location of your computer, go to the File tab of the Excel Ribbon > Open > Browse Open dialog will be activated. Use this dialog to locate the…
Until now, Excel doesn’t have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture Lookup in Excel. In this Excel tip tutorial, I will show you how to do Picture Lookup using the existing features in Excel. I have the list of…
This blog post is about 5 methods to convert data in an Excel worksheet to a Picture. Copy and Paste as Picture Select the cells containing data > Right-click > Copy Right-click on the cell where you want to place the picture > Paste Special… > Select Picture (U) from the Other Paste Options And…
In Excel, there can be two types of hidden Worksheets. One is ‘hidden‘ and other one is ‘very hidden‘. The normal ‘hidden’ mode is known to most of the Excel users. But the ‘very hidden’ mode is less known and Advanced Excel users make use of this feature. Very Hidden Worksheets are often used to…
This blog post is about 5 methods to remove formulas from an Excel worksheet without altering the results. In the following dataset we have formulas in the columns D and E. Let’s see how to remove the formulas in the columns D and E while keeping the results intact. Copy and Paste as Values To…
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…
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…