Radschool Association Magazine - Vol 24

Page 4

Privacy Policy              |               Join the Association               |               List of Members               |               Print this page


Computers and stuff.


Sam Houliston.


Excel Tip.


When working on a large Excel file with entries in multiple cells, it’s a lot easier to read and understand all those numbers when you colour every second row. There are two ways of doing this, one is to hold down the Ctrl key, highlight every second row and then click FORMAT, then CELLS, then PATTERNS then select a colour. This works well, but, if you delete or insert a row or a cell at any time after doing this, it throws the whole thing out of whack. The other way, which is a heap easier, is to do the following


1. Select and highlight the range of cells you wish to format.

2. Click Format then Conditional Formatting.

3. In the drop-down box, select “Formula Is”.

4. In the box type:        =MOD(ROW(),2)=0

5. Click the Format button and then click the Patterns tab.

6. Select a colour for the shaded rows and click OK twice.




The real beauty of this method is that even if you delete a row or a cell in your table, the banding will be maintained automatically. If you find you don't like your chosen colour, simply select the range once more, open the Conditional Formatting box and choose another colour. 


A picture might be worth a thousand words, but it uses up three thousand times the memory.

Now, whenever you want to create a new folder in Windows Explorer, simply right-click on the folder in which you want to create the new folder and select the “Create New Folder” command from the context menu.



Vista RUN.


Where’s the Run entry on Vista’s Start menu gone? If you’re familiar with the Windows XP Start menu, and you've updated to Vista, you've probably realized that “Run” is missing in Vista. On Vista, Microsoft decided to hide this feature. It’s still there, though. Just press the Windows Key and R together and the dialog box will appear. However, if you want it to be on the Start Menu permanently, you can do it. Here’s how: 

  • Right-click on the Start button and click Properties. On the Start Menu tab, click Customize. 

  • The Customize Start Menu dialog will then be displayed. 

  • Scroll down to the Run command and check the box. 

  • Finally, click OK and OK again.


Analyse your hard drive.


If you're like most people, your hard drive quickly fills up with all sorts of stuff, music, pictures, data files, programs and other stuff. And even if you're good at archiving content onto DVDs or external drives, no matter how big it is, your PC's hard disk is often just about chockers. To keep your machine running at top speed, you have to perform regular maintenance and sometimes it helps if you know just what you have stored on that drive. Here is a handy little program which allows you do just that.

This free software, based on the Linux application KDirStat, gives you an informative visual display of your hard-drive usage. Click HERE and download the program WinDirStat. Run the program and you’ll see all of your files (for the drive or directory you decided to scan) displayed in a rainbow of colours. WinDirStat assigns colours to each file type, such as MP3, ZIP, EXE, JPG, and so on.


By default, the files that take up the most space are coloured blue, the second heftiest are red, and the third largest green. After the first 10 colour-labelled file types, the rest appear in gray--but you can change these settings and colours through the Options menu.


Once you've identified where your disk space has gone, you can then more easily decide where you can save space. WinDirStat is loaded with features for managing your files, such as the ability to automatically delete files without even bothering with the Recycle Bin.



Morris and his wife Esther went to the state fair every year, and every year Morris would say, 'Esther, I’d like to ride in that helicopter.'

Esther always replied, 'I know Morris, but that helicopter ride is fifty dollars, and fifty dollars is fifty dollars'

One year Esther and Morris went to the fair, and Morris said, 'Esther, I'm 85 years old. If I don't ride that helicopter, I might never get another chance.'

To this, Esther replied, 'Morris that helicopter ride is fifty dollars, and fifty dollars is fifty dollars.'

The pilot overheard the couple and said, 'Folks I'll make you a deal. I'll take the both of you for a ride. If you can stay quiet for the entire ride and not say a word, I won't charge you! But if you say one word, it's fifty dollars.'

Morris and Esther agreed and up they went. The pilot did all kinds of fancy manoeuvres, but not a word was heard. He did his daredevil tricks over and over again, but still not a word.

When they landed, the pilot turned to Morris and said, 'By golly, I did everything I could to get you to yell out, but you didn't. I'm impressed!'

Morris replied, 'Well, to tell you the truth, I almost said something when Esther fell out, but you know, fifty dollars is fifty dollars!'  


Back     Go to page:  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18     Forward