If you use Internet Explorer as your web browser (according to my server logs, that's 80% or so of you), you might be using its AutoComplete feature. AutoComplete saves previous entries you've made for Web addresses, forms, and passwords. Then, when you type information in one of these fields, AutoComplete suggests possible matches. This information is encrypted and stored on your hard drive. If you're the only one on the computer this can be great, but if you share a computer in an office or classroom situation you might want to turn off AutoComplete for one or more categories. Here's how:
Here are the step to performing a simple conditional format: 1) Select the range you wish to format, G2-G5 in the example. 2) Select Format > Conditional Formatting... and the dialogue box shown below will open. 3) From the first dropdown box, select whether you want Excel to evaluate the cell value or the formula; a second dropdown box with comparison criteria to select will appear if you choose Cell Value. Select the comparison operator you want. 4) The final entry will be the value you are comparing the formatted cells to. We're not done yet!
Now, select the format for the cells that match your condition: 5) Click the Format... button. For conditional formatting, you can select Font Style, Underline, Color, Strikethrough, Cell Borders, and Cell Patterns (colors). Format your heart away! 6) Click OK twice, and now you're finished! Next time we'll take a look at adding multiple conditions!
Last issue we took a look at the Conditional Formatting feature available to Excel users; today let's expand on the topic just a bit and use more than one condition:
Lower expense totals (<750) are shaded green; mid-range (750 < X < 2500) are yellow, and those pesky high expense items (>2500) are red. Individual expense cells could also be formatted using the same method, thereby increasing the chance that data anomalies are discovered before things get out of hand...and thus save your company from the fate of an Enron or WorldCom!
Was the last time you saw your Desktop wallpaper the day you brought your computer home? Are there so many icons on your desktop that it takes you 30 seconds to find the one you’re looking for? If so, help is here!
I) Create ANOTHER icon! – Right-click on your desktop. Choose New, then Folder. IMMEDIATELY, type a new name for your folder, for example: “Games”. Tap your Enter key.
II) Start with your first “game”-related icon. Click&drag the icon on top of your new folder, releasing your mouse button when the destination folder changes color. Your icon will ”move” into the folder. Move every “game” icon into this folder.
III) Continue to create folders and move icons into them until you’ve reclaimed your desktop. Note, folders can also be moved into folders – for families with several children, for example, each child might have a folder. All children folders could be moved into another folder named “Kids”.
IV) Double-click your folders to access your file icons.
The Recycle Bin can be a wonderful friend if you accidentally delete a file or folder – just open it up and remove the misplaced item. However, have you ever considered just how big that friendly little trashcan is?
Windows is configured “out of the box” to set aside 10% of your hard drive as reserved for the Recycle Bin. Yep, if you have a newer computer with, say, 4.3 gigs of space, 430 MEGS of hard drive space is available for storage of – TRASH! For those with smaller hard drives, the fact that Windows can stake out 10% of your available space should be even more worrisome!
You can reclaim your valuable real estate like this:
I) Right-click on your Recycle bin icon, and select Properties.
When working with Drawing Objects, you might want to change the size of the object without changing its shape. To change the size of the object, select the object by clicking directly on it, then position your cursor on a handle (“square block”). When your cursor changes to a double-headed arrow, click&drag in the desired direction.
While there are many ways to select blocks of text or cells, there's no way quicker or more adaptable then the simple "click-shift-click" method.
What’s the proper way to remove unwanted programs AND their supporting files from your computer? Many people will find the folder where the program is saved on their drive and simply delete it. Unfortunately, this will often leave additional support files scattered, orphaned, on your machine. Additionally, this method will not remove any pertinent entries in your Windows Registry – which frequently leads to mysterious system operation problems and slowdowns.