How to use DCOUNTA Function in Excel
With the help of DCOUNTA function you can easily count all those non-blank cells which match the criteria in active database.
#Microsoft-Office
215 postsAutosave Excel file using code to protect file
Two ways to quickly Autosave Excel file to protect any crashes. Either you can use the code or turn on Autosave feature…
How to Group and Ungroup of Excel Pivot Table Data
Excel Pivot table allows you to manage and summarize excel worksheet data. You can group & ungroup pivot table data row or…
How to add suffix in range of cells in MS Excel
Sometime you need a quick way to add a prefix or suffix to all cells with in a range. Excel allows you…
How To Sum Cells With Text And Numbers appended in same cell in Excel?
Normally you can't do this job, but Sum array allows you to get the get the sum cells with text & numbers…
How to create and modify calculated fields in Pivot Table
Pivot table allows you to create, add calculated fields, apply formulas, & delete them. You can modify calculated fields in Pivot Table.
How to use Paste Special Formats in MS Word
Paste special dialog box you can easily paste, copied data in different Paste Special Formats in MS Word and also create paste…
Important Text Functions of Microsoft Excel
Lot of text function in MS Excel. If you want to apply any formula on text that you have to use given…
How to split active worksheet in several pages in MS Excel
Trick to split active worksheet in several pages in MS Excel, in different pages to set or print header or footer area.
Insert a blank Row between existing each Rows of data in Excel
Sometime you need to add blank rows, Excel allows you to quickly and easily insert a blank row between existing each rows…