Earn Money By Online

Sunday 26 January 2014

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.

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

Thursday 23 January 2014

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.

Powered by Blogger.