Title photo

Where I'm always right and no one can argue with me.

  • Mon
  • |
  • 09
  • Jan
  • 2012

How to define/name a range in Excel 2010

Here is today's tip. For me this comes up all the time when I do mail merges using an Excel file for the address data and a Word document for the actual letters.

In Excel 2010 I couldn't find the command I was used to finding under the "Insert" menu in earlier versions of Excel (pre-"ribbon").

I found these instructions online which told me exactly how to do it. (Of course, you have to customize a special sub-menu - why not? Thanks, Microsoft, once again.)

I thought I would pass this on to my many many many readers. ;)

  • Wed
  • |
  • 04
  • Jan
  • 2012

Today I hate cell phones

I hate when they quirkily don't do what they should. I hate when I have to call customer service at Verizon and sit through 4 prompts listening to messages about 3G versus 4G activations which do not apply to me before I can get a human being. I hate people whining about which phone they want and why they need an upgrade when they don't qualify for one yet through the carrier and their current phone works just fine.

I would in fact be quite happy to go back to everyone just having a phone at their desk and that's all. That would be kind of lovely.

(I manage the cell phones for everyone at my company, thus my day of cell phone extreme annoyance.)

  • Thu
  • |
  • 13
  • Oct
  • 2011

People spend 1/3 of their time online on Facebook. What the what?

I saw an article online today about Facebook "clouds" gathering over Google.

Do I care about Google's earnings or stock price? No, I don't own any Google stock. What I care about is what it means about technology, the web, and people's use of it.

Here is the most upsetting bit to me.

"With more than 30 percent of aggregate Internet minutes spent on Facebook, the Internet's center of gravity is shifting from Google to Facebook," explained Jordan Rohan, an analyst at Stifel Nicolaus, in a recent note. "The strategic position of Google is weakening."

I don't care that Facebook is taking internet traffic from Google. I care that Facebook is taking internet traffic from everybody.

Remember AOL? Yeah, that's what I thought.

Hey, I got sucked into Facebook too, I get it. It's fun to be in touch with your friends, it's fun sometimes (not all the time!) to get back in touch with old friends. It's easy to find people because Facebook "helps" you so much. I really do understand.

However, we don't need Facebook to send notes to friends. Email exists. We don't need Facebook to post our gripes, our joys, our frustrations, our funny stories. Weblogs exist. We don't need Facebook to share pictures. There are many ways to share photos online.

I don't like thinking my entire experience on the web is channeled through one place. One place which has a huge interest in mining my information and that of my friends to sell us stuff.

I'm not an idiot. I'm well aware that many things are ad supported. I'm also not going to complain about things I post online being made somehow public. You should censor yourself. Don't post personal information online if you don't want it shared. That includes on "private networks" like Facebook.

But I do have a problem with a company who is trying so hard to get everyone to do everything online exclusively through them. I'd like to think of a clever parallel to show you what I mean but I'm drawing a blank. Something like a cable provider insisting that you watch all television through some kind of master channel which they control, where they can watch what you watch, what you fast forward through, etc. But there's no real world comparison I can think of really.

So the closest thing I can point to is AOL. At one point a lot of people had internet access, dial-up internet access (remember that?) through AOL. And you didn't go to a website like cnn.com for your news. You went to an AOL landing page. And maybe they had some content from CNN or other places, but it was all filtered by/through AOL. Long term it didn't work. So I hope that means long term Facebook's plans won't work either.

But in the meantime I'm frustrated by everyone continuing to pour all their time and energy into a platform that doesn't give a shit about them. The web is supposed to be open and full of innovation and exploration.

  • Wed
  • |
  • 14
  • Sep
  • 2011

Adding page numbers to a pdf file

Ever wonder if it's possible to add page numbers to a pdf file after it's composed? For example, maybe you are combining 2 Word files and an Excel file and a couple of photos into one pdf to send to a printer or something, and you'd like all pages to have consistent page numbers.

Well it IS possible my friends! Thankfully the internet told me how.

How to add page numbers to a pdf file

  • Sun
  • |
  • 10
  • Oct
  • 2010

Just want to test ping.fm

I had sort of forgotten about ping.fm but I've been trying to figure out an easy way to have my blog updates post to facebook and twitter automatically.

So I just added my feed to ping.fm and now I'm posting something to see if it updates those accounts.

Happy long weekend everybody!

  • Wed
  • |
  • 03
  • Mar
  • 2010

Your random Blackberry tip for the day

We just instituted a policy at work of everyone with a mobile device such as an iPhone or Blackberry having it time out and lock with a password.

One of the Blackberry users reported to me that his Blackberry no longer vibrated to alert him to new messages when it was in the locked state.

I did a little testing and found that if you edit the profile you're using (in my case, the "Normal" profile) so that it always vibrates both in and out of the holster to alert you to new desktop messages, it fixes the problem.

Here's exactly what to do:

Read the rest of this post

  • Fri
  • |
  • 08
  • Jan
  • 2010

A quick blackberry tip!

I heart the internet. Did you know that if you're viewing your message list on a blackberry and you want to jump to the top of the list you just type "T" and to jump to the bottom type "B"?

The internet told me that.

Thanks, RIM!

Blackberry Support - Tips

  • Mon
  • |
  • 16
  • Nov
  • 2009

How to fix a non-repeating header row in a table in Microsoft Word

Wow, I am in love with online forums lately. I couldn't get the header row to repeat in a table I made just now though I don't remember ever having a problem before. Check out this tip from this forum, which solved my problem!

The easy trap to fall into is the "Floating Table" trap. Go to Table>Properties and check that Text Wrapping is set to "None". If it isn't, the table is floating ion the graphics layer of the document, it's
not part of the text page, and header replication does not operate.

Nice! Thanks, internet.

  • Tue
  • |
  • 03
  • Nov
  • 2009

How to view a Pages document on a Windows machine

If you screw up like I did and forget to export a file from Pages on your Mac as a Word document (or some other Windows-readable file) look at this great tip I found online in a forum!:

You just need to open the .pages file in winzip or winrar. In essence,.pages is a group of files. You will see all of them in winzip or winrar. One of them is preview.pdf. All you need to do is to extract it. It retains all the text and, best of all, all the formatting. This will allow you to print. However, if you want to edit it, it is getting a little complicated. You will have to download a PagesConverter from the Internet and use it to open the .xml file. You then can convert it to .txt file.

All I needed was the pdf so this worked perfectly! I just renamed my file with a .zip extension and easily found the preview pdf which was perfect. Thanks, universe!

p.s. Here is a link to the forum about viewing/accessing Pages documents on a PC.

  • Tue
  • |
  • 28
  • Apr
  • 2009

By the way, sidebar to be edited

Everything in the sidebar at the moment is authored by one robreed, to be edited at a later time by me. I think most people reading this are aware that I don't harbor an intense hatred for Facebook. Ha ha.