Category Archives: Excel
How to remove Blank or empty rows in Microsoft Excel 2016 ?
You can use the “Go To Special Command” in Microsoft Excel 2016 to remove the blank or empty rows in a worksheet. How to remove Blank or empty rows in Microsoft Excel 2016 ? 1. Open your ...
How to fill Blank Cells with a specific value in Microsoft Excel 2016?...
There are times when you have to fill the blank cells within your worksheet in Microsoft Excel 2016 with the specific value or for ex: 0. How to fill Blank Cells with a specific value in Microsoft Ex...
Changing the background color of a cell based on value in Microsoft Ex...
This blog post will explain how the users can change the background color of a cell based on its value in Microsoft Excel 2016. Assume a scenario where you have a list of students along with their ma...
Useful Keyboard shortcuts in Microsoft Excel 2016 that you must know &...
There are plenty of shortcut keys available in Microsoft Excel that lets you to do few repeated tasks quickly. In the part 1 of the series of the blog post on excel tips and tricks , I list out some ...
How to Display the Current Date in a Cell in Microsoft Excel ?
Microsoft Excel 2016 provides the functions =TODAY() and =NOW() which displays the current date in a cell in Excel sheet. How to Display the Current Date in a Cell in Microsoft Excel ? Both of the fu...
Custom Cell Formatting in Microsoft Excel 2016
This blog post will provide you a simple tip on how to use Custom Cell Formatting in Microsoft Excel 2016 to display a number in 4 digits. Assume a scenario where you have a ID column in your excel s...
How to insert a picture into a comment box in Microsoft Excel?
This blog post will explain how to add or insert picture (image) to the comment box in Microsoft Excel 2016. How to insert a picture into a comment box in Microsoft Excel? 1. Display all the comments...
How to View Named Ranges in Microsoft Excel ?
Named range is a very useful feature in Excel especially when you work with lot of formulas but there are times when you might want to view the list of all the named ranges in your workbook. There ar...