Microsoft Excel – Get current date and time

In this quick tutorial we will be going to add the current date and time as a cell within an Excel spreadsheet, the date and time will update each time a change to the spreadsheet is made or each time it is opened. To do this carry out the following steps. Select the cell andContinue reading “Microsoft Excel – Get current date and time”

Microsoft Excel – Highlighting column differences

In todays post we will be highlighting any column differences within our Excel spreadsheet, to do this carry out the following steps: Start by highlighting the columns where you duplicate row values may exist. Within the ‘Home‘ tab click on ‘Find & Select button, within the dropdown click ‘Go To Special…’. A pop up windowContinue reading “Microsoft Excel – Highlighting column differences”

Microsoft Excel – Highlighting row differences

In todays post we will be highlighting any row differences within our Excel spreadsheet, to do this carry out the following steps: Start by highlighting the rows where you duplicate row values may exist. Within the ‘Home‘ tab click on ‘Find & Select button, within the dropdown click ‘Go To Special…’. A pop up windowContinue reading “Microsoft Excel – Highlighting row differences”

Microsoft Excel – Find and replace text

In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below: Start by highlighting the range of cells where the text you are wanting to replace may exist. Within the ‘Home‘ tab click on ‘Find & Select‘ and then clickContinue reading “Microsoft Excel – Find and replace text”

Microsoft Excel – Highlighting cells less than

In todays post we will be highlighting cells with a value less than a given number, to do this carry out the following steps: Start by highlighting the range of cells where you are wanting test if the values are greater than a given value. Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, withinContinue reading “Microsoft Excel – Highlighting cells less than”

Microsoft Excel – Highlighting cells greater than

In todays post we will be highlighting cells with a value greater than a given number, to do this carry out the following steps: Start by highlighting the range of cells where you are wanting test if the values are greater than a given value. Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, withinContinue reading “Microsoft Excel – Highlighting cells greater than”

Microsoft Excel – Jumping to the last cell

In this tutorial we will be covering the process to jumping or going to the last populated cell, this is especially useful if you are working with a very large set of data. To do this carry out the following steps. Select any cell within your spreadsheet. The active cell will then be noted byContinue reading “Microsoft Excel – Jumping to the last cell”

Microsoft Excel – Text to columns

Text to columns is useful feature in Microsoft Excel that allows that allows us to parse data in a single cell to many cells based on a defined delimiter. To do this carry out the following steps: Highlight the cell or column that you are wanting to parse. Select the ‘Data’ tab and then clickContinue reading “Microsoft Excel – Text to columns”

Microsoft Excel – Highlighting cells with duplicate values

In todays post we will be highlighting cells with duplicate values, to do this carry out the following steps: Start by highlighting the range of cells where duplicates may exist. Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, within the dropdown click ‘Highlight Cells Rules‘ and in the next sub menu click ‘Duplicate Values…‘Continue reading “Microsoft Excel – Highlighting cells with duplicate values”

Microsoft Excel – Removing blank cells in a spreadsheet

In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below: Start by highlighting the range of cells where you are wanting to remove the blanks. Within the ‘Home‘ tab click on ‘Find & Select‘ and then click ‘Go toContinue reading “Microsoft Excel – Removing blank cells in a spreadsheet”