Skip to content
Excel Off The Grid Logo
  • Home
  • Blog
  • VBA Library
  • Downloads
  • Need help?
  • About

Category: Blog

Loop through selected sheets with VBA

Loop through selected sheets with VBA

Posted on July 18, 2020 by Excel Off The Grid

Looping through worksheets is one of the most common actions performed by those who use VBA to automate Excel.  However, we don’t always want to apply a macro to every worksheet; sometimes, we only want it for each selected sheet.  Depending on the action being performed, this can cause an error. This occurs where the Read More

Posted in Blog, VBA, VBA Code Snippet Leave a comment
How to add a drop-down list in Excel

How to add a drop-down list in Excel

Posted on July 3, 2020July 3, 2020 by Excel Off The Grid

We come across drop-down lists on the internet and other software applications all the time.  They are useful because they limit the options available to the user, as only pre-validated items can be selected.  In this post, we’ll look at different ways to add a drop-down list in Excel. In Excel, there are three different Read More

Posted in Blog, Miscellaneous Leave a comment
Switch chart between monthly and quarterly

Switch chart between monthly and quarterly

Posted on June 27, 2020June 27, 2020 by Excel Off The Grid

In this post, I want to answer a question asked by a reader.  The question was from Nick: “I have a chart on a separate chart sheet, where I’d like to add a developer object (button, option box or checkbox) to control whether data is shown quarterly or monthly. Any idea how to do that?” Read More

Posted in Blog, Charts 2 Comments
Power Query - Filter with wildcards

Power Query – Filter with wildcards

Posted on June 19, 2020 by Excel Off The Grid

In Power Query, there is one key feature that is missing, the ability to filter using wildcards.  Some have got around this with complex M code, while others suggest using the Text filter functions, such as Text.Contains, to create a similar effect.  However, what I’m about to show you is an easier way to filter Read More

Posted in Blog, Power Query 2 Comments
Resetting the scroll bar in Excel

Resetting the scroll bar in Excel

Posted on June 3, 2020September 7, 2020 by Excel Off The Grid

Have you ever experienced the issue where Excel’s scroll bars become tiny?  A small movement in the mouse can change the view by hundreds of rows or columns.  This makes the worksheet exceptionally difficult to navigate around. The problem might reveal itself with an error message when trying to insert new rows or columns. In Read More

Posted in Blog, Tips & Tricks, VBA 12 Comments
Power Query - Combine rows into a single cell

Power Query – Combine rows into a single cell

Posted on May 29, 2020June 13, 2020 by Excel Off The Grid

Last week we saw how to split a delimited cell into separate rows.  This week we are going to do the opposite; combine rows into a single cell with Power Query. While having a flat table is excellent for data manipulation, but it’s not always the way a user wants to view the information.  If Read More

Posted in Blog, Power Query 8 Comments
Power Query - Split delimited cells into rows

Power Query – Split delimited cells into rows

Posted on May 22, 2020June 13, 2020 by Excel Off The Grid

This is the first of two posts showing how to split and combine rows from/to delimited cells.  In days gone by, it would take a long time for us to resolve these scenarios.  But with Power Query, it’s now a quick and easy process, which can be updated with a simple refresh. In this first Read More

Posted in Blog, Power Query Leave a comment
Automated Goal Seek

Automated Goal Seek

Posted on May 15, 2020June 20, 2020 by Excel Off The Grid

I recently attended an online meetup where Danielle Stein Fairhurst shared a technique involving Excel’s Goal Seek feature operated by a macro.  This got my mind buzzing with ideas, so I wanted to share it with you, along with a few of my own developments.  I’ve not used the technique extensively to date, but it Read More

Posted in Blog, VBA 1 Comment
Change the Power Query source based on a cell value

Change the Power Query source based on a cell value

Posted on May 9, 2020July 4, 2020 by Excel Off The Grid

If you’re like me, you build Power Query solutions in a test environment first; then,  when ready, it’s released into the wild.  This means the paths of all source files must be updated.  Or maybe you’re a consultant who creates solutions for others; when you distribute the workbook to your client, you have to provide Read More

Posted in Blog, Power Query 14 Comments
100 Excel VBA Macros

100 Excel VBA Macros

Posted on May 1, 2020January 28, 2021 by Excel Off The Grid

With macros, we can automate Excel and save time; big tasks or small tasks, it doesn’t matter.  All that matters is that we’ve become more efficient. In this post, I share 100 VBA macro codes that you can use today.  If you’ve never used VBA before, that’s fine.  Part 1 contains instructions of how to Read More

Posted in Blog, VBA 5 Comments
Posts navigation
Older posts →
← Newer posts

Subscribe to newsletter

Subscribe to the newletter to receive exclusive content, tips and tricks, tools and downloads.

100 Excel Macros Book

Downloads include 100 Excel VBA Macros ebook for FREE.

Download Icon

Where to find me

Follow @exceloffthegrid

Top Courses

300x250

Top Books

Theme by Out the Box
  • Home
  • Blog
  • Downloads
  • Need Help?
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact