Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts


http://likesplanet.com/promote.php?ref=imerxwebtech 

Shortcut	Description
Double-click (on a cell)	Edit the cell contents.
Double-click (on a row/column divider)	Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider	Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click	Select the entire contents in the cell
Click on row/column divider then drag	Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag	Adjust height/width of the rows/colunns
Ctrl + Mouse wheel	Zooms in and out of document.
Hold Shift + Click the cells	Select multiple cells

Keyboard shortcuts

Shortcut	Description
F2	Edit the selected cell.
F5	Goto a specific cell. For example, C6.
F7	Spell check selected text and/or document.
F11	Create chart.
Ctrl + A	Select all.
Ctrl + B	Bold.
Ctrl + C	Copy.
Ctrl + F	Find (same as Shift + F5).
Ctrl + G	Go To.
Ctrl + H	Replace.
Ctrl + I	Italic.
Ctrl + K	Insert link.
Ctrl + N	New Workbook.
Ctrl + O	Open Workbook.
Ctrl + P	Print dialog.
Ctrl + S	Save.
Ctrl + U	Underline.
Ctrl + V	Paste.
Ctrl + Z	Undo.
Ctrl + Y	Redo.
Ctrl + X	Cut.
Ctrl + 5	Strikethrough text.
Ctrl + F3	Define Name.
Ctrl + F4	Exit Excel.
Ctrl + F6	Switch between open workbooks.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize current window.
Shift + F1	Activate Help on Item.
Shift + F2	Insert Comments
Shift + F3	Insert Function.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Ctrl + Page down	Move to next worksheet.
Ctrl + Page up	Move to previous worksheet.
Ctrl + Shift + #	Number Format: Date
Ctrl + Shift + @	Number Format: Time.
Ctrl + Shift + !	Number Format: Commas.
Ctrl + Shift + $	Number Format: Currency
Ctrl + Shift + %	Number Format: Percentage
Ctrl + Shift + ^	Number Format: Scientific.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.
Ctrl + (Arrow key)	Move to next section.

  http://filesquick.net/file/04r4i6

Any Folder as a Photo Folder

Any Folder as a Photo Folder

This tricks shows you how to setup any folder to display its contents as a photo folder. In many cases, you save your images/photos in a folder different than "My Pictures" (under "My Documents"). Since this folder you choose is just like any other normal folders, its contents displayed as a listing of files. You can temporary change it by just right-click and select "View" >> "Thumbnails". But if you want to change the folder so that everytime you come back, the folder itself, as well as all its subfolders, display the contents as photo thumbnails.
Here's How
Right-click on the folder you choose and select "Properties"

Select "Customize" Tab. Then under "Use this folder type as a template", select "Pictures (best for many files)"

Check on "Also apply this template to all subfolders" to apply the setting to subfoders as well

Click OK to exit

Hide a File(s) in Image File

HOW TO HIDE FILE(S) IN IMAGE

1. Select an image to be used for hiding file behind the image.
2. Now select a file to hide behind the image and make it in .RAR format. With the help of the WinRAR.
3. And most important is that paste both the files on desktop. You may do this anywhere instead of desktop if you have some basic understanding of command line.
4. Now open cmd by going to Start > Accessories > Command Prompt and type following commands in it.

cd desktop

CD stands for change directory by typing above command you change your directory to desktop. After that type command given below.

• Replace imagename.jpg with the name of image you want your file to be hidden behind. Don't forget to add image format (Eg: .jpg,.png,.gif)
  
• Replace filename with name of your file you want to hide. It must be in .rar format.
  
• Finally Replace finalimage.jpg with whatever name you want your final image with hidden files should be. This is the image where your file will be hidden.

1      Now when you will try to open this newly created image it will open as normal image, but to open you hidden file you need follow steps given below.

How To Access Hidden File ?

To access your hidden file you need to open the newly created image in winrar. Just follow simple steps given below to do that.

    1. Open winrar

    2. Now locate your image and open it or simply drag your image in winrar.

    3. Extract the file and done.

Change Ur PC Processor Name To Ur Own Name or Higher Processor Name

Hi Friends,

Perk Account

How are you all? Hope you are all fine. Ok. Here i show you how to change the processor name. For example: Your pc have the processor "Dual Core" means you can change the name to your own name or like "Core i3"   something.

Step 1: Goto run prompt and type "regedit" without double quotes. and hit enter

Step 2: Now registry edit box will appear in that navigate to this path:

HKEY_LOCAL_MACHINE \ HARDWARE \ DESCRIPTION \ SYSTEM \ CENTRAL PROCESSOR \ 0

and now after click the folder "0" some files will appear in the right pane.

Step 3: From that list double click the file named "ProcessorNameString" now a dialog box will appear. In that box you can change the value data to any thing you want like your name or "Core i3"  or Core i5 etcc..

Hope it will for you all. Here i attached a video steps too. If any question please ask in comments.. Start prank your friends..... Thanks for your valuable time.




Do you want to Find & Download Mp3 & video simply?

Hello friends, today I am going to show how you can find your exact MP3 and Video Easily in search engines. I know you are all downloaded many mp3 and video from search engines but before that you are triggered to go through many sites and pages to download a single mp3. So now I am going to show you find your needed music file in through search engines like Google, Yahoo, Bing..

Step 1 : Open Google search engine first.

 Step 2: Now let’s assume I am going to download the song “Machi Open the bottle” from “Mangatha”.

Step 3:  just copy the code below with double quotes and paste it in your google search box.

"parent directory" mp3 OR wma OR ogg OR wav Machi Open the bottle -html -htm -shtml -phtml -php -buy -aspx -jsp -asp -cgi -pdf -ftp –wallywashis

Step 4: Now you can see the magic..

So Just you can replace the song name Machi open the bottle with your needed song name. Below this I given the query for  video download.

"parent directory" avi OR mpg OR mpeg OR asf OR wmv "Machi open the bottle" -html -htm -shtml -phtml -php -buy -aspx -jsp -asp -cgi -pdf –ftp

Here are the queries for other search engines:

MP3 SEARCH – BING AND YAHOO

"parent directory" AND (Machi Open the bottel) AND (mp3 OR wma OR ogg) -html -htm -shtml -phtml -php -buy -aspx -jsp -asp -cgi -pdf –ftp

VIDEO  -  BING AND YAHOO

"parent directory" AND (MAchi open the bottle) AND (avi OR mpg OR mpeg OR asf OR wmv) -html -htm -shtml -phtml -php -buy -aspx -jsp -asp -cgi -pdf -ftp

(NOTE : All the queries are included with double quotes so copy the query with double quotes)

VIDEO OF THIS POST