Skip to main content

Working on more than one Excel spreadsheet

Microsoft Excel by default opens all spreadsheets into the same Workspace, so it can be tricky if you want to work on multiple spreadsheets at the same time.

If you’re copying information between two spreadsheets, or want to compare data from two different sources, then it can be tricky to do. You might have experienced the problem of having to flick back and forth between two spreadsheets.

One way around it is to use the View Side by Side option:

  • Open the two spreadsheets you want to work upon
  • Select the View tab
  • Click on View Side by Side
  • To switch between the spreadsheets being on top of each other or side by side, click on Arrange All and select Horizontal or Vertical

It will look something like this:

However, that’s still not much use if you have two monitors, and want to have a separate spreadsheet in each monitor, because a maximised Excel worksheet only works in one monitor.

What you need is to start up two separate instances of Excel, and then each instance can be maximised¬†on separate monitors. The first instance of Excel loads in the normal way, and you open your first spreadsheet in that. The second instance of Excel can be started by holding down the shift key as you click on the Excel icon (either from the Start menu or Taskbar). A separate blank Excel worksheet will launch (it’s actually a second instance of the Excel program running) and you can load your second spreadsheet into that.

These separate instances run completely independently of each other, and one can be closed (or even killed in the Task Manager) without affecting the other.

Dublin Bikes

Just spotted the advertising for the new Dublin bike rental scheme – called, funnily enough, Dublin Bikes – which is due to be launched on 13th September.

With some 450 bikes available in 40 different locations in the city centre, users can take a cycle for free for up to 30 minutes, and after that it’s only 50 cents per half hour.

Simple Pleasures

Somebody showed me this morning how to turn the display of my computer upside down, and it’s been entertaining me ever since. I’m not sure if this works on all computers, but you could give it a go. Press Ctrl + Alt + Down Arrow to turn the screen upside down, and Ctrl + Alt + Up Arrow to restore it. Have fun.

MacBook Hard Disk Replacement

Last night I performed a hard disk upgrade on my Apple MacBook. The original 60GB disk that came with the machine has always been woefully inadequate from the start – particularly as I have about 64GB of music files alone. And so, up until now, I’ve always had to store my media files on an external drive.
The upgrade was inspired by various tutorials available on the net, and is made especially painless by the OS X Leopard backup tool Time Machine, which enables an easy restoration of files onto the next disk.
You can use any 2.5inch SATA disk drive as a replacement. I bought myself a 250GB drive from a local computing shop for just under €100, but you can probably get larger and cheaper drives online.
The physical swap over of the drive only takes about 5 minutes. Just follow the instructions in the online tutorals. But you might need several hours to restore the data onto the new disk afterwards. In my case, I had to partition the disk (using the Disk Utility on the Leopard install DVD), and install OS X onto the disk (taking about an hour), before restoring all my applications and files from the Time Machine backup – which took another couple of hours.

Asus Eee PC 900

I’ve been thinking about buying one of these Eee PC 900 laptops for the last week or so, because it’s so small and cheap, and would be perfect to carry around with me for a bit of casual web surfing and email.

I love my MacBook dearly, but it does get a bit heavy to carry after a while. Anyway, so I’ve been hunting around all the online retailers, and they all seem to be out of stock. And I suspect it’s down to the fact that a new model is about to be announced, and so the manufacturer has stopped making them.
The new model – the Eee PC 901 – is expected to be announced in early June, and sports the new Intel Atom processor, which is meant to be a lot more power efficient – thus giving the machine a longer running time when battery powered.
I spoke to a customer service representative from 20GB Linux White model will be back in stock in 3-4 days, they’re actually not expecting any more deliveries until mid June.