Formula mistake may occur in Excel

Errors	Notification
#VALUE	This error value is displayed if you use a cell reference in a mathematical formula that contains a piece of text. This error also appears if a selection is used without specifying a function.
#DIV/0!	This error value is displayed if you divide a value by zero (O).
#REF!	This error value is displayed if cell reference does not exist that is used in the formula.
#N/A!	This error value is displayed if value is not available or Excel Cannot Find the required Value
Circular	The circular reference is a special error message displayed in
Reference	form of dialog box. This error message occurs when a formula uses its own result as one of its reference or arguments. This error message is also indicated in the status bar showing the cell address containing the error.

Solution - could not activate cellular data network ipad!!!

HI friends, How are you??

Recently one of my Friend Met an Error Like this in his Apple IPAD. He have Aircel 3G Prepaid Micro Card.


"Could not activate Cellular Data Network"

Here is the Solution for that problem:

1. Goto Settings in the IPad,
2. Click the Cellular Data,
3. Goto APN Settings,
4. Enter the aircelgprs in the APN field,
5. Then "ON" the Cellular Data,
6. Restart the IPAD.

Thats all the problem will solved.

Warm Regards,

Mani.V

Outlook Gmail Forum - "Enter Network Password" Prompts Won't Quit Options!!!

Hi,

Recently one of my friend met this problem.

I searched the solution for this issue in the i-net and i got the solution which is hereunder:

	Whit33­© :

Now, please follow the steps below to resolve the problem:
close all mail clients you're using to read Gmail messages. (If you
use one at work and one at home, please disable both.)
From the computer on which your logins are failing, visit
http://www.google.com/accounts/DisplayUnlockCaptcha
Enter your Gmail username and password, and the letters in the
distorted picture.

Once you have successfully logged in, restart your mail client and try
to download your mail

Regards,

Mani.V
source: website

Excel - change the Upper and Lower value (solved)

Dear all,

Hope you all fine.

One of my friend ask this to me. Thats why i sharing this. It may useful!!!

If you wnat to change the Cell Value into Upper and Lower without edting the Cell Value.

For Eg.,

Change the Upper Value:
If you want to change the Name "john" (A1 Cell) into "JOHN".

Just using the Formula, =Upper(A1) and click the Enter. All the words Changed to UPPER.

Change the Lower Value:
If you want to change the Name "JOHN" (B1 Cell) into "john".

Just using the Formula, =Lower(B1) and click the Enter. All the words Changed to LOWER.

Thats all.

Warm Regards,
Mani.V

4 Easy Ways To Back Up Your Microsoft Outlook Data

HI friends,

Recently i founnd this from one website...

1.Manually copy your Outlook file

o The default location for XP is C:/Documents and Settings/%username%/Local Settings/Application Data/Microsoft/Outlook/
o The default location for Vista is C:/Users/%username%/AppData/Local/Microsoft/Outlook/
Outlook stores all mail information in a single file with an extension ‘.pst’. A ‘personal storage table’ file stores all account data like mails, contacts, journal, notes and calendar entries.
The PST file can also be accessed by following File – Data File Management – Select the Data File tab. Select your personal folder(s) and click on Open Folder…
After locating the file backing it up to any secure space like a different drive, a CD-ROM or a USB Drive is a simple process of copy-paste.
To restore the data, go to File – Open – Outlook Data File – Browse to the backup location and select the file. In case of an error, right-click and deselect the Read only attribute in the PST file’s Properties tab.

2.Relocate your Outlook file
In the same way we keep our other precious files from harm’s way by saving it in a different partition, we can also change the default location of the Outlook PST file. Here’s a walkthrough…

1.Close Outlook
2.Locate the PST file through the default path as mentioned before.
3.Copy it to another partition.
(As a precaution rename the PST file in the old location. For instance, change Outlook.pst to Outlook.old. In case something fails, you can return to the old file.)
4.Restart Outlook – when the prompt comes up use the browse button to direct Outlook to the new location.
5.Update any Wizard rules you might have customized with the new path.

3.Import and Export helps out

It is a 5-Step process which exports your mail folders to any designated location. Import and Export in Outlook 2007 allows you to export the entire Personal folder or selected folders to another location (or partition).
0. Click on File – Import and Export…

1.Choose Export to a file

2.Choose Personal Folder File (.pst)

3.Select the folder to export from – e.g. Personal Folder. Check Include Subfolders if you want to include all subfolders (like contacts) within the Personal Folder. You can set up a selective backup through a Filter to export specific messages.

4.Choose a safe location to store the exported file. A press of the Finish button ends the job.

To restore the data, similarly follow the wizard starting with File – Import and Export…- Import from another program or file - Personal Folder File (.pst) – browse to backup location and click finish.
Note: The Import and Export way is not sacrosanct because it does not backup user set settings (i.e. the folder design properties) like view options, forms, permissions, rules and alerts or auto-archive settings.

4.The Personal Folders Backup Add-In to the rescue
The earlier steps might send the work-shy among us into a slumber. The help of a Microsoft Outlook Add-in - ‘Personal Folders Backup’ saves us a few mouse clicks. It simply creates backup copies of the PST files at regular intervals to a designated location.
With the 159KB download installed, browse to File – Backup. The Options setting in the tool lets you select the frequency of backups, the files to backup and the location to backup to.

The Personal Folders Backup Add-In is supported by Outlook 2007, 2003 and 2002.

Ur Outlook data backup is ready...

Mani.V

How to create shortcut to lock your computer with single click?

If you’re in hurry and want to save your data/computer from other but you don't want to log off? Then don’t worry you can create a shortcut to lock your system with single click.
To create a shortcut on you’re desktop to lock your computer. Right-click the desktop and do this with the help of given steps:
• Point to New, and then click Shortcut.
• The Create Shortcut Wizard opens. In the text box, type the following:
• rundll32.exe user32.dll,LockWorkStation
• Click Next.
• Enter a name for the shortcut. You can call it "Lock Workstation" or choose any name you like.
Click Finish.
Be safe from use ur computer from others....

Mani.V

How to Speed Up Folder Access

In this page, I'll show you how to speed up folder access on your computer. Why you need to speed up folder access? In my opinion, you need to do that if you have a lot of folders and sub directories on your computer. Because when you access a directory, your windows system will wastes a lot of time updating the stamp showing the last access time for that directory. So you need to disable access update to stop your computer from doing this. Follow these steps to speed up folder access by disable access update on your computer.

1. Click on RUN, type Regedit in the open box and then click "OK".
2. Find HKEY_LOCAL_MACHINE > System > CurrentControlSet > Control > FileSystem
3. Create new DWORD Value called NtfsDisableLastAccessUpdate by right-click in a blank area of the window on the right and then select DWORD Value.
4. Double click on "NtfsDisableLastAccessUpdate", change the value data to 1 and then click OK.

That's all

Mani.V

How to Auto DELETE temporary folder

For Beginers
what we used to prefer is, type "%temp% " {without quotes} in Start -> Run.This opens your temporary folder and then you can erase it easily, but still try dis one
too..

For Advance User
First go into gpedit.msc, Next select -> Computer Configuration/Administrative Templates/Windows Components/Terminal
Services/Temporary Folder, Then right click "Do Not Delete Temp Folder Upon Exit.
"Go to properties and hit disable. Now next time Windows puts a temp file in that folder it
will automatically delete it when its done!

Thats all.... All Temporary Files are Deleted...

Mani.V

174 Run Commands For Windows XP

Run Commands Listed below In Alphabetical Order

All of the Run Command below Work in the Windows XP Operating System Some do Require that you have the application installed. To provoke the run dialogue box where you can enter the run commands Click start and then select Run or even faster hold down the Windows key and press 'R' then enter your command.

Program	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat ( if installed )	acrobat
Adobe Distiller ( if installed )	acrodist
Adobe ImageReady ( if installed )	imageready
Adobe Photoshop ( if installed )	photoshop
Automatic Updates	wuaucpl.cpl
Basic Media Player	mplay32
Bluetooth Transfer Wizard	fsquirt
Calculator	Calc
Ccleaner ( if installed )	Ccleaner
C: Drive	c:
Certificate Manager	cdrtmgr.msc
Character Map	Charmap
Check Disk Utility	Chkdsk
Clipboard Viewer	Clipbrd
Command Prompt	Cmd
Command Prompt	Command
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Compare Files	Comp
Control Panel	Control
Create a shared folder Wizard	Shrpubw
Date and Time Properties	timedate.cpl
DDE Shares	Ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel ( if installed )	directx.cpl
Direct X Troubleshooter	Dxdiag
Disk Cleanup Utility	Cleanmgr
Disk Defragment	dfrg.msc
Disk Partition Manager	diskmgmt.msc
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected )	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	Verifier
Ethereal ( if installed )	Ethereal
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	Migwiz
File Signature Verification Tool	Sigverif
Findfast	findfast.cpl
Firefox	Firefox
Folders Properties	control folders
Fonts	Fonts
Fonts Folder	Fonts
Free Cell Card Game	Freecell
Game Controllers	joy.cpl
Group Policy Editor ( xp pro )	gpedit.msc
Hearts Card Game	Mshearts
Help and Support	Helpctr
Hyperterminal	Hypertrm
Hotline Client	hotlineclient
Iexpress Wizard	Iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwonn1
Internet Properties	inetcpl.cpl
Internet Setup Wizard	Inetwiz
IP Configuration (Display Connection Configuration)	ipconfig /all
IP Configuration (Display DNS Cache Contents)	ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents)	ipconfig /flushdns
IP Configuration (Release All Connections)	ipconfig /release
IP Configuration (Renew All Connections)	ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)	ipconfig /registerdns
IP Configuration (Display DHCP Class ID)	ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)	ipconfig /setclassid
Java Control Panel ( if installed )	jpicpl32.cpl
Java Control Panel ( if installed )	Javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out of Windows	Logoff
Malicious Software Removal Tool	Mrt
Microsoft Access ( if installed )	access.cpl
Microsoft Chat	Winchat
Microsoft Excel ( if installed )	Excel
Microsoft Diskpart	Diskpart
Microsoft Frontpage ( if installed )	Frontpg
Microsoft Movie Maker	moviemk
Microsoft Management Console	Mmc
Microsoft Narrator	narrator
Microsoft Paint	mspaint
Microsoft Powerpoint	powerpnt
Microsoft Word ( if installed )	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
MS-Dos Editor	Edit
MS-Dos FTP	ftp
Nero ( if installed )	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager ( if installed )	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter ( if installed )	ac3filter.cpl
Outlook Express	msimn
Paint	Pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Characters Editor	eudcedit
Quicktime ( if installed )	quicktime.cpl
Quicktime Player ( if installed )	quicktimeplayer
Real Player ( if installed )	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Remote Desktop	mstsc
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy ( xp pro )	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
Security Center	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Sharing Session	rtcshare
Shuts Down Windows	shutdown
Sounds Recorder	sndrec32
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	clicongf
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility ( Scan Immediately )	sfc /scannow
System File Checker Utility ( Scan Once At Next Boot )	sfc /scanonce
System File Checker Utility ( Scan On Every Boot )	sfc /scanboot
System File Checker Utility ( Return to Default Settings)	sfc /revert
System File Checker Utility ( Purge File Cache )	sfc /purgecache
System File Checker Utility ( Set Cache Size to Size x )	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI ( if installed )	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Volume Serial Number for C:	label
Volume Control	sndvol32
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility ( if installed )	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Installer Details	Msiexec
Windows Magnifier	Magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msnsgs
Windows Picture Import Wizard (Need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Script host settings	wscript
Widnows Update Launches	wupdmgr
Windows Version ( shows your windows version )	winver
Windows XP Tour Wizard	tourstart
Wordpad	write
Zoom Utility	igfxzoom

If you found this list of Run Commands useful, Please Bookmark my site for future use.

Enable Folder Option - By Changing the Registry

hi,

Sometimes the Folder options are disabled by the Unwanted Viruses.

To enable the Folder option do this:

1. Goto Start and Run,
2. Type "regedit" (without Quotes)
3. Then Click the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Current version\Explorer\Advanced\Folder\Hidden\SHOWALL
4. In the Right side you will find the DWORD "CheckedValue",
5. Modify the Value "0" into "1".
6. Verify the Changed Value Effected or not by pressing F5. If the Value "1", Folder option Enabled.

7. If the Value again goes to "0", do the same thing in the safe mode and Clear the Virus.

That's all Folder option enabled.

Rgds,

Mani.V

Pop a banner each time Windows Boots

hi,

recently i got this from one website.



To pop a banner which can contain any message you want to display just before a user is going to log on, go to the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WinLogon

Now create a new string Value in the right pane named LegalNoticeCaption and enter the value that you want to see in the Menu Bar.
Now create yet another new string value and name it:
LegalNoticeText
Modify it and insert the message you want to display each time Windows boots. This can be effectively used to display the company's private policy each time the user logs on to his NT box.

It's .reg file would be:
REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Winlogon] "LegalNoticeCaption"="Caption here."


Rgds,

Mani.V

Improve Shutdown Speed in XP!!

Before doing the following changes u close to all the programmes.

1.       Go to Start then select Run

2.      Type 'Regedit' and click ok

3.      Find 'HKEY_CURRENT_USER\Control Panel\Desktop\'

4.      Select 'WaitToKillAppTimeout'

5.      Right click and select 'Modify'

6.      Change the value to '1000' and Click 'OK'

7.      Now select 'HungAppTimeout'

8.      Right click and select 'Modify'

9.      Change the value to '1000' and Click 'OK'

1.       Now find 'HKEY_USERS\.DEFAULT\Control Panel\Desktop'

2.      Select 'WaitToKillAppTimeout'

3.      Right click and select 'Modify'

4.      Change the value to '1000' and Click 'OK'

5.      Now find 'HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\'

6.      Select 'WaitToKillServiceTimeout'

7.      Right click and select 'Modify'

8.      Change the value to '1000' and Click 'OK'

 Hv a gr8 day.....

Mani.V

Keyboard Shortcut

KEYBOARD SHORTCUTS

1.) Windows Hotkeys

• Ctrl + Escape or Win: Display start menu.
• Shift + F10 or AppsKey: Display context menu.
• Win + E: Open Windows Explorer.
• Win + R: Open Run dialog.
• Win + M: Minimize all windows.
• Win + Shift + M: Undo minimize all windows.
• Win + D: Toggle minimize all windows. or toggle desktop view, using Show_Desktop.scf, while MinimizeAllWindows doesn't minimize dialog boxes (including Properties windows).'.
• Windows Hotkeys: Activate system tray. Arrow keys select, Enter double-clicks, and AppsKey or Shift + F10 right-clicks.
• Win + L (XP Only): Locks keyboard. Similar to Lock Workstation.
• Win + F or F3: Open Find dialog. (All Files) F3 may not work in some applications which use F3 for their own find dialogs.
• Win + Control + F: Open Find dialog. (Computers)
• Win + U: Open Utility Manager.
• Win + F1: Open Windows help.
• Win + Pause: Open System Properties dialog.
• Win + Tab: Cycle through taskbar buttons. Enter clicks, AppsKey or Shift + F10 right-clicks.
• Win + Shift + Tab: Cycle through taskbar buttons in reverse.
• Alt + Tab: Display CoolSwitch. More commonly known as the AltTab dialog.
• Alt + Shift + Tab: Display CoolSwitch; go in reverse.
• Alt + Escape: Send active window to the bottom of the z-order.
• Alt + Shift + Escape: Activate the window at the bottom of the z-order.
• Alt + F4: Close active window; or, if all windows are closed, open shutdown dialog.
• Shift while a CD is loading: Bypass AutoPlay.
• Shift while login: Bypass startup folder. Only those applications will be ignored which are in the startup folder, not those started from the registry (Microsoft\Windows\CurrentVersion\Run\)
• Ctrl + Alt + Delete or Ctrl + Alt + NumpadDel (Both NumLock states): Invoke the Task Manager or NT Security dialog.
• Ctrl + Shift + Escape (2000/XP ) or (Ctrl + Alt + NumpadDot) : Invoke the task manager. On earlier OSes, acts like Ctrl + Escape.
• Printscreen: Copy screenshot of current screen to clipboard.
• Alt + Printscreen: Copy screenshot of current active window to clipboard.
• Ctrl + Alt + Down Arrow: Invert screen. Untested on OSes other than XP.
• Ctrl + Alt + Up Arrow: Undo inversion.
• Win + B : Move focus to systray icons.

2.) Generic

• Ctrl + C or Ctrl + Insert: Copy.
• Ctrl + X or Shift + Delete: Cut.
• Ctrl + V or Shift + Insert: Paste/Move.
• Ctrl + N: New... File, Tab, Entry, etc.
• Ctrl + S: Save.
• Ctrl + O: Open...
• Ctrl + P: Print.
• Ctrl + Z: Undo.
• Ctrl + A: Select all.
• Ctrl + F: Find...
• Ctrl+W : to close the current window
• Ctrl + F4: Close tab or child window.
• F1: Open help.
• F11: Toggle full screen mode.
• Alt or F10: Activate menu bar.
• Alt + Space: Display system menu. Same as clicking the icon on the titlebar.
• Escape: Remove focus from current control/menu, or close dialog box.

3.) Generic Navigation

• Tab: Forward one item.
• Shift + Tab: Backward one item.
• Ctrl + Tab: Cycle through tabs/child windows.
• Ctrl + Shift + Tab: Cycle backwards through tabs/child windows.
• Enter: If a button's selected, click it, otherwise, click default button.
• Space: Toggle items such as radio buttons or checkboxes.
• Alt + (Letter): Activate item corresponding to (Letter). (Letter) is the underlined letter on the item's name.
• Ctrl + Left: Move cursor to the beginning of previous word.
• Ctrl + Right: Move cursor to the beginning of next word.
• Ctrl + Up: Move cursor to beginning of previous paragraph. This and all subsequent Up/Down hotkeys in this section have only been known to work in RichEdit controls.
• Ctrl + Down: Move cursor to beginning of next paragraph.
• Shift + Left: Highlight one character to the left.
• Shift + Right: Highlight one character to the right.
• Shift + Up: Highlight from current cursor position, to one line up.
• Shift + Down: Highlight from current cursor position, to one line down.
• Ctrl + Shift + Left: Highlight to beginning of previous word.
• Ctrl + Shift + Right: Highlight to beginning of next word.
• Ctrl + Shift + Up: Highlight to beginning of previous paragraph.
• Ctrl + Shift + Down: Highlight to beginning of next paragraph.
• Home: Move cursor to top of a scrollable control.
• End: Move cursor to bottom of a scrollable control.

4.) Generic File Browser

• Arrow Keys: Navigate.
• Shift + Arrow Keys: Select multiple items.
• Ctrl + Arrow Keys: Change focus without changing selection. "Focus" is the object that will run on Enter. Space toggles selection of the focused item.
• (Letter): Select first found item that begins with (Letter).
• BackSpace: Go up one level to the parent directory.
• Alt + Left: Go back one folder.
• Alt + Right: Go forward one folder.
• Enter: Activate (Double-click) selected item(s).
• Alt + Enter: View properties for selected item.
• F2: Rename selected item(s).
• Ctrl + NumpadPlus: In a Details view, resizes all columns to fit the longest item in each one.
• Delete: Delete selected item(s).
• Shift + Delete: Delete selected item(s); bypass Recycle Bin.
• Ctrl while dragging item(s): Copy.
• Ctrl + Shift while dragging item(s): Create shortcut(s).

In tree pane, if any:

• Left: Collapse the current selection if expanded, or select the parent folder.
• Right: Expand the current selection if collapsed, or select the first subfolder.
• NumpadAsterisk: Expand currently selected directory and all subdirectories. No undo.
• NumpadPlus: Expand currently selected directory.
• NumpadMinus: Collapse currently selected directory.


5.) Accessibility

• Right Shift for eight seconds: Toggle FilterKeys on and off. FilterKeys must be enabled.
• Left Alt + Left Shift + PrintScreen: Toggle High Contrast on and off. High Contrast must be enabled.
• Left Alt + Left Shift + NumLock: Toggle MouseKeys on and off. MouseKeys must be enabled.
• NumLock for five seconds: Toggle ToggleKeys on and off. ToggleKeys must be enabled.
• Shift five times: Toggle StickyKeys on and off. StickyKeys must be enabled.

6.) Microsoft Natural Keyboard with IntelliType Software Installed

• Win + L: Log off Windows.
• Win + P: Open Print Manager.
• Win + C: Open control panel.
• Win + V: Open clipboard.
• Win + K: Open keyboard properties.
• Win + I: Open mouse properties.
• Win + A: Open Accessibility properties.
• Win + Space: Displays the list of Microsoft IntelliType shortcut keys.
• Win + S: Toggle CapsLock on and off.

7.) Remote Desktop Connection Navigation

• Ctrl + Alt + End: Open the NT Security dialog.
• Alt + PageUp: Switch between programs.
• Alt + PageDown: Switch between programs in reverse.
• Alt + Insert: Cycle through the programs in most recently used order.
• Alt + Home: Display start menu.
• Ctrl + Alt + Break: Switch the client computer between a window and a full screen.
• Alt + Delete: Display the Windows menu.
• Ctrl + Alt + NumpadMinus: Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing Alt + PrintScreen on a local computer.
• Ctrl + Alt + NumpadPlus: Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PrintScreen on a local computer.

8.) Mozilla Firefox Shortcuts

• Ctrl + Tab or Ctrl + PageDown: Cycle through tabs.
• Ctrl + Shift + Tab or Ctrl + PageUp: Cycle through tabs in reverse.
• Ctrl + (1-9): Switch to tab corresponding to number.
• Ctrl + N: New window.
• Ctrl + T: New tab.
• Ctrl + L or Alt + D or F6: Switch focus to location bar.
• Ctrl + Enter: Open location in new tab.
• Shift + Enter: Open location in new window.
• Ctrl + K or Ctrl + E: Switch focus to search bar.
• Ctrl + O: Open a local file.
• Ctrl + W: Close tab, or window if there's only one tab open.
• Ctrl + Shift + W: Close window.
• Ctrl + S: Save page as a local file.
• Ctrl + P: Print page.
• Ctrl + F or F3: Open find toolbar.
• Ctrl + G or F3: Find next...
• Ctrl + Shift + G or Shift + F3: Find previous...
• Ctrl + B or Ctrl + I: Open Bookmarks sidebar.
• Ctrl + H: Open History sidebar.
• Escape: Stop loading page.
• Ctrl + R or F5: Reload current page.
• Ctrl + Shift + R or Ctrl + F5: Reload current page; bypass cache.
• Ctrl + U: View page source.
• Ctrl + D: Bookmark current page.
• Ctrl + NumpadPlus or Ctrl + Equals (+/=): Increase text size.
• Ctrl + NumpadMinus or Ctrl + Minus: Decrease text size.
• Ctrl + Numpad0 or Ctrl + 0: Set text size to default.
• Alt + Left or Backspace: Back.
• Alt + Right or Shift + Backspace: Forward.
• Alt + Home: Open home page.
• Ctrl + M: Open new message in integrated mail client.
• Ctrl + J: Open Downloads dialog.
• F6: Switch to next frame. You must have selected something on the page already, e.g. by use of Tab.
• Shift + F6: Switch to previous frame.
• Apostrophe ('): Find link as you type.
• Slash (/): Find text as you type.

9.) GMail

Note: Must have "keyboard shortcuts" on in settings.
• C: Compose new message.
• Shift + C: Open new window to compose new message.
• Slash (/): Switch focus to search box.
• K: Switch focus to the next most recent email. Enter or "O" opens focused email.
• J: Switch focus to the next oldest email.
• N: Switch focus to the next message in the "conversation." Enter or "O" expands/collapses messages.
• P: Switch focus to the previous message.
• U: Takes you back to the inbox and checks for new mail.
• Y: Various actions depending on current view:
Has no effect in "Sent" and "All Mail" views.
o Inbox: Archive email or message.
o Starred: Unstar email or message.
o Spam: Unmark as spam and move back to "Inbox."
o Trash: Move back to "Inbox."
o Any label: Remove the label.
• X: "Check" an email. Various actions can be performed against all checked emails.
• S: "Star" an email. Identical to the more familiar term, "flagging."
• R: Reply to the email.
• A: Reply to all recipients of the email.
• F: Forward an email.
• Shift + R: Reply to the email in a new window.
• Shift + A: Reply to all recipients of the email in a new window.
• Shift + F: Forward an email in a new window.
• Shift + 1 (!): Mark an email as spam and remove it from the inbox.
• G then I: Switch to "Inbox" view.
• G then S: Switch to "Starred" view.
• G then A: Switch to "All Mail" view.
• G then C: Switch to "Contacts" view.
• G then S: Switch to "Drafts" view.

10.) List of F1-F9 Key Commands for the Command Prompt

• F1 / right arrow: Repeats the letters of the last command line, one by one.
• F2: Displays a dialog asking user to "enter the char to copy up to" of the last command line
• F3: Repeats the last command line
• F4: Displays a dialog asking user to "enter the char to delete up to" of the last command line
• F5: Goes back one command line
• F6: Enters the traditional CTRL+Z (^z)
• F7: Displays a menu with the command line history
• F8: Cycles back through previous command lines (beginning with most recent)
• F9: Displays a dialog asking user to enter a command number, where 0 is for first command line entered.
• Alt+Enter: toggle fullScreen mode.
• up/down: scroll thru/repeat previous entries
• Esc: delete line
Note: The buffer allows a maximum of 50 command lines. After this number is reached, the first line will be replaced in sequence.

Rgds,

Mani.V

In Microsoft Outlook, how can I import address information from an Excel workbook into my Contacts list?

1. Arrange the Excel data in the traditional database format; i.e., give each column field titles and make each row a record.

2. Change the field titles in the worksheet so that they match those in your Outlook Contacts list.

3. To display the Name dialog box, press Ctrl-F3. Use this dialog box to assign the name Contacts to the entire range of contacts data.

4. Open Outlook. From the File menu, select Import and Export... .

5. In Outlook, select Import from another program or file.

6. Select Microsoft Excel. Import the file as .xls (not .xlx). Click Next.
Note: You may get the following prompt: "Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?" If you do, click Yes to continue.

7. From the Import a File page, make your desired selections, depending on how you want to handle duplicates. To navigate to the Excel file you are importing, click Browse... .

8. Select the file, and then click OK. In the Import a File dialog box, click Next.

9. In the Select a destination folder window, select the Contacts folder. Click Next.

10. On this last page, you will see two buttons:

o Map Custom Fields... : Click if you want to change the "field mapping", i.e., the selection of which columns in your Excel file match up with which data in Outlook's contacts. For example, one of your Excel file columns might read "Home", and you'll have to map that in Outlook to either "Home Address" or "Home Phone", accordingly.

o Change Destination... : Click if you want to change the destination folder. Since you are importing contacts, and since you already selected the destination folder in the last step, you only need to click this button if you made a mistake or want to double-check that you've selected the right one. Otherwise, you can ignore it.

When you are done, click Finish, and wait for Outlook to complete the task. To check the results in Outlook, open your Contacts folder.

Tally.Erp Reports

Check out this SlideShare Presentation:

Tally.Erp Reports

View more presentations from ravi78.

Configure Outlook Express for Multiple E-mail Accounts

Step 1:
For each of your e-mail accounts, find the type of e-mail account (POP3, IMAP or HTTP), the name of the incoming mail server (example: mail.isp.com) and the name of the outgoing, or SMTP, mail server (example: smtp.isp.com). This information can usually be found in the provider's FAQ (frequently asked questions) file or by e-mailing the provider.

Step 2:
Start Outlook Express.

Step 3:
Select Accounts from the Tools menu. Click on the Mail tab.

Step 4:
Click Add on the right side of the box and choose Mail. The Internet Connection Wizard will appear.

Step 5:
Type the display name for the account (the name that appears in the From line of e-mail sent from that account). Click Next.

Step 6:
If you already have the new account, click the top radio button. Enter the name of the account and click Next.

Step 7:
Type the mail server information you collected in the first step. Be sure to type the information as it appears in your notes. Click Next.

Step 8:
Type the user name as it appears on the account. The name is usually what precedes the address; for example, the account name of feedback@ehow.com is "feedback."

Step 9:
Type the password to access the account. If the password is incorrect or you can't remember it, contact the e-mail provider.

Step 10:
Check the Remember Password box if you don't want Outlook to prompt you for the password each time it checks the mail.

Step 11:
Click Finish. Repeat as needed for all e-mail accounts.

Step 12:
Edit account properties by clicking on the name and choosing Properties from the list on the right.


Tips & Warnings
When you select Receive All mail, you should also get mail from the account you added. If it doesn't work, you probably don't have the appropriate incoming and outgoing mail server names. If you don't have the right names, contact the e-mail provider to find them. You can add up to 10 separate e-mail addresses.Remove an address by selecting it and clicking Remove.If you use an HTTP (Web-based) e-mail service, contact your e-mail provider about integrating your HTTP e-mail service into Outlook. Hotmail, for example, allows you to integrate Hotmail into Outlook by synchronizing your Hotmail folders and address book into Outlook and creating a new account with the Hotmail Signup Wizard. Alternatively, try configuring your HTTP e-mail to be automatically forwarded to an existing Outlook account.


Thats It...

GMail - Keyboard shortcuts

Keyboard shortcuts

Print

Keyboard shortcuts help you save time by allowing you to never take your hands off the keyboard to use the mouse. You'll need a Standard 101/102-Key or Natural PS/2 Keyboard to use the shortcuts.

To turn these case-sensitive shortcuts on or off, click Settings, and then pick an option next to Keyboard shortcuts.

Shortcut Key	Definition	Action
c	Compose	Allows you to compose a new message. + c allows you to compose a message in a new window.
/	Search	Puts your cursor in the search box.
k	Move to newer conversation	Opens or moves your cursor to a more recent conversation. You can hit to expand a conversation.
j	Move to older conversation	Opens or moves your cursor to the next oldest conversation. You can hit to expand a conversation.
n	Next message	Moves your cursor to the next message. You can hit to expand or collapse a message. (Only applicable in 'Conversation View.')
p	Previous message	Moves your cursor to the previous message. You can hit to expand or collapse a message. (Only applicable in 'Conversation View.')
o or	Open	Opens your conversation. Also expands or collapses a message if you are in 'Conversation View.'
u	Return to conversation list	Refreshes your page and returns you to the inbox, or list of conversations.
e	Archive	Archive your conversation from any view.
m	Mute	Archives the conversation, and all future messages skip the Inbox unless sent or cc'd directly to you. Learn more.
x	Select conversation	Automatically checks and selects a conversation so that you can archive, apply a label, or choose an action from the drop-down menu to apply to that conversation.
s	Star a message or conversation	Adds or removes a star to a message or conversation. Stars allow you to give a message or conversation a special status.
!	Report spam	Marks a message as spam and removes it from your conversation list.
r	Reply	Replies to the message sender. + r allows you to reply to a message in a new window. (Only applicable in 'Conversation View.')
a	Reply all	Replies to all message recipients. +a allows you to reply to all message recipients in a new window. (Only applicable in 'Conversation View.')
f	Forward	Forwards a message. + f allows you to forward a message in a new window. (Only applicable in 'Conversation View.')
	Escape from input field	Removes the cursor from your current input field.
+ s	Save draft	Saves the current text as a draft when composing a message. Hold the key while pressing s and make sure your cursor is in one of the text fields -- either the composition pane, or any of the To, CC, BCC, or Subject fields -- when using this shortcut.
#	Delete	Moves the conversation to Trash.
l	Label	Opens the Labels menu to label a conversation.
v	Move to	Moves the conversation from the inbox to a different label, Spam or Trash.
+ i	Mark as read	Marks your message as 'read' and skip to the next message.
+ u	Mark as unread	Marks your message as 'unread' so you can go back to it later.
[	Archive and previous	Archives your conversation and moves to the previous one.
]	Archive and next	Archives your conversation and moves to the next one.
z	Undo	Undoes your previous action, if possible (works for actions with an 'undo' link).
+ n	Update current conversation	Updates your current conversation when there are new messages.
q	Move cursor to chat search	Moves your cursor directly to the chat search box.
y	Remove from Current View*	Automatically removes the message or conversation from your current view. From 'Inbox,' 'y' means Archive From 'Starred,' 'y' means Unstar From 'Trash,' 'y' means Move to inbox From any label, 'y' means Remove the label * 'y' has no effect if you're in 'Spam,' 'Sent,' or 'All Mail.'
.	Show more actions	Displays the 'More Actions' drop-down menu.
+	Opens options in Chat	+ moves from edit field in your chat window to select the 'Video and more' menu Next, press to select the emoticon menu Press to open the selected menu
?	Show keyboard shortcuts help	Displays the keyboard shortcuts help menu within any page you're on.

Combo-keys - Use the following combinations of keys to navigate through Gmail.

Shortcut Key	Definition	Action
then	Send message	After composing your message, use this combination to send it automatically. (Supported in Internet Explorer and Firefox, on Windows.)
y then o	Archive and next	Archives your conversation and moves to the next one.
g then a	Go to 'All Mail'	Takes you to 'All Mail,' the storage site for all mail you've ever sent or received (and have not deleted).
g then s	Go to 'Starred'	Takes you to all conversations you have starred.
g then c	Go to 'Contacts'	Takes you to your Contacts list.
g then d	Go to 'Drafts'	Takes you to all drafts you have saved.
g then i	Go to 'Inbox'	Returns you to the inbox.
g then t	Go to 'Sent Mail'	Takes you to all mail you've sent.
* then a	Select all	Selects all mail.
* then n	Select none	Deselects all mail.
* then r	Select read	Selects all mail you've read.
* then u	Select unread	Selects all unread mail.
* then s	Select starred	Selects all starred mail.
* then t	Select unstarred	Selects all unstarred mail.