Speed Up Slow Running Excel File

MikeProductivityLeave a Comment

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

MikeProductivity40 Comments

EXCEL CANNOT BREAK LINK

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

12 Excel Wildcard Examples You Need to Know

MikeLookup FunctionsLeave a Comment

EXCEL WILDCARDS

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

MikeFormattingLeave a Comment

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

MikeLookup Functions, Text Functions3 Comments

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