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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.