Excel

How to Show Report Filter Pages Excel Pivot Table Data

Pivot table is an important feature of Excel, which allows you to manage and summarize your large worksheet data. In this article, we will discuss how to show report filter pages Excel pivot table data. You can use, Pivot table which is an important and useful tool used for data analysis purpose in Excel. Read More

How to add suffix in range of cells in MS Excel

Do you ever have those situations where you need to add suffix in range of cells in MS Excel. During typing any numeric value can you make an amendment or add suffix text in every selected range of cell. In this guide we have to discuss how could you easily adding suffix in range of cells in Microsoft Excel. Read More

Autosave Excel file using code to protect file

Lot of time many peoples facing these issue like computer crashes, power goes out, accidentally close any file without saving and many more. In that situation you may lost of your working data, and you need to know how to autosave Excel file. There are lot of ways to auto save Excel file either using Autosave feature or using the code. Read More

Lookup Multiple Fields of Data with Excel VLOOKUP

With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More

How to use LEFT Function with Find Function

Sometime we need to extract few characters of a string with the help of Left function. In this guide we have to discuss how to use Left function with Find function to extract the worlds. Excel allows you to use a user defined function to split a text string as per your need. To quickly split text string at specific character then you must have to know how to use Left function with Find function. Read More

How to turn on or turn off scroll lock key

Sometime you feel that you can no longer moving around the workbook area properly due to the scroll lock key. Most of the person facing lot of issues to turn on or turn off scroll lock key at his system. During working on excel sheet When you press any arrow key you feel column or rows are moving at the place of cursor moving to another cell. Read More

How to switch or flip name in Excel

Sometime you need to flip the first and last name within the cell. Mostly peoples use cut and paste method to easily switch or flip name in Excel sheet. You can also use retyping method of reverse the first name and last name within cells. These are the simple ways to reordering the first and last name. Now, in this guide we’ll discuss another way which quickly allows you to switch or flip name in Excel sheet. Read More