## 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 …

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 …

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 …

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 …

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 …

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. …

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 …

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 …