Monday, November 17, 2008

Microsoft Excel Shortcut keys

Microsoft Excel Shortcut keys


Auto sum shortcut key : Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .

Create hyper links in Excel : Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once : Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".

Quickly open recently opened files : Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.

Create underlines without any text : This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name:  .

Print only sections of a document : Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.

Repeat recent action : Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.

Quickly undo : Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.

Quickly above cell contents : In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.

Using the Microsoft Excel Auto filter : Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data



How to start windows programs quickly with Run Command...?


How to start windows programs quickly with Run Command...?
The run option of Start menu is used to run a program or to open a document directly. If you

Do not know the exact location of the program or document then click on Start button to open

Run and type the programs shortcut name to open it directly.

Run Commands

Appwiz.cpl -- Used to run Add/Remove wizard

Calc --Calculator

Cfgwiz32 --ISDN Configuration Wizard

Charmap --Character Map

Chkdisk --Repair damaged files

Cleanmgr --Cleans up hard drives

Clipbrd --Windows Clipboard viewer

Control --Displays Control Panel

Cmd --Opens a new Command Window

Control mouse --Used to control mouse properties

Dcomcnfg --DCOM user security

Debug --Assembly language programming tool

Defrag --Defragmentation tool

Drwatson --Records programs crash & snapshots

Dxdiag --DirectX Diagnostic Utility

Explorer --Windows Explorer

Fontview --Graphical font viewer

Fsmgmt.msc -- Used to open shared folders

Firewall.cpl  -- Used to configure windows firewall

Ftp -FTP.exe program

Hostname --Returns Computer's name

Hdwwiz.cpl -- Used to run Add Hardware wizard

Ipconfig --Displays IP configuration for all network adapters

Logoff -- Used to logoff the computer

MMC --Microsoft Management Console

Msconfig --Configuration to edit startup files

Mstsc -- Used to access remote desktop

Mrc -- Malicious Software Removal Tool

Msinfo32 --Microsoft System Information Utility

Nbtstat --Displays stats and current connections using NetBIOS over TCP/IP

Netstat --Displays all active network connections

Nslookup--Returns your local DNS server

Osk ---Used to access on screen keyboard

Perfmon.msc -- Used to configure the performance of Monitor.

Ping --Sends data to a specified host/IP

Powercfg.cpl -- Used to configure power option

Regedit --Registry Editor

Regwiz -- Registration wizard

Sfc /scannow -- System File Checker

Sndrec32 --Sound Recorder

Shutdown -- Used to shutdown the windows

Spider -- Used to open spider solitaire card game

Sfc / scannow -- Used to run system file checker utility.

Sndvol32 --Volume control for soundcard

Sysedit -- Edit system startup files

Taskmgr --Task manager

Telephon.cpl -- Used to configure modem options.

Telnet --Telnet program

Tracert --Traces and displays all paths required to reach an Internet host

Winchat -- Used to chat with Microsoft

Wmplayer -- Used to run Windows Media player

Wab -- Used to open Windows address Book.

WinWord -- Used to open Microsoft word

Winipcfg --Displays IP configuration

Winver -- Used to check Windows Version

Wupdmgr --Takes you to Microsoft Windows Update

Write -- Used to open



Sunday, November 2, 2008


Explanation of virus


1) Virus is a little program whos activity can destruct/destroy
some files and a computer system. If this program does not open, it's
inactive and could not or will not destroy anything.


2) The virus program is brought to you by an email as attachment. It
has a server itself (virus server). File virus attachments cannot go to
another email, such as an email was sent by user (netter), member,
moderator etc to be as their attachment. It must be brought to you by
itself,that we called EMAIL Of VIRUS.


3) EMAIL OF VIRUS would be sent by any email address of any account,
that it found and cracked from some mailbox or address-book of other
anywhere. So that why the email of virus looks like it was sent by our
friend, our member,our moderator etc..... even it is able to email a
virus by our own email address.


4) To identification of virus attachment:
a). it has a small size ( <150KB )
b). it has extension file name such as below:
and some time it's compressed by *.zip file.
Also by the fake name HotMovie.MPEG_ _________ scr.
Actualy the file is virus file with extension .scr


5) You are would able to understand an email virus from their SUBJECT,
most of them contains an amazing statement or unsusal word, such as
Weah ^_^ :))
Hi :)
Hello -:))
Hey, dude, it's me ^_^
access Mpeg
Re:your text
Re:Text message
Re:Msg reply
Re:Is that your document?
Re:Hot Movie(MPEG)
Re:Information. ..
Re;Important info
Re:This is your photos!:)
and more, and more...
If you received emails with the subject matter as above, you
should delete even with out openin.


Don't have words in ur email subject which resembles a virus mail
Otherwise your email would be deleted by recipient[s] .

BEAWARE it's dangerous.

*** If one of your file is infected by virus, it will change into
function of a virus and might infecte all files in your hard disk.

Thanks & Regards
Management Net-Fellows

Feedback/Suggestion s:



Popular Posts