Computer Tips and smart tricks on SMS

Become a computer guru. Learn the basic MS Office tricks and speed up your work

Computer Tricks In excel

Computer Tricks In excel, To add all numbers above a particular cell Press ALT + =. To chk spellings, select the word & press F7

SMS WhatsApp

Decide how often you

Decide how often you want word to automatically save your Document – Go to TOOLS – OPTIONS – SAVE – SAVE AUTORECOVER.

SMS WhatsApp

Doctor Aap ka vajan

Doctor: Aap ka vajan kitna hai? Ajay: Chasme ke saath 75kg. Dr: Aur chasme ke bina? Ajay: Voh mujhe dikhta hi nahi.

SMS WhatsApp

Double Clicking on the

Double Clicking on the title bar of a window, will minimize a maximized window, and maximize a minimized window.

SMS WhatsApp

EXCEL SELECTION TIPS To

EXCEL SELECTION TIPS To select an entire column: CTRL + Space To select an entire row: SHIFT + Space To select an entire worksheet: CTRL + A

SMS WhatsApp

EXCEL TIPS To get

EXCEL TIPS: To get the current date in a cell press CTRL + ; To get the current time in a cell Press CTRL + :

SMS WhatsApp

EXCEL TIPS To go

EXCEL TIPS To go to the first cell of the row : Home End of column : CTRL + down arrow Move to next worksheet : CTRL + PageDown

SMS WhatsApp

Excel To re perform

Excel: To re-perform the function performed earlier press F4. Eg: When cell is inserted and you press F4 another cell will be inserted.

SMS WhatsApp

Get tired of red

Get tired of red lines while typing your name or other proper nouns in Word! Now simply add these into dictionery. Right click on the word and click add.

SMS WhatsApp

If U have made

If U have made a spelling mistake in word, it will be underlined in RED. Right click on it & suggested spellings will be given.

SMS WhatsApp

If U have multiple

If U have multiple programs running & wanna browse thru them, press Alt + Tab. Use the Tab key to scroll your way across the programs.

SMS WhatsApp

If you continuously press

If you continuously press ALT + F4 at first all windows will close and eventually the computer will shut down.

SMS WhatsApp

If you do not

If you do not want a CD to start just once it is inserted, press SHIFT when you put it in the drive.

SMS WhatsApp

If you wanna keep

If you wanna keep the same file in 2 or more folders, make a file shortcut and store them in required folders. If changes are made, they will reflect everywhere.

SMS WhatsApp

In Excel To open

In Excel, To open the Format cell box, you can right click on cell and select FORMAT CELLS or simply press CTRL + 1.

SMS WhatsApp

In word If the

In word, If the curser was at a place and you moved it, Use the SHIFT + F5 key to go to let the curser go to that exact place where it was before it was moved.

SMS WhatsApp

In Word SHIFT F3

In Word, SHIFT + F3 keeps changing the case of the selected text. This will help to change the case to upper, lower, etc.

SMS WhatsApp

INTERNET BROWSER SHORTCUTS To

INTERNET BROWSER SHORTCUTS: To Add the current pg to Favorites: CTRL + D To Maximize a window: ALT + SPACE + X To Minimize a window: ALT + SPACE + N

SMS WhatsApp

INTERNET EXPLORER SHORTCUTS To

INTERNET EXPLORER SHORTCUTS : To Open Favorites Bar: Ctrl + I To Select text in address bar: Alt + D

SMS WhatsApp

Make a shortcut of

Make a shortcut of Ur favorite site. Go to address bar of the site & drag it on the desktop. Bingo! U have Ur short cut.

SMS WhatsApp

Next time you are

Next time you are using your arrow keys to go from one letter to another in a sentence, Press CTRL + arrow. You will go one word at a time.

SMS WhatsApp

Press the CTRL N

Press the CTRL + N key to open a new window in a particular program. This works in Word, Excel and Internet Explorer.

SMS WhatsApp

Press Win the key

Press Win (the key with the windows logo on it) + D, to close all the open windows at once. Hold WIN + D again, action will be reversed.

SMS WhatsApp

The SHIFT F10 key

The SHIFT + F10 key, works in the same way as a right click of a mouse. Use the arrow keys to navigate to the item you want to try it on.

SMS WhatsApp

To copy text from

To copy text from Excel to Word, go to Edit select paste special and click on Microsoft Excel Worksheet Object, the lines of excel dissappear

SMS WhatsApp

To copy text you

To copy text, you can select it, press control and drag it to its new location. Pretty neat!!

SMS WhatsApp

To edit a cell

To edit a cell, Click on the cell, then press F2. You can now start editing it. F2 also allows you to see the formula input.

SMS WhatsApp

To open the My

To open the My computer directly, Press Win (the key with the windows logo on it) + E

SMS WhatsApp

To open the start

To open the start menu without using a mouse, press CTRL + ESC key

SMS WhatsApp

To permanantely delete a

To permanantely delete a document, press SHIFT + DELETE. The document will not be sent to Recycle bin, & directly deleted

SMS WhatsApp

To rename a file

To rename a file or folder, select it and press F2. A dialogue box opens, and you can rename the file or folder.

SMS WhatsApp

To save an image

To save an image from a web page to your computer, just right-click it and select ‘Save Picture As’ from the little menu that pops up.

SMS WhatsApp

To select a sentence

To select a sentence, Place Ur curser at the end of the sentence. Press SHIFT + CTRL + up arrow key. The entire sentence is selected.

SMS WhatsApp

To select a word

To select a word, Place Ur curser at the end of the word. Press SHIFT + CTRL + left arrow key. The entire word is selected.

SMS WhatsApp

To select text from

To select text from the cursor to end of line you could Press SHIFT + END or CTRL + SHIFT + DOWN arrow.

SMS WhatsApp

To select text from

To select text from the cursor to beginning of line you could Press SHIFT + Home or CTRL + SHIFT + UP arrow.

SMS WhatsApp

To use the menus

To use the menus in windows without a mouse, press the ALT + underlined alphabet on the menu. Eg. Press ALT + F, to open the FILE menu

SMS WhatsApp

Use F7 to spell

Use F7 to spell check your word documents before saving or mailing them. Spell check will make Ur documents look more professional.

SMS WhatsApp

Uses of F4 key

Uses of F4 key: ALT + F4 : Closes all the Windows of a program. CTRL + F4 : Closes only open window of a particular Program

SMS WhatsApp

Uses of the WIN

Uses of the WIN KEY (the key with the windows logo on it): WIN + M minimizes open windows. WIN + SHIFT + M will undo minimization of windows

SMS WhatsApp

Uses of the WIN

Uses of the WIN KEY (the key with the windows logo on it): WIN + R will open the Start menu’s Run box WIN + F will open the Start menu’s Find window

SMS WhatsApp

When U insert a

When U insert a table in Word, using the Tab key will jump cells. But if u need the Tab key to space out txt in the cell, Use CTRL + TAB.

SMS WhatsApp

WORD ALLIGNMENT SHORTCUTS Left

WORD ALLIGNMENT SHORTCUTS: Left alignment : CTRL + L Center alignment : CTRL + E Right alignment : CTRL + R Justified : CTRL + J

SMS WhatsApp

WORD SHORTCUTS Close a

WORD SHORTCUTS : Close a file: CTRL + W Print Preview: CTRL + F2 To Minimize a window press CTRL + F5

SMS WhatsApp

WORD SHORTCUTS Delete previous

WORD SHORTCUTS : Delete previous word : CTRL + Backspace Apply bulleted list : CTRL + SHIFT + L Page break : CTRL + Enter

SMS WhatsApp

WORD SHORTCUTS Go to

WORD SHORTCUTS : Go to beginning of document : CTRL + Home Go to end of document : CTRL + End

SMS WhatsApp

WORD SHORTCUTS To Go

WORD SHORTCUTS : To Go to beginning of line: HOME To Go to end of line: END To chk spellings, select the word & press F7

SMS WhatsApp

WORD SHORTCUTS To make

WORD SHORTCUTS: To make text Subscript: CTRL + = To make text Superscript: CTRL+SHIFT + =

SMS WhatsApp