# Archive by category Favourite

## Locking individual rows for a value in one cell

In my worksheet for cells I7:R56 I want for any value entered in a cell to lock the rest of the cells of that same row to be locked. e.g. if I have entered a …

## VLOOKUP Function in Excel

A very popular, and often used function, VLOOKUP is a fantastic tool in Excel.  The VLOOKUP Function in Excel is used to look for user specified data in …

## If Functions

I have 53 week numbers along columns AE to CE In column I is the total Quantity. In column Y is the start week number – 7 in this case. In column Z is …

## Calculate VAT Paid in a Total Cost

Using a simple calculation you can quickly workout how much VAT you have paid in the price of product. Let’s assume a product you buy costs £150.00 and …

## How to Send an Email From Excel

Excel has a built in function that allows you to link to other worksheets, workbooks, websites and for this example also send an email by clicking on a link. …

## Excel Formula Based on Cell Background Colour

This article will explain how to have a formula run based entirely upon whether an excel cell has a particular background colour. To do this will require the …

## Summing Cells in Range using SUM Function

Before Excel 2007 the maximum number of rows per worksheet was 65000!  And if you had numbers in just a thousand of those, and needed to a total of all the …