Given you are on this page, chances are you’ve seen this type of problem. Don’t put up with Excel® files running slowly and stopping you getting on with your important work. Chances are the slow file is due to a combination of three problems. All these problems are easy to fix. Go and look at your slowest spreadsheet file (probably … Read More
Excel Cannot Break Link – The Ultimate Guide
If you cannot break links in Excel® then follow these steps (backup your file first): Unprotect each sheet in your problem file: HOME RIBBON – (CELLS) FORMAT – PROTECT SHEETS Break links: DATA RIBBON – (CONNECTIONS) EDIT LINKS – Select sheet then BREAK LINK Delete all named ranges to external files: FORMULA RIBBON – (DEFINED NAMES) NAME MANAGER Check all chart … Read More
Excel Link to VLOOKUP or SUMIF Result
It can be incredibly useful to create a link to VLOOKUP results in Excel®. This is particularly true if you have used VLOOKUP to join data from one table to another. You can jump straight to the result of the VLOOKUP and see the rest of the data in that row of your Excel® table. We can quite easily create … Read More
12 Excel Wildcard Examples You Need to Know
When you’re looking up text or values you’ll often want to use wildcards in your searches. The wildcards are: * (Asterisk) ? (Question Mark) <> (Less Than, Greater Than) (blank) Wildcards work with all of the following functions: SUMIF, SUMIFS COUNTIF, COUNTIFS AVERAGEIF, AVERAGEIFS VLOOKUP, HLOOKUP (‘<>’ will not work with these) MATCH (‘<>’ will not work with this) Lets look … Read More
Excel Conditional Formatting If Cell Is Blank
You may want to find and highlight all blank cells in a range or sheet within your Excel® file. You can use conditional formatting to highlight if a cell is blank. And you can also use conditional formatting to highlight any of these cell attributes: Is text Is a formula Is a constant Is an error The number of characters … Read More
How To Lookup Part of Text in a Cell
In Excel you may need to lookup just part of the text in a cell. For example, if you have a cell that contains a transaction description and within that description there is a product name. You want to lookup the price of that product from a table. Let’s look at three possibilities: When the product name is just … Read More