Excel won’t scroll down or otherwise? Try this

Dave Farquhar Office, Software ,
Excel won’t scroll down or otherwise? Try this

I regularly work with Excel spreadsheets with tens of thousands of rows, correlated. Or hundreds of thousands of rows of raw data. Working with gigabytes of data taught me a lot. Including things it wasn’t supposed to, like what to do when Excel won’t scroll down or otherwise with the keyboard, or Excel mouse scroll isn’t working.

Large, complex Excel sheets are pretty fragile. Among other things, the largest of the sheets will stop scrolling. The scrollbar on the right scrolls, but the display doesn’t move. The mouse wheel scrolls, but again, the screen doesn’t move. And the arrow keys don’t work either. I can’t scroll down, I can’t scroll right, or do anything useful with the data because I can’t see the whole worksheet. In this blog post, I cover two ways to solve the problem when Excel won’t scroll.

Read more

Hints for surviving if the shutdown put you out of work

Dave Farquhar Saving money , , , , ,

I’ve seen plenty of news stories of how the government shutdown is affecting 800,000 or so government employees. What the news stories fail to mention is a large number of contractors are out of work too, until this passes. I can only guess on that number, but there’s no doubt it numbers in the millions, and little doubt it’s in the tens of millions.

As a former government contractor myself, I dealt with losing my job unexpectedly earlier this year, so some tips on dealing with an unexpected loss of a paycheck, even if it’s temporary, are fresh in my mind. There are five things you have to do.

I’m not here to gloat about anything. I’m here to try to help. Some of these things won’t be pleasant, but they’ll reduce pain in the long run if this lasts longer than a week. Keep in mind that everything I’m advocating is something I’ve done myself.

Read more

Why there’s scarcely any aftermarket firmware for Hisense Sero tablets

Dave Farquhar Android ,

Are you curious why there’s no Cyanogenmod for the Sero 7 or Sero 7 Pro tablets? Or why there’s only one aftermarket ROM for it, released way back in May, with no updates?

I realized why this week. Hisense has not yet released the GPL source code for the tablets. And without developers being able to look at the kernel source, you’ll see very little, if any aftermarket firmware for these tablets.

I know a few people have posed the question via Hisense’s Facebook page. Here’s a sample letter. Read more

How to disable wallpaper when you’re not running Cyanogenmod

Dave Farquhar Android , ,

Unfortunately I can’t run Cyanogenmod on all of my Android devices (more on that tomorrow), but if you want to save some memory and CPU cycles and, depending on your device’s display, perhaps even increase your battery life by a few dozen minutes, there’s an option.

The Cyanogenmod No Wallpaper feature is available as a small app in the Play store. Simply download it, then tap and hold your home screen and you can select No Wallpaper.

Besides the benefit of decreased memory usage and increased battery life, I found the minimalist look quickly grew on me.

Speed up Android with these six tips

Dave Farquhar Android , , , , , ,
Speed up Android with these six tips

I’ve talked before about how to disable animation in Cyanogenmod 10.x, but I’ve done a few other things to conserve some scarce system resources on my gigahertz-ish, half-gig Nook Color. If you’re running Cyanogenmod on a phone that’s a couple of years old, these tricks can help you too. Here are some tricks to speed up Android. Read more

Fighting OS rot and lag in Cyanogenmod 10.3

Dave Farquhar Android , ,

So I have Cyanogenmod 10.3 running on a Nook Color that I use as a secondary tablet. It’s outmoded, but still useful enough that I want to keep it around. But a week or two ago, it suddenly started to lag really badly. So I looked into it a little bit.

Some other Android tablets have some trouble with TRIM. Android generally handles it decently on its own, but it doesn’t always seem to. I found an app–for rooted tablets only–called Lagfix that lets you force TRIM yourself. Read more

Ctrl-Alt-Del history: non revisionist edition

Dave Farquhar Retro Computing, security
Ctrl-Alt-Del history: non revisionist edition

When it comes to Ctrl-Alt-Del history, there’s a lot of selective memory going on.

Bill Gates said in September 2013 that he regrets the use of Ctrl-Alt-Del as a logon sequence, while David Bradley, the IBM PC engineer who built that feature into the first IBM PC, says he doesn’t know why Microsoft chose to use that sequence for logon anyway.

Both of them, for whatever reason, are forgetting a few things.

Read more

“Mario” from “Microsoft” calls the wrong guy

Dave Farquhar scams, security , , , ,

“Mario from Microsoft” called me last night. I’ve never heard a Mario with that kind of accent, and, I thought he worked for Nintendo. I’ll bet he gets that a lot.

“Microsoft has no reason to be calling me,” I said to “Mario.”

“Oh, we’re a Microsoft certified partner,” he said.

“That’s nice,” I said. “I’m certified too. What’s going on?”

“You are having computer issues,” he said. Read more

How to take a screen capture of a web site in Windows

Dave Farquhar Windows

I can’t imagine needing to take a screen capture of a web site terribly often, but I have had to do it a few times in the past year. I used Snagit to do it, and it didn’t always do the best job–sometimes the program would crash, or the CPU would race and I would have to resort to ctrl-alt-del to get things back to normal–and not get my screen capture.

IE Capt is a small, standalone utility to do just that. Feed it the URL you want to capture, and it uses Internet Explorer’s Trident engine to render the page and outputs it to an image file for you. If you’re comfortable with the command line, it’s a faster, easier way to get your screen capture. And it’s free, which doesn’t hurt either.