This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:
It sometimes happens that you open an Excel worksheet to find that one or more columns are missing - in the example below Column A has mysteriously disappeared - so what’s going on?
Well, before doing anything see if you can spot the difference between the following two images… they’re not identical and the difference is crucial to telling you why Column A is missing.
Did you spot the difference? Take a closer look at the horizontal scroll bar ↑
In the first picture it looks as though you can scroll to the left to see Column A - if nothing changes when you try to do this then Column A is simply hidden from view and there are a couple of ways you can unhide it again - either by moving your cursor to the line just to the left of the letter B in the column headers and seeing if it turns into a horizontal double arrow with TWO vertical bars through it, like this, indicating that there is something hidden there. When the cursor changes this way you can simply click on the line and drag it to the right to unhide the column, or you can type A1 in the Name Box (that’s the white box on the left, just above the column headers) and press the Enter key to go to that cell… even if it’s hidden. This is useful to know because you sometimes might want to check the contents of a cell in a hidden column without unhiding it, so this is how to do that. Once you’ve selected that cell you can then go to Format… Column… Unhide to make it appear (Office 2007+ key strokes Alt+O…C…U).
In fact it’s quite possible to lose Column A without it being hidden in the usual manner at all, so no amount of trying to unhide it will do any good. What then?
The reason why this may happen to you is if your worksheet’s horizontal scroll bar is fully to the left - this indicates that you have FREEZE PANES activated on your worksheet. In this case all you need to do is unfreeze the panes from the Window menu (Office 2007+ key strokes Alt+W…F) and you will be able to scroll to Column A.
I feel somewhat vindicated in my stance that the correct term for “good banter” in Ireland and Britain is “crack”, not “craik”, and not “craic”.
It seems that the correct spelling was and will always be “crack”.
The so-called Gaelic spelling (craic) is a fairly recent introduction and is not a Gaelic word at all, it is purely an attempt to make a Gaelic-sounding word out of the original - perhaps because of the narcotic connotation of the correct spelling or maybe just because too many people from the old country want to sound like they’ve just stepped off the steamer from Queenstown.
I’m sure it will continue to be used in all of the thousands of “Irish Bars” which are dotted around the world and will, eventually, be pronounced “crake”.
So there you have it.
If you ever run into a situation where you want to get rid of everything but the text before or after either the first or last space in a cell value then here’s a great formula to do just that.
The formula looks complicated but, as with all complicated Excel formulae, it all makes perfect sense once you break it down. [Read More…]
I have a recurring problem with my media PC dropping the HDMI audio output to my big Sony TV - and I keep forgetting how to fix it (because it’s quite a simple fix but it’s not that obvious how to do it).
Why this happens is anyone’s guess but, for some reason, the TV gets disconnected or disabled somehow - AND THEN HIDDEN in the choice of speakers when you click in the speaker icon in the system tray (where the clock is).
Here’s where I refreshed my memory but, although this says it is for Windows 10 it does also work just the same in Windows 7, which is what I have installed. You may find some additional solutions there, if this doesn’t work for you:
I knew I had to right-click somewhere and get the Plackback Devices panel to show my TV as an option but I couldn’t remember where. Well, all you need to do is RIGHT click on a BLANK AREA of the panel (right-click on the speaker icon then choose “Playback devices” to show the panel, then see the picture below) and then make sure that both “Show Disabled Devices” and “Show Disconnected Devices” are checked.
This continues to solve the problem for me. I hope this has helped you too!
We bought a few Philips 274E (274E5QHAW) monitors for our office and they’re great - except that one of them steadfastly refused to play any sound.
After much testing I figured out that the problem was with the monitor itself and nothing to do with cables, drivers, or anything else.
The answer was right in front of me… [Read More…]
One of the most frequent things I forget how to do is the replacement of line breaks in Excel cells. You can put a line break in an Excel cell simply by pressing Alt+Enter while you are typing in your data, but sometimes you want to replace some of the text PLUS the line break.
To do this is equally simple (once you know how) just by entering Ctrl+J so say you have a cell with the following data with a line break in it:
and you want to either replace or even remove the top or bottom line you would go to your Find & Replace dialogue box (press Ctrl+H) to bring this up and then enter either of the following in the “Find what:” box…
To remove the top line type “ABC” then press Ctrl+J (it will not actually show anything because the Find what box is only one line high, and you might just be able to make out the top of the insertion point I-bar cursor flashing below the A), then type in whatever you want in the “Replace with:” box - or just leave it blank if you want to delete that top line.
To remove the bottom line first press Ctrl+J THEN type “XYZ”. In this case you might not see anything when you type the “XYZ” except (again) the flashing top of the cursor moving along as you type the letters on what a line which is hidden by the restricted height of the “Find what:” box.
Thanks to Debra Dalgleish for this excellent tip ever at her equally excellent Contextures Blog…
Nickelodeon’s WITS Academy Headmaster Todd Allen Durkin is the nephew of Eraserhead star Jack Nance:
David Lynch funded this documentary about the star of possibly the strangest, most intensly photographed film I’ve ever seen.
Just happened to see Jupiter following the Moon up through the trees this evening. Go cross-eyed to see the 3D image - click on the picture to see the full size version.
Open Live Writer is the new open source version of Microsoft’s wonderful blogging tool Windows Live Writer, and users of the latter will feel VERY at home with the new open source version (as it’s pretty much the same thing!).
In my previous post I gave you my first impression of it - there was a slight hiccup when I tried to set it up with my first blog account, but here is how to add another blog account once you’re up and running. [Read More…]
Windows Live Writer is/was a great blogging tool but Microsoft haven’t really supported it for some time now, so thanks to them for allowing it to become open source so it can be developed by the large community of users who love it to bits.
This is my first post using Open Live Writer on FlatPress and it was relatively easy to set up, but not so straightforward as it could have been… so here’s what FlatPress users may* need to know in order to get it working. [Read More…]
If you own a Dell laptop and suddenly find that the orange battery light is winking at you then maybe it’s time to get a new battery… or maybe your laptop’s power meter is simply lying to you. If this happens to you then here’s something to try first before all else. [Read More…]
There are lots of suggestions out there in “IT Professional Land” about how to provide your common or garden computer user with just enough privileges to allow them to install a printer.
The problem is that often it’s the computer user themselves who need to know how to do this WITHOUT involving their IT people who, more often than not, end up asking the question on a web forum and get mixed up in all sorts of conversations (and sometime arguments) about which is the best way to do it - wouldn’t it be great if there was a trick to it all? Well, try this one… [Read More…]
Cheap way to add USB 3.0 for short-term use (e.g. to save data from an old machine)
I tried this on 2 nearly identical machines and it worked well on only one of them - the other was a little temperamental. The little plastic spacer is difficult to attach so that it stays put, and pushing the USB plug in the end of it actually made the card pop out of the slot, so I resorted to attaching the USB cable before inserting the card.
That being said it was cheap and did the job I wanted it for (to transfer a lot of data from one machine to a Buffalo Drive), but I’m glad that the newer machines all have USB 3.0 sockets built in.
If you’re looking for something a bit more permanent then I would have a shop around for something which gets a few more thumbs up than I can give this.
Still great games but beware that Underground “needs help” to run on Windows 10
Beware that only Underground 2 and Most Wanted will work on Windows 10 - “Underground” appears to be too old for Microsoft’s liking and falls under the growing number of old games which use SafeDisc DRM (Digital Rights Management). Due to vulnerabilities with SafeDisc Microsoft did not include support for it in Windows 10, and have also disabled it via updates in previous versions of Windows (though there is a workaround to get your games to play in Windows 8/7 & Vista).
In case anyone has a problem installing one of the games after installing Most Wanted then you need to rename the Most Wanted game exe file in your Program Files folder from Speed.exe to something else (e.g. SpeedMW.exe) before trying to install the other game, otherwise the Underground installation program thinks that you already have Underground installed, showing you a “Play” option instead of “Install”. Just one star off for that little inconvenience.
No problem with the quality of the product supplied - excellent on that front, just beware if you have Windows 10 then you’ll only be able to play 2 of the 3 games without a little work (all three will install - but only 2 will play) unless you set your computer up to dual boot with (say) Windows XP to play your older games, or you hunt around for a no-cd crack (which is illegal, but it seems as if that’s what Microsoft are forcing genuine owners of these older games to do). If you do go down that route then you’ll probably have some success if you replace your installed game EXE file with for one suitable for NFS Underground Euro Version 1.4, if you bought this set from amazon uk, like I did* ;)
* note that although this is a “No CD” crack it DID ask me to insert Disc 2 into my computer, though when I did this it seems as though the DRM check was avoided and the game then played as normal.
A nice upgrade from Windows 7 - maybe not worthwhile if you have Windows 8
Apart from some niggles running games I actually quite like Windows 10 - not enough to give up on good old XP Pro on my own computer just yet, but I upgraded my son’s Windows 7 machine and much preferred it. I’ve never used Windows 8 but if you’re happy enough with that then you may as well stick with it - especially if you own a few older games such as NFS Underground which use a particular type of Digital Rights Management because Microsoft have blocked these games from running in Windows 10.
If you’re not a gamer then Windows 10 offers a familiar-looking interface with a Start button. I first installed the free version a few months ago and, now that most of the teething troubles seem to be sorted out, I bought this and just used the serial number to activate the version I already had installed - the nice looking USB stick with Win 10 on it is still in the box but I did install my current version from a USB stick and it was very easy.
Aside from removing the Activation watermark from the screen the activation key also unlocks the customisation options which let you choose a profile picture and set a folder of pictures as your desktop wallpaper, etc. We could probably could have got by without activating it, but I bought this as a present and it’s nice to see a nice watermark-free screen with everything working as it should.
Beware that Windows Media Player doesn’t seem to be included in Windows 10 but I just downloaded and installed Media Player Classic which is part of the K-Lite Mega Codec Pack, which is my own favourite.
I also installed Office 2003 on Windows 10 64 bit and it runs perfectly, as do all the other programs I’ve installed (IrfanView, 7-Zip, Windows Live Writer, Opera 12, to name but a few).