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.
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.
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.
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.
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.
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.
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.
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.
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.
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.