How to Insert and Delete Comments in Excel

How to Insert and Delete Comments in Excel

Comments are quite useful in Excel, especially when inserting formulas, and there is a need to specify what the formula does and what a cell value means. It is also important to add comments when collaborating with others for their reference. This tutorial shows you how to add comments, edit, and delete them in Excel. … Read more

Excel How to Hide Gridlines

How to Hide Gridlines

Most excel users confuse cell gridlines and cell borders. Excel gridlines are customized differently to the borderline. In excel, gridlines are displayed using a default color assigned by excel. If you need to change the color of the gridline for your worksheet, it's possible. To most users, you know hiding gridlines is common. In some … Read more

How to subtract 30 minutes from time In Excel

How to subtract 30 minutes from time In Excel

You can subtract (or add) minutes to a given time using the time function available in the time function. The subtracting feature determines the number of minutes that elapsed in a given event. To calculate this, you need to have a cell that contains your time, from which 30 minutes will be subtracted. In most … Read more

How to Capitalize the First Letter of a Text String in Excel

How to Capitalize the First Letter of a Text String in Excel2

Excel can be used with text data apart from numerical data. You could use it to record a business's names, goods, or services. The test data should be made by capitalizing the first letters of all the words in the cells. You may want to capitalize the first letter of each word or only the … Read more

How to compare two columns for differences in Excel

How to compare two columns for differences in Excel

The comparison involves checking if one list matches the other. Excel is a powerful tool for checking if one column matches the data in the other column. This is because excel consists of cells that are arranged in columns. Therefore, few workarounds and formulas can be used to check the comparison between two or more … Read more

How to highlight every five rows in Excel

How to highlight every five rows in Excel

To improve the readability of the excel workbook, one can highlight the whole worksheet or Nth row. Highlighting the excel row means filling it with another unique color compared to other rows' colors. One can decide to highlight every row that contains a certain index. For example, in this article, we shall discuss how to … Read more