Tag Archive: Web page

Microsoft Excel

Image via Wikipedia

We all love the ability to organize data, in spreadsheets.  I love Excel 2008 and its other versions, though I always am aware of ways that things can be improved.  I’m sure the tip in this article for Excel 2008 for the Mac will apply to other versions as well.

Okay—so if you’re using the spiffy new Excel 2008 for Mac—you may have had the chance to learn some new things over and against the older versions.

One thing that you may have learned to do (in older Excel versions) is keep data relevant by maintaining the visibility of row-header (left column) and column-header (top-row) title information by using the Excel option freeze panes from the window menu. (This is from a list of Excel tutorials—which did seem to pose some problems for a few people accessing it.)

You might have a problem using this option, if you’re working in Mac’s Excel 2008.  The reason would be that you’re in the Page View mode, rather than the Normal View mode—which can be selected from the “View Menu.”

I like the “Page Layout” view because it gives you the feeling of holding ordinary paper, and gives you the view of what your printed Excel sheets will look like, but because freezing panes does not affect printing, it cannot thus affect how “Page Layout” view will look.  “Normal View” is where you want to be.

This answer was found on the following help forum thread: “Excel Freeze Panes ghosted – Why?” which taught me an invaluable lesson about forum diving:

Forum Help Tip #1: Scrolling to the bottom of a help forum may save you some time, though I may have learned more by reading the whole thing.  (The above forum thread has the answer at the bottom—as the last post.)

So, true to form, as mentioned above:

If you find yourself asking “How do I freeze panes in Excel 2008 for the Mac?” and can’t freeze panes because the option is gray / greyed-out, ghosted, or whatever you call it, here’s your answer:

Use “Normal” view, not “Page Layout” and Freeze Panes will work fine.  (Use the “View” menu.)

P.S.  Having to research this tip helped me remember why I was blogging, and lifted me out of a doldrums of existential questioning about the life of this blog itself, at least for the moment.  This experience with not being able to freeze panes in Microsoft Excel 2008 for the Mac left me with this thought: in other words: one practical reason I started this blog was to remember/record ways of helping keep track of vital things I’d learned in an easy-to-find place, while sharing them with other people.

P.P.S. I’ve discovered (having lost this article once) that WordPress doesn’t seem to autosave all the data in a blog post (not my main text, anyhow—though my zemanta assisted keywords and meta-stuff remained).  Maybe composing in Google docs or the like would be a better idea?


WordPress bloggers, read on: The quest to which I refer is that of a long-standing desire to find a simple way to on-the-spottishly grab some sort of webpage, or whatever cool new thing I came across and quickly throw it into a spot where I could grab it later.  Though I had known about and explored social bookmarking, including a somewhat (but little) used del.ico.us account, I still found myself looking for something more.

That something would be later evolved, in part, into this blog.  Thus the part of the quest that involved storing and sharing the information was then done.
The full-on mission objective that I’m talking about is this: I wanted to have a way to handle all the cool-new things that we were finding online and record, save, store and share them.  The problem with learning so much is that you have to save it, remember it—that’s our job as human beings—we our responsible to remember things that are important.  It’s one of those rare human gifts, perhaps setting us apart from animals and inanimate objects moreso than walking upright, using fire, or any other technology—we are perhaps the only instrument by which a serious, detailed record of the past is imposed on the Universe…

But perhaps a wax philosophic.  I do!

So, anyways, the point of this blog was to save things—save information, and then share them with others, and all the good things that come along with that.  The question then is, now that I have all these things shared, how do I quickly harvest all this low-hanging fruit that I am constantly coming across?

Here’s the solution: the “Press This” button or “add-on” or whatever it’s called.  Apparently, it’s a little do-dad that you can download from the WordPress site, assuming then that you have a WordPress blog and you are using it to keep track of, and share interesting things that may have related how-to sites, wikis, news articles, video-sharing streams, or what-have you online.  Now, if you are, this is a good thing for you to use.

The WordPress how-to site describes it like so:

Use Press This to clip text, images and videos from any web page. Then edit and add more straight from Press This before you save or publish it in a post on your site.

But  more-to-the-point, let me describe it as this: a quick way to grab the “low-hanging fruit” and throw them back into the “blog on this later bin.”  Very cool, and probably obvious—yet, I’m a bit skeptical as to whether or not most people knew about this.  Of course, there were always social-bookmarking toolbar buttons for your browser (which is what this highly resembles) but…nevertheless, this fits well, hand-in-glove, in-fact, with the whole idea of find, save, share.

%d bloggers like this: