Thursday, October 29, 2009

Microsoft Word shortcut keys

Below is a listing of all the major shortcut keys in Microsoft Word.
Shortcut Keys
Ctrl + A
Select all contents of the page.
Ctrl + B
Bold highlighted selection.
Ctrl + C
Copy selected text.
Ctrl + E
Aligns the line or selected text to the center of the screen.
Ctrl + F
Open find box.
Ctrl + I
Italic highlighted selection.
Ctrl + J
Aligns the selected text or line to justify the screen.
Ctrl + K
Insert link.
Ctrl + L
Aligns the line or selected text to the left of the screen.
Ctrl + M
Indent the paragraph.
Ctrl + P
Open the print window.
Ctrl + R
Aligns the line or selected text to the right of the screen.
Ctrl + T
Create a hanging indent.
Ctrl + U
Underline highlighted selection.
Ctrl + V
Ctrl + X
Cut selected text.
Ctrl + Y
Redo the last action performed.
Ctrl + Z
Undo last action.
Ctrl + Shift + F
Change the font.
Ctrl + Shift + >
Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]
Increase selected font +1pts.
Ctrl + Shift + <
Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [
Decrease selected font -1pts.
Ctrl + Shift + *
View or hide non printing characters.
Ctrl + <left arrow>
Moves one word to the left.
Ctrl + <right arrow>
Moves one word to the right.
Ctrl + <up arrow>
Moves to the beginning of the line or paragraph.
Ctrl + <down arrow>
Moves to the end of the paragraph.
Ctrl + Del
Deletes word to right of cursor.
Ctrl + Backspace
Deletes word to left of cursor.
Ctrl + End
Moves the cursor to the end of the document.
Ctrl + Home
Moves the cursor to the beginning of the document.
Ctrl + Spacebar
Reset highlighted text to the default font.
Ctrl + 1
Single-space lines.
Ctrl + 2
Double-space lines.
Ctrl + 5
1.5-line spacing.
Ctrl + Alt + 1
Changes text to heading 1.
Ctrl + Alt + 2
Changes text to heading 2.
Ctrl + Alt + 3
Changes text to heading 3.
Ctrl + F1
Open the Task Pane.
Open Help.
Alt + Ctrl + F2
Open new document.
Ctrl + F2
Display the print preview.
Shift + F3
Change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert
Repeat the last action performed (Word 2000+)
Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6
Opens to another open Microsoft Word document.
Spell and grammar check selected text and/or document.
Shift + F7
Runs a Thesaurus check on the word highlighted.
Save as.
Shift + F12
Ctrl + Shift + F12
Prints the document.
Alt + Shift + D
Insert the current date.
Alt + Shift + T
Insert the current time.
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
Mouse shortcuts
Click, hold, and drag
Selects text from where you click and hold to the point you drag and let go.
If double-click a word, selects the complete word.
Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-clicking anywhere after text on a line will set a tab stop.
Selects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheel
Zooms in and out of document.

Monday, October 19, 2009

Relative and Absolute Cell References

Relative and Absolute Cell References

Excel uses two types of cell references to create formulas.  Each has its own purpose.  Read on to determine which type of cell reference to use for your formula. 

Relative Cell References

This is the most widely used type of cell reference in formulas.  Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.


=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.

Absolute Cell References

Situations arise in which the cell reference must remain the same when copied or when using AutoFill.  Dollar signs are used to hold a column and/or row reference constant.


In the example below, when calculating commissions for sales staff, you would not want cell B10 to change when copying the formula down.  You want both the column and the row to remain the same to refer to that exact cell.  By using $B$10 in the formula, neither changes when copied.

A more complicated example:

Let's pretend that you need to calculate the prices of items in stock with two different price discounts. Take a look at the worksheet below.

Examine the formula in cell E4. By making the first cell reference $C4, you keep the column from changing when copied across, but allow the row to change when copying down to accommodate the prices of the different items going down.  By making the last cell reference A$12, you keep the row number from changing when copied down, but allow the column to change and reflect discount B when copied across.  Confused?  Check out the graphics below and the cell results.

Copied Across

Copied Down

Now, you might be thinking, why not just use 10% and 15% in the actual formulas?  Wouldn't that be easier? Yes, if you are sure the discount percentages will never change - which is highly unlikely.  It's more likely that eventually those percentages will need to be adjusted.  By referencing the cells containing 10% and 15% and not the actual numbers, when the percentage changes all you need to do is change the percentage one time in cell A12 and/or B12 instead of rebuilding all of your formulas. Excel would automatically update the discount prices to reflect your discount percentage change.

Summary of absolute cell reference uses:



Allows the row reference to change, but not the column reference.


Allows the column reference to change, but not the row reference.


Allows neither the column nor the row reference to change.

There is a shortcut for placing absolute cell references in your formulas!

When you are typing your formula, after you type a cell reference - press the F4 key.  Excel automatically makes the cell reference absolute!  By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.  For example, in the first absolute cell reference formula in this tutorial, =B4*$B$10, I could have typed, =B4*B10, then pressed the F4 key to change B10 to $B$10.  Continuing to press F4 would have resulted in B$10, then $B10, and finally B10. Pressing F4 changes only the cell reference directly to the left of your insertion point.

I hope this tutorial has made these cell reference types "absolutely" clear!

Monday, October 12, 2009

Converting PDF file to Ms Word

Some times you may come across a situation where you would be looking for a software which can convert your PDF file to Word. So dont worry it is simple and easy!!. Here i am providing your some of the sites which will let you convert your PDF document to Ms Word for free of cost. Please follow these links


Some sites provide you PDF to word converting software for a nominal charge. You may also check from the google search engine by typing " convert PDF to Word" that's it. Enjoy! :) Happy Converting!!

Saturday, October 10, 2009

Cell Locking in Microsoft Excel

There's pretty much just two reasons for locking cells:
  • To restrict entry (locked cells may not be changed)
  • To allow tabbing to different cells for entry (unlocked cells can be
    tabbed through)
The points you should know are these:
  • All cells are locked by default
  • Cell locking doesn't take effect until you protect your worksheet (ToolsàProtectionàProtect
    Sheet to "lock" or ToolsàProtectionàUnprotect
    Sheet to "unlock")
  • If you want most cells locked, then only unlock those you want users to be
    able to change
  • If you want most cells unlocked, then unlock them all first, and then lock
    only those you want prohibit users from changing

Select All Cells

Just click the button above Row 1 and to the left of Column A. This selects
all the cells on your worksheet.

Lock/Unlock Cells

Go to FormatàCells. Choose the
Protection tab. Lock or unlock the cells as desired.

You can quickly lock/unlock cells by locking or unlocking one or
more cells, then continue by using the F4 button, which repeats the last
command. So, while you may have 30 different cells on a worksheet that you want
to unlock, you can select, F4, select, F4...

Monday, October 5, 2009

Excel Games

Excel Games:

Besides you work with excel for your office you can also have fun playing exciting games in excel

look at this
this is a sample game from