On Excel

Making excel useful for all. Practical implementation of tips ,tricks and methods. Macros for easy automation and to solve real life problems and scenarios


The excel camera tool can be used to show the snapshot of a particular section from one sheet in another sheet. It is very useful while showing the important/required portions from various sheets on the dashboard sheet.

Excel Camera tool





How to get filename in excel We may need to get the sheetname or the filename of the current excel worksheet into a cell. It is fairly simple to get it. Use the following formula =CELL("filename",A1) This will give the full file name. Check out the various options of the […]

Get Filename in MS Excel


How to get the various format of a cell address in excel Sometimes we may need to get the address of cell in various formats like “the column no for a cell like 6” or “cell position like $C$6” or “column name like AL” etc All of the above can […]

Get cell address in MS Excel