Profile

Cover photo
Contextures Inc.
278 followers|113,066 views
AboutPosts

Stream

Contextures Inc.

Shared publicly  - 
 
Find Excel help, new functions, conferences, sheet protection
Read this + more in my weekly #Excel roundup

In this week's roundup, find Excel help, new functions, Excel conferences, and much more. Excel Roundup http://blog.contextures.com/. 1. Run Code on Double-Click. In my Data Validation Multi-Select Kit, or other Excel code, make a small change to run faster in large workbooks.
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Make a small change to #Excel worksheet code so it runs faster in large workbooks
Use BeforeDoubleClick instead of SelectionChange to control when the code runs

In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you've bought a copy of my Data Validation Multi-Select Premium (DVMSP) kit, it shows a pop-up list when you click on a cell with a drop down list. I'll show you how to quickly change that, ...
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Does one pivot table make you the office Excel guru?
Do Excel chart colours make you cry?
Here are this week's best #Excel tweets, for your Friday entertainment.

If Excel's stupid colours make you (or your friend) cry, a glass of wine might help. Or, as a last resort, try some pivot table pizza! Please click to
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Excel dashboard charts, status bar messages, array formulas, rounding problems
Read this + more in my weekly #Excel roundup

1
Add a comment...

Contextures Inc.

Shared publicly  - 
 

Show macro progress update messages in #Excel Status Bar

1
1
Lee Partington's profile photo
Add a comment...

Contextures Inc.

Shared publicly  - 
 
How many monitors do you need to work in #Excel?
Are you the only one who knows how to delete an Excel column?
Here is this week's collection of #Excel tweets, for your Friday entertainment.

1
Add a comment...
In their circles
238 people
Have them in circles
278 people
Nanda Kumar's profile photo
Debra Dalgleish's profile photo
Artur Walulik's profile photo
Nina Kouk's profile photo
shiv nagle's profile photo
Need For Excel's profile photo
m. sonbaty's profile photo
Rob Lego's profile photo
Michael Pruski's profile photo

Contextures Inc.

Shared publicly  - 
 
Has #Excel made your life easier today?
Recommended Pivot Tables - love or hate?
Here's the best of what people said about #Excel this week, for your Friday entertainment.

Have you ever hit anyone with a pivot table? No? Not even after taking too much cold medication? Okay, go back to your pie charts. If you like this
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Excel dinosaurs, better charts, fix numbers, stopwatch
Read this + more in my weekly #Excel roundup

1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
How to Fix #Excel Numbers That Don't Add Up

If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data can look like numbers, but Excel sometimes sees those numbers as text -- not real numbers. You can fix the numbers manually, as shown in the video below, ...
1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Do Excel charts make you hungry for pie?
If you say "pivot table" too often, do people think you're a nerd?
Here is this week's collection of #Excel tweets, for your Friday entertainment.

1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Excel random numbers, big data, floating forms, chart labels
Read this + more in my weekly #Excel roundup

1
Add a comment...

Contextures Inc.

Shared publicly  - 
 
Show #Excel macro buttons on floating form -- move to any area of the worksheet

1
Add a comment...
People
In their circles
238 people
Have them in circles
278 people
Nanda Kumar's profile photo
Debra Dalgleish's profile photo
Artur Walulik's profile photo
Nina Kouk's profile photo
shiv nagle's profile photo
Need For Excel's profile photo
m. sonbaty's profile photo
Rob Lego's profile photo
Michael Pruski's profile photo
Contact Information
Contact info
Email
Story
Tagline
Business solutions with Microsoft Excel and Access
Introduction
Providing Excel tips and tutorials at Contextures website.

Custom business solutions using Microsoft Excel and Access.