Amazon Quiz Answers and Win OnePlus 8 Pro|Flipkart Fake or Not Fake Quiz
Categories
Tech Guide

No cells were found Error with Easy Solution in Excel

During working on the Excel sheet sometime we get an message with the name of “No cells were found” on few special cells. The No cells were found issue in Excel found on many special cells or special excel format.

Categories
Tech Guide

Fill Blank Cells in Excel With Value from Above

Sometime we have an worksheet in which more than one cells left blanks and you need to fill blank cells in Excel with value from above. After filling all the blank cells you can easily sort, filter apply formatting as per your need. In this tutorial you’ll learn a simple trick how to fill blank cells in Excel with value from above cells.

Categories
Tech Guide

How to Lock and Hide the Formula in Excel Worksheet

During working on excel sheet, sometime you don’t want to show applied formulas and also lock the active worksheet. In this tutorial, will discuss how to lock and hide the formula in Excel worksheet so that applied formula don’t show in the formula bar. This tutorial very useful for all those excel users who want to know about quickly lock and hide the formulas in active worksheet.

Categories
Tech Guide

How to Add and Use Camera in Excel Quick Access Toolbar

Have you ever take a screen shot of selected data range in a worksheet? If “No”, then try this… it’s a great tool which allows you to take a picture of currently selected range of cells which update dynamically when original data changed at target location. To do this job you have to add and use camera in Excel Quick Access Toolbar.

Categories
Tech Guide

Insert a blank Row between existing each Rows of data in Excel

Sometimes, during working on any excel sheet you need to insert a blank row between existing each rows of data in Excel. If you need to insert few rows only then you can use any shortcut key or use insert command.

Categories
Tech Guide

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.

Categories
Tech Guide

How to Group and Ungroup of 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 group and ungroup of Excel pivot table data. Pivot table is an important and useful tool for data analysis in Excel.

Categories
Tech Guide

How to create and modify calculated fields in Pivot Table

Pivot table is an important and powerful feature of Microsoft Excel. A pivot table allows you to easily arrange and summarize complex data. Sometime you need to create and modify calculated fields in Pivot Table. This feature provide more power to your active pivot table.

Categories
Tech Guide

How To Sum Cells With Text And Numbers appended in same cell in Excel?

During working on Excel, sometime we have a list of values which containing numerical along with textual values both in a single cell. To get total or count these types of cells very difficult. In this guide we have to discuss how to sum cells with text and numbers appended in same cell in Excel.

Categories
Tech Guide

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.