HomePosts tagged โ€œExcel 2016โ€

Excel 2016

Showing 1 - 20 of 72 results
Do you want to insert a random number between 2 numbers in a excel cell? For example , assume that...
It might be a time consuming task to delete all the hyperlinks from a worksheet in Excel if the user...
Assume that you want to display the name of the current file in a cell of your worksheet , you...
The comment indicators are displayed in the cells when you insert the comment. If you need to hide the comment...
Microsoft Excel 2016 provides you with the PROPER function that lets you change the uppercase letters to title case. Letโ€™s...
There are times when you might need to export the excel data to a HTML web page and its pretty...
This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016....
  • Excel
  • November 29, 2024
Assume that you have a range of cells that contains values with 4 decimal places and you wish to round...
  • Excel
  • November 28, 2024
In one of the previous blog posts , we demonstrated how you can use the function RANDBETWEEN in Microsoft Excel...
  • Excel
  • November 28, 2024
There are times when you might want to prevent the users from entering certain number of characters in a cell...
  • Excel
  • November 28, 2024
There are times when you might want to know how many times an item is repeated in another list. You...
  • Excel
  • November 27, 2024
Hereโ€™s one of the simple tips and tricks in Microsoft Excel 2016 related to the Format Cell Dialog. You can...
  • Excel
  • November 27, 2024
There are times when you might copy few data from different source and you would end up getting unnecessary line...
  • Excel
  • November 26, 2024
This blog post will explain in simple steps on how the users can quickly insert multiple checkboxes in Microsoft Excel...
  • Excel
  • November 26, 2024
In one of the previous blog posts , I explained how the users can use the conditional formatting feature in...
  • Excel
  • November 26, 2024
Assume that you have a range of numbers in a column and you are required to find out the nearest...
  • Excel
  • November 26, 2024
Header and Footer in a Excel Sheet can help you to show certain information to the user on each printed...
  • Excel
  • November 26, 2024
Ever wondered how you can show or hide comments in Microsoft Excel ?. This blog post exactly shows how you...
  • Excel
  • November 25, 2024
Do you want to retreive the created time and the last modified time of your Excel workbook and display it...
  • Excel
  • November 25, 2024
In Microsoft Excel 2016 , you can easily add or subtract days directly by using the + or โ€“ operator....
  • Excel
  • November 25, 2024