tricks

Showing 41 - 60 of 289 results
In one of my previous blog posts , I provided an insight on the intellisense filtering feature in Visual Studio...
Header and Footer in a Excel Sheet can help you to show certain information to the user on each printed...
  • Excel
  • November 10, 2016
Are you looking at a way to convert image to byte array in C#?. You can convert an Bitmap image...
Assume that you want to display the name of the current file in a cell of your worksheet , you...
There are scenarios where you might want to add more than one author names for a Workbook in Excel. You...
Do you want to insert the current excel workbook’s file path in to a cell in Microsoft Excel ?. You...
Do you want to insert bullets in cells of Microsoft Excel?. Here’s how you can do it. How to insert...
There are times when you might want to control what data the user can enter to a cell. For example...
When you try to print a worksheet in Microsoft Excel 2016 , you may notice that the content might overflow...
Assume that you have a range of numbers in a column and you are required to find out the nearest...
Do you want to retreive the created time and the last modified time of your Excel workbook and display it...
You can easily find out the exact date and time when the excel workbook was created and modified using the...
There are times when you have to NOT just create or insert a drop-down list in Microsoft Excel sheet but...
There are times when you might need to export the excel data to a HTML web page and its pretty...
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Microsoft Excel....
This blog post will explain how you can auto populate the cell when you select a value from drop-down list...
In one of the previous blog posts , we demonstrated how you can use the function RANDBETWEEN in Microsoft Excel...
If you want to generate random numbers in Microsoft Excel , you can use the function RANDBETWEEN. How to Generate...
Assume that you have a date in a cell “A1” and you wish to display only the Weekday name for...
It might be a time consuming task to delete all the hyperlinks from a worksheet in Excel if the user...

Categories

Archives