Personal Macros – Locked & Unlocked cells

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

This is another handy personal macro I use in my day to day spreadsheeting and application building.  It sits in my Add-In which has it’s own tab on my custom ribbon, but you might just use the ribbon QAT or

  •  
  •  
  •  
  •  
Tagged with: ,

Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Want to sit in on a world class Excel seminar?  Microsoft has a fantastic seminar Microsoft Ignite for tech professionals including Excel Pros, the most recent was held just over a month ago in Orlando U.S. Sept 24-28 2018.  You

Tagged with: ,

Kanban Tool for Excel project management

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

This blog is about a really great tool I discovered to use for client Excel work, called Kanban Tool.  For significant projects like anyone else I need to plan how I should develop a spreadsheet and keep track of all

Tagged with:

Are guys really using Excel for this?

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Was enjoying my coffee this cold winter’s morning, reading my nerdy ipad edition of  The Australian newspaper and there was this article!   Read the first paragraph!  No way!  If there are men out there using my beloved Excel for that

Tagged with:

Macro to fix Duplicate Conditional Formatting rules in Tables

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated and messy Conditional Formatting.  I tweeked this code just a bit so that all

Tagged with: , , , , ,

Alternatives to Conditional Formatting

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance. 

Tagged with: , , , , , , ,

Fix duplicated Conditional Formatting Rules

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

If you have ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into, I hope the following post helps you.  Basically this situation arises as you go about day to day coping

Tagged with: , , , ,

Entering a relative formula in VBA using the macro recorder

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

I did this very thing today, so thought I would share this tip with you as it saves me a lot of time.   Say you wanted to have this formula go into column 8 of the range you created in

Tagged with: ,

Using a Table Name prefix for productivity

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

A few years ago I picked up on this gem of a tip of Dick Kusleika in his blog at his The Daily Dose of Excel site on using the Table Name prefix of “tbl”.  If you are not dropping

Tagged with: , , , ,

My First PowerApp

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

I talk a lot about Excel automation.  Automating with Excel helps us be more productive and efficient in our jobs.  Automating tedious tasks using advanced Excel features like Tables, Pivot Tables, Power Query, VBA or macros. The benefits are many

Tagged with: , ,

Google Sheets and Google Forms

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  • 1
  •  
  •  

It’s good to check out how Google Sheets are doing every now and then.  In my view, it just isn’t as powerful a tool as Excel.  Not sure how to say this better because I am not writing it off

Tagged with: , , ,

Autocomplete Workaround for Validation Dropdowns

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown

Tagged with: , , , , ,
Top