Short Cut Keys for MS Excel

Use this Short Cut Keys for MS Excel operations. This short-cut will definitely save your valuable time during operation with Excel. I think you will also love this post name " Keyboard Shortcut for Windows "

Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6. Shift + F5 Bring up search box.
F7 Spell check selected text and/or document.
F11 Create chart.
Shift + F3 Open the Excel formula window.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

Keyboard Shortcut for Windows

Sometimes we need some shortcut in operating our PC. So, today i thought to publish such a list of important shortcut which will surely help us to use our computer more easily. I think you will love this post and don't forget to publish your comment on this post... please write why you liked this post?

•	CTRL+C (Copy)
•	CTRL+X (Cut)
•	CTRL+V (Paste)
•	CTRL+Z (Undo)
•	DELETE (Delete)
•	SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
•	CTRL while dragging an item (Copy the selected item)
•	CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
•	F2 key (Rename the selected item)
•	CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
•	CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
•	CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
•	CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
•	CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
•	SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
•	CTRL+A (Select all)
•	F3 key (Search for a file or a folder)
•	ALT+ENTER (View the properties for the selected item)
•	ALT+F4 (Close the active item, or quit the active program)
•	ALT+ENTER (Display the properties of the selected object)
•	ALT+SPACEBAR (Open the shortcut menu for the active window)
•	CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
•	ALT+TAB (Switch between the open items)
•	ALT+ESC (Cycle through items in the order that they had been opened)
•	F6 key (Cycle through the screen elements in a window or on the desktop)
•	F4 key (Display the Address bar list in My Computer or Windows Explorer)
•	SHIFT+F10 (Display the shortcut menu for the selected item)
•	ALT+SPACEBAR (Display the System menu for the active window)
•	CTRL+ESC (Display the Start menu)
•	ALT+Underlined letter in a menu name (Display the corresponding menu)
•	Underlined letter in a command name on an open menu (Perform the corresponding command)
•	F10 key (Activate the menu bar in the active program)
•	RIGHT ARROW (Open the next menu to the right, or open a submenu)
•	LEFT ARROW (Open the next menu to the left, or close a submenu)
•	F5 key (Update the active window)
•	BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
•	ESC (Cancel the current task)
•	SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)
•	CTRL+SHIFT+ESC (Open Task Manager)

Tricks that can make notepad work like a personal diary for you

There is a simple tricks that can make notepad work like a personal diary for you.

The steps will make notepad as your personal diary:

• Open a blank Notepad file.
• Write .LOG and press enter, and save it (Whatever name you like).
  
• Open the file you will see the Current time and Date and the cursor is on the next line.
  
• Type your note there and save it.
  
• Every time you open the file will give a new time (if you saved it previously)

And enjoy the easiest diary writing ever.....

Short cut for address bar applicable to all web browser

Friend i want to share one short cut for address bar (where we write www.coolcompu.blogspot.com or www.computertricks.co.cc).

What most people do..
Type www.coolcompu.blogspot.com in the address bar...

and what is the tricks...

Just type coolcompu.blogspot and Ctrl + Enter together it will automatically take www.coolcompu.blogspot.com

it will save your time typing www. and .com for each sites...

is not it helpful??

Fill up your forms in the web automatically

This feature enables you to fill out web forms with one click or a keyboard shortcut.

There is no problem weather you use Firefox or Internet Explorer.

Generally we need to fill up our form in the web manually, for various reasons, such as opening an email account. Different signing up form has some common question such as name, address, user name, password, phone number etc. and every time when we fill up forms we have to write these every time. But this post is going to tell how you can do easily, rather than writing individually. Its very simple, follows the steps…

• Download the exact add-ons, for Firefox CLICK HERE and for Internet Explorer CLICK HERE and install it.
• Click the wrench icon on the right side of your Toolbar. Alternatively, click the down arrow next to the AutoFill button and select Add/Edit Profiles….
• In the 'Toolbar Options' window, click the AutoFill tab….
• Select the checkbox next to AutoFill if it isn't checked already….
• To create a new profile, click the Add new profile link. Or click the Edit link next to the profile you'd like to edit….
• Edit your information as necessary….
• Click the Save button.
• Now you check it by signing up anywhere…you will see some boxes will be colored.
• Now press the auto fill up icon in the window. You will see the boxes (which was colored is now filled up)

I think you love this one... So, you don’t need to waste time by filling up forms…

Comment please….

Download whole website

Friend i found one software which downloads the whole website. Rather than opening the pages and saving individually this one downloads the whole website easily.

Generally what we do for saving a webpage-

• We open the page which is to save
• Then go to file menu and select save page as
• and save it as Web Page, complete , Web Page, text file or Html only.

Now we don't need to do so. we can use this software and it will accomplish this task everything perfectly, replicating the directory structure exactly as it is online.

so you need the name of this software that is- Website Downloader and the link is
http://web-site-downloader.com/

Its cost arround $ 16.95 and it is a one-time fees..

Change your Icon spacing.....(Xp)

 

You can manage your desktop icons in windows XP horizontally as well as vertically spacing. You can change

 

1. location

2. size of icons

3.spacing between icons 

but you can arrange these setting using windows methods.

check this...

1.Right click on the destop and click on Properties

2.click Appearance tab and go to Advance button

(under item there are many option for changing)

e.g. - choose icon spacing in both ways and then here you can change the size putting number (minimum or maximum) under size.

4. when it is complete click OK button.

Search Google with these techniques

site: domain restricts search results to the given domain.

allinurl: shows only pages with all terms in the url.

inurl: like allinurl, but only for the next query word.

allintitle: shows only results with terms in title.

intitle: similar to allintitle, but only for the next word. "intitle:webmasterworld google" finds only pages with webmasterworld in the title, and google anywhere on the page.

link: url Shows other pages with links to that url।

related:url same as "what's related" on serps.

cache:url will show the Google version of the passed url.

info:url will show a page containing links to related searches, backlinks, and pages containing the url. This is the same as typing the url into the search box.

spell: will spell check your query and search for it.

stocks: will lookup the search query in a stock index.

filetype: will restrict searches to that filetype. "-filetype:doc" to remove Microsoft word files.

daterange: is supported in Julian date format only. 2452384 is an example of a Julian date.

maps: If you enter a street address, a link to Yahoo Maps and to MapBlast will be presented.

phone: enter anything that looks like a phone number to have a name and address displayed. Same is true for something that looks like an address (include a name and zip code)

site:www.somesite.net "+www.somesite.+net"
(tells you how many pages of your site are indexed by google)

allintext: searches only within text of pages, but not in the links or page title

allinlinks: searches only within links, not text or title

Set your Num Lock Turn On Forever

You can set your Num Lock to stay on, when you logon your system.

There is a techniques to set Num Lock stay on by default.Here i am giving you one technique...

follow the steps...

1.Open Run command and type Regedt32.exe

2.Here Navigate to HKEY_USERS\.Default\Control Panel\Keyboard 

3. change the value for InitialKeyboardIndicators from 0 to 2.

Now restart the computer. Num Lock should come on and stay on.

Protect your Office document with Password

You can protect your document by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of passwords:

Password to open the document: 

Password to modify the document: 

Follow these steps.....

1. Open any Office Documents
2. Click File and Select Save As
3. Now click Tools in that dialouge box
4. select General Option...
5. Now give the password i. Password to open and ii.Password to modify and click OK.
6. You will be asked to "Confirm Password", again enter those password you have entered earlier (The maximum length of password is 15 characters.)
7. Click "Save" button of Save As dialog box

It is now ready.....

Remember password is case sensitive Don' t forget them....

Hi!!!

Hello check the category for your need......

Renaming the whole sets of files

Hey there is a good and very easiest way to rename a sets of file. This is actually need when similar types of same files are there in your PC.

Check it....

1.Make a folder in Destop.

2.Create a huge number of folder there

[this will be New Folder, New Folder (2), New Folder (3), and so on....]

3. Now Select them all (Ctrl+A)

4.Right click and select Rename

5. Now Give a name (eg.abc)

Now it is ready ......

(This is very useful when you are going to rename a huge number of file uploaded from your Digicam,Camcorder etc.)

Automatic delete temporary files from Internet Explorer

Internet Explorer 6 will automatically delete temporary files, but only if you tell it to.

Start the browser, select Tools / Internet Options... and Advanced, go down to the Security area and check the box to Empty Temporary Internet Files folder when browser is closed.

Shortcut for Windows...

gtalk windows key + esc

SHIFT+DELETE(Delete the selected item permanently without placing the item in the Recycle Bin)

SHIFT+F10 (Display the shortcut menu for the selected item)

Right SHIFT for eight seconds (Switch FilterKeys either on or off)

SHIFT five times (Switch the StickyKeys either on or off)

WindowsLogo+BREAK (Display the System Properties dialog box)

WindowsLogo+D (Display the desktop)

Windows Logo+M (Minimize all of the windows)

Windows Logo+SHIFT+M (Restore the minimized windows)

Windows Logo+E (Open My Computer)

Windows Logo+U (Open Utility Manager) Accessibility Keyboard Shortcuts

CTRL+A (Select all)

CTRL+C (Copy)

CTRL+X (Cut)

CTRL+V (Paste)

TRL+Z (Undo)

DELETE (Delete)

CTRL while dragging an item (Copy the selected item)

CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)

CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)

CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)

CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)

CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)

F2 key (Rename the selected item)

F3 key (Search for a file or a folder)

F4 key (Display the Address bar list in My Computer or Windows Explorer)

F5 key (Refresh)

F6 key (Cycle through the screen elements in a window or on the desktop)

ALT+ENTER (View the properties for the selected item)

ALT+F4 (Close the active item, or quit the active program)

ALT+ENTER (Display the properties of the selected object)

ALT+SPACEBAR (Open the shortcut menu for the active window)

ALT+TAB (Switch between the open items)

ALT+ESC (Cycle through items in the order that they had been opened)

ALT+SPACEBAR (Display the System menu for the active window)

Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)

Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)

END (Display the bottom of the active window)

HOME (Display the top of the active window)

NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)

NUM LOCK+Plus sign (+) (Display the contents of the selected folder)

NUM LOCK+Minus sign (-) (Collapse the selected folder)

NUM LOCK for five seconds (Switch the ToggleKeys either on or off)

Some Shortcuts in Run... command

Shortcuts for Windows XP users!!

Press

'Windows key' + R to open Run... and press these (without qoutes) :

and now press these...

"winword" to open Word.

"wmplayer" to open Windows Media Player.

"wordpad" to open Wordpad.

"sndrec32" to open Sound Recorder.

"iexplore" to open Internet Explorer.

"firefox" to open Firefox.

"msconfig" to control startup.

"powerpnt" to open Powerpoint.

"excel" to open Excel

"mspaint" to open Paint.

"notepad" to open Notepad.

"services.msc" to manage the Services.

disk cleanup........

This program used for cleaning harddisk to offer space

Click : start

Then : run

type : cleanmgr

that's all..

Remove SHORTCUT link from the desktop folder

just go to >start>run>regedit>hkey_classes_root>u
find a file by name lnkfile click on that to that right
u can see a file by name is shortcut delete that and
again come to left click on pipfile u delete again is shortcut
then restart the pc u cant see the shortcut arrow