When using large Excel spreadsheets, a useful tip is to split the screen to display multiple parts of the same spreadsheet on the one screen. For example: to always keep a heading row static in one view, while independently scrolling through the spreadsheet content in another view. You may have noticed at the top of the Excel vertical scrollbar there is a thin grey button (the split button) and when the mouse is hovered over the button, the mouse cursor changes to a vertical resize cursor. To split the screen into two separate views, click and drag the split button downwards. During this process, a line will also appear across the spreadsheet to show where the split will occur. You can also split the screen on the horizontal scroll bar and you may notice the split button at the right-hand end of the horizontal scroll bar. In either case, should you wish to remove the split screen, simply double-click on the split, or drag the split back to its original position (at the top, or end, of the scroll bar). (more…)

Whenever running Windows AntiSpyware, Spybot Search & Destroy, and Ad-Aware, the following two items reappear, even after being removed during a previous scan: EGroup.IEAccess.C and MagicControl Agent. I am also running Vet Antivirus, which is also up-to-date. How can I permanently get rid of these items? The computer is running Windows 98. (more…)

Whenever attempting to create a new folder with the name ‘Con’ this name does not hold, and the folder name automatically defaults to ‘New Folder’. Why does this occur? The computer is running Windows XP. (more…)

When the computer starts for the day, the following message always appears: ‘Media Consumer. The Engine is not running!’. I am not aware of any program on my computer called Media Consumer, so I do not know to what the message is referring. The computer is running Windows XP. (more…)

My laptop shuts down during scans with programs such as Norton Antivirus or Spybot Search & Destroy. Does this indicate there is something nasty on the computer which does not like being scanned? The computer is running Windows XP Home Edition. (more…)