How to conditional format date older than two weeks in Excel

How to conditional format date older than two weeks in Excel

The conditional Formatting Tool is used to perform various functions in Excel. One of the most significant tasks performed by conditional formatting is highlighting cells with the matching rule. However, did you know you can use this tool to check dates? Excel uses manual methods in most cases to highlight dates and count days older

Excel How to Stop Changing Numbers to Date

Excel How to Stop Changing Numbers to Date

Microsoft Excel is pre-built or programmed to make it easy to enter the dates. For example, 12/4 4-December. It will be vexed when you enter a number that is not a date. There is no way to stop this, but we can work around it. Preformat the cell One of the ways is to preformat

How to Remove Leading or Trailing Spaces in an Entire Column of Data

How to Remove Leading or Trailing Spaces in an Entire Column of Data

It is rather frustrating to have leading or trailing spaces in your column in Excel. Many serious issues could result from leading and trailing spaces between texts. Extra spaces in your worksheet can result from data downloaded from a database or copying data from text data. It also comes from entering data manually by mistake.

How to Remove Line Breaks in Excel

How to Remove Line Breaks in Excel

Through line breaks, the same cell has multiple lines in Excel. However, these lines are unnecessary, so you may want to remove them from your dataset. There are different ways to remove line breaks in Excel. Using Find and Replace Method It is considered the easiest way of removing line breaks manually in Excel. The

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.

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

How to put a picture behind the text in Excel

How to put a picture behind the text in Excel

Did you know you can add a background image to your excel data? Excel has unique features that allow its users to insert a background image on their data. The background image helps in making the data have an interesting. Two methods can be used to insert a background image on your Excel document. These

How to rotate text in Excel 90 degrees

How to rotate text in Excel 90 degrees

Changing how data appears is sometimes necessary may by tilting text to certain angles or changing its alignment in excel. In excel 2007 you may use the orientation button on the home tab to rotate data cells. This can either be clockwise, counterclockwise or even vertical. You also are provided with a more precise orientation