Ok people. Repeat after me – "A color is not data".
Every so often I get a spreadsheet from someone who thinks that colors play a major role in data management. You know – those people who happily say "I tagged those records with Yellow". Oh really? I don't think my version of Excel has a "Yellow" data type.
It's been a busy week and I've been working hard. I think I'll reward myself by writing a blog post for people I've never met. Here we go.
Let's talk about getting Access Memo Fields into Excel.
Today, I want to show you how to use the Skip Blanks option in the Paste Special dialog box. You've all probably seen it there, but you've never used it.
Here it is in the expertly placed square box.
If you move data from Excel to Access on a regular basis, you'll know that sometimes Access can't resolve the data being imported from Excel. In these cases Access automatically creates a new table called ImportErrors..
. » More: Clearing Access ImportError Tables
I recieved an email from Hari, who writes:
"I saw your post about smart scrollbars…how do I make scrollbars accept percentages?"
First of all Hari, may I say you have great taste when it comes to the Blogs you read. Now to answer your question:
Unfortunately, Scroll Bars in Excel only accept integers. That is to say, it can't pass values like .82. The trick is to use a simple formula to convert the whole number outputs from the Scroll Bar.
Welcome back from the long holiday season. OK…who forgot their passwords after two weeks of being gone? I bet a few of you had to call the help desk for a password reset.
Anyway, the first post of the new year is something light; how to add pictures to your buttons in Excel.
I'm no Tiger Woods, but I get my share of lady fan mail. Today, I get an email from Dawn.
She asks: "Do you have an easy way to flip a range so that the bottom row is at the top and the top row is at the bottom?"
I have two methods for doing this.
Excel Annoyance #119: Sticky Click.
Every so often, my Excel gets into a state where no matter where or how I click, it highlights a range. That is to say, it anchors the current cell, then highlights a contiguous range from the anchored cell to wherever I'm clicking next. I call this Sticky Click.
