Welcome to My Office Power

Below is a listing of all the major shortcut keys in Microsoft Word. Shortcut Keys Description 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 Paste . 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...

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. Example: =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. Example: 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 formul...

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 1. http://www.pdfonline.com/pdf2word/index.asp 2. http://convertpdftoword.net/ 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!!

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, the...

Excel Games: Besides you work with excel for your office you can also have fun playing exciting games in excel look at this and try it click here to download this is a sample game from excelgames.org