GudAnuf, Inc.
P.O. Box 139,
Locust Valley, NY 11560
Phone : 1-516-759-4219
Protecting cells:

When a cell contains formulas that you don't want deleted by accident, use the protection feature.

1. Press Ctrl + A to select the entire sheet.
2. Choose Format + Cells; in the dialog box that appears, click the Protection tab.
3. Deselect Locked and click OK.
4. Choose Edit + Go To.
5. Click Special.
6. Under Select, choose Formulas; then click OK. Excel selects all the cells that contain formulas.
7. Choose Format + Cells; in the dialog box that appears, click the Protection tab.
8. Select Locked and click OK.
9. Choose Tools + Protection + Protect Worksheet.
10. In the dialog box that appears, click OK (Passwords can cause more trouble than they solve).
11. Save the workbook.

If you need to change a formula in the future, choose Tools | Unprotect, change the cell, and then choose Tools | Protect Worksheet to protect your formulas again.


This Day in History
Deleting Files :
Did you know that you can delete files from the File | Open dialog box? Just right-click them in the list and choose Delete
Word of the Day

GudAnuf, Inc.™ (Where only the BEST is Good Enough)


How to make a screenshot

A "screenshot" is a snapshot of what's on your computer's screen.

To create a screenshot follow these steps:

  1. The first step is to create the windows that you want to capture and leave them up on the screen.
  2. Just to the right of your keyboard, you should see three groups of keys.  The lower set of keys usually is a group of arrow keys.  Above that is usually a set of some six keys that are labeled "Insert," "Home," "Page Up," etc.  Above that should be three keys that have rather odd labels - like Pause/Break and ScrLk.  One of those keys should be labeled PrtScrn/SysRq. Pressing Alt-PrintScreen (Alt-PrtScrn) places an image of the frontmost window on the clipboard. Pressing PrintScreen by itself places an image of the entire desktop on the clipboard.
  3. If you press PrtScrn/SysRq, nothing will appear to have happened.  However, your computer just took a snapshot of its screen and stored that picture on its clipboard, much as it stores information that you cut and paste.
  4. Open MS-Paint. (From Start/Run, issue the command "mspaint".) Create a new empty image, and use Edit/Paste to bring in the screenshot you just took. (If the screenshot is smaller than the default Paint canvas, you will end up with white areas. Start over: create a new empty image, change its dimensions to 1x1, and Paste again. The canvas will grow for the Paste, but it doesn't shrink.)
  5. Use MS-Paint to Save As, using PNG as the file format (it is superior to all the rest).

Other Notes

  • Instead of MS Paint you could also use Word, or some other word processing program, you can paste the image into it.  You can then save the Word document and email it to us as an attachment.
  • You may also be able to paste the image directly into your email, depending on what type of email program you have.  (Microsoft Outlook can do this, for example.)
  • If you press Alt and the PrtScrn/SysRq keys together, the computer will take a snapshot of the currently active window ONLY.  This can save some space in a Word documentor in an email.

This works on all versions of Windows: Win95, Win98, WinME, WinNT  and Win2000, XP, 2003.

As you have seen, making screenshots is FREE. No external software is required.


Today's Birthday