How to Apply formula on multiple worksheets with 3D reference in Excel
Excel allows you to apply formula on multiple worksheets with 3D reference. You can calculate the final result of different sheet values.
#Excel
189 postsLatest VLookup trick to search with more than one criteria in Excel
VLookup is an important function located in Lookup and reference category. You can use given VLookup trick to search with more than…
2 Methods to insert more than one columns and rows in Excel
Excel is an important application software which is widely used by the users. Now you can quickly insert more than one columns…
Highlight Cells Containing Specific Text with Conditional Formatting
Conditional formatting feature in Microsoft Excel allows you to easily highlight one or more cells which have specific text in active worksheet.
How to copy or fill a formula into adjacent cells in Excel
Excel allows you to easily copy or fill a formula into adjacent cells in Excel using several methods.
How to replace across multiple worksheets or entire workbook
Find and replace is an important command of Excel. Now you can replace across multiple worksheets or entire workbook in Excel.
How to Extract few Numbers using Excel Functions
Excel allows you to insert different types of data format in cell of active worksheet. You can extract few numbers using Excel…
How to use Flash Fill or Auto Fill command in Excel
You can use Flash Fill or Auto Fill command in Excel. It allows you to automatically fill matched data when it senses…
How to use Microsoft Excel LEN function to know length of text string
LEN is an important text function in Excel. Excel LEN function helps you to know the length of any given text string…
How to Create and Run a Macro in Excel
Macro is an important utility of which allows you to start recording of more than one sequentially commands. You can create and…