From stock parts to holiday villas, from employees to logos, there are plenty of reasons to insert and automatically change an image based on a cell value. Or you may think if this a formula which changes a picture, rather than a number. Ultimately, the purpose is to link an image or picture to a Read More
Category: Tips & Tricks
Removing / cracking Excel passwords with VBA
There is nothing more frustrating than finding out a previous employee has used passwords to protect an Excel file, or maybe you set the password and have now forgotten it. Either way… you’re stuffed! However, before you give in, let me share some of the methods I use to remove passwords. When messing around with Read More
Getting values from a closed Excel workbook
One of the things which scares me in Excel is seeing this message: So many things can go wrong with linked files, yet unsuspecting users tend to use them with pride. “Look, I’ve linked this so that I don’t have to update a cell, isn’t this cool!”. If they knew the risks they might not Read More
Excel’s Speak Cells feature
It’s late; everyone else has left the office. And you can leave as soon as you get a specific report finished. But there are differences between two schedules, and you just can’t find them. You’ve been down the lists multiple times, you’ve ticked the numbers, but still, you just can’t find them. Does this sound Read More
Excel: Stop wasting time with bottom border!
How do you format totals in Excel? Most users will include a line between the list of values and the total. Look at the image below, nothing wrong with that, right? But, the key question is how would you apply this line? If you use the bottom border then you’re missing a trick. Understanding Read More
![Excel Quick Tips [3]](https://exceloffthegrid.com/wp-content/uploads/2017/12/Quick-Excel-Tips-Thumb.png)
Excel Quick Tips [3]
We’re back for another set of quick Excel tips. These tips featured on Twitter initially, so there is only a short description with each video, but it is incredible what can be achieved with a small animated image and 280 characters or less. Quick Excel Tip #21 Insert a line break inside a Custom Read More
How to open multiple instances of Excel
In this post, I want to share the answer to a question I received from a reader. They had recently been upgraded to Excel 2016 from Excel 2010 and were struggling to open multiple instances of the Excel application. Each instance of Excel can have it’s own application settings (such as calculation modes). This is Read More
Quick Excel Tips [2]
Welcome to the second batch of quick Excel tips to enable you to use Excel more efficiently. This isn’t like a sequel in a film franchise, where the first film is good, and all the sequels are rubbish. The tips are presented in no particular order, so depending on how you use Excel these ten Read More
Calling and using the color picker with VBA
When building Excel-based tools and applications it is often useful for the user to select a color. Whilst it is possible to build a custom UserForm, Excel’s native Color window is more than suitable for most circumstances. Excel’s native color picker: To show the Color window, you might think we could use the Macro Recorder, but Read More
Quick Excel Tips [1]
Sometimes it is the small things which make the biggest differences. The following tips are small, some of them very small, but they might save you a lot of time and a lot of annoyance. Quick Excel Tip #1 If the formula Tooltip box is in the way, you can move it. Click on Read More