Microsoft Excel Shortcut Keys

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

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.

Draft Background in Word

This trick shows you how to add a grey background text on your document. For example, when you have a draft document, and you want to make sure other people know it is a draft version. It is a good idea to have a background printed text, i.e. "DRAFT" on every page of your document. This feature is called "Watermark" in MS Word.
You can follow the same steps to create different watermarks. For example "SAMPLE", "DRAFT", "PERSONAL", or your own text.

Here's a sample



Here's how

1. Select "Format" on the top menu of Microsoft Word, then select "Background".
   
2. Select "Printed Watermark".
   
3. On the "Printed Watermark" dialog box, select "Text Watermark". Then select your desire text or enter your own text into the "Text" field
   
   
   
4. Click "OK" to finish.

Add Author Information into Word Document

This trick shows you how to add some additional information to a Microsoft Word document. The information can be the name of the author, company, title, revision number, etc... When you open the folder which contains your document, and point the mouse to the document, the information will be displayed.

Here's a sample

Here's how

1. Open the folder that contains the document.
   
2. Right-click on the document and select "Properties".
   
3. On the "Properties" dialog, select the "Summary" tab.
   
4. Under the "Summary" tab, the fields are listed by two columns "Property" on the left and "Value" on the right.
   
   
   
   
5. Click on a field (i.e. "title") you want to edit, then edit its value. Then click "OK"

Find Product Key for Windows and Office

If you are looking for a way to retrieve the product keys of your MS Windows or MS Office, you are on the right page!
The following is a tool to detect the product keys of Microsoft Windows and Microsoft Office installed on your machine. This tool is free to download at Magical Jelly Bean.
Here's a screenshot


The tool also provides some nice features let you change your Windows product key, or detect the key remotely to another computer.

To download a copy of this tool. Click Here.

Convert Any Document or Web Page to PDF

Somebody just told you that you need to have Adobe Acrobat (Writer) to create a PDF file? Guess what, you can get away from that pricey piece of software if you just need to convert some documents to pdf, without a need of fancy editing the pdf document.
Here's how. Thanks to the BullZip, who provides a Free Pdf printer. With this free tool, you can simply "print out" your document or webpage to a pdf file, just about the same way as you print it out to a printer.

You can visit BullZip.com for more information about the software.
Here the direct link to BullZip downloads page: Downloads

1. To get started, first follow the link above and download Free Pdf Printer from BullZip, then install it to your computer.
2. Once you're done, you might need to close the program (or the web browser) which you're currently viewing the document. This helps refreshing the list of available printers on your computer.
3. Once you get back to the document you want to convert, perform the same steps are you print out the document, i.e. File > Print ...
4. When you see the Print window pop-up, select "Bullzip PDF Printer" under "Printers", then click "OK".
5. BullZip PDF Printer will then start to analyze your document and display a new pop-up window, where you can direct it to the location you want to save the pdf file.
6. Follow the pop-up windows and.. hola! The PDF document is created!

Add Watermark to an Excel Document

Unfortunately, the printed watermark feature is not available on any version of Excel (including Excel 2007, 2010). However, there are some workaround methods to add text or images into an Excel document that would result something similar to a watermark.

The followings are examples of Excel Documents with text and image "watermark":





Step-by-step to add a watermark to an Excel document (applied for Microsoft Word 97-2010):
A. TEXT WATERMARK:
The trick is to place a WordArt on the background of the Excel sheet.

Microsoft Excel 97/2000/XP (2002)/2003:

1. Open the Excel document that you want to add watermark to.
2. Select "Insert" from the top menu, then select "Picture" > "WordArt...".
3. In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".
4. In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".
5. Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".
6. In the "Format WordArt..." dialog, select "No fill" for "Fill"/"Color".
   Also select a brighter color (i.e. gray) for "Line"/"Color" then click "OK".
   
7. Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".
8. Click and drag the WordArt to position it where you like.
   Note: The WordArt needs to be manually placed on each page of the document.

Microsoft Excel 2007/2010:

1. Open the Excel document that you want to add watermark to.
2. Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".
3. Select the WordArt style you want, then type the text for your watermark.
4. Under "Drawing Tools", select "Format".
5. In the group "WordArt Styles" change "Text Fill" to "No fill".
6. Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".
7. In the group "Arrange" select "Send to Back".
8. Click and drag the WordArt to your preferred position.
   Note: The WordArt needs to be manually placed on each page of the document.

B. IMAGE WATERMARK:
To insert an image watermark, use the header feature in Excel as follows...

Microsoft Excel 97/2000/XP (2002)/2003:

1. Open the Excel document that you want to add watermark to.
2. Select "View" from the top menu, then select "Header and Footer".
3. In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.
4. In the "Header" dialog, click on the middle box "Center section"
5. In the middle of this dialog box, there are some tool buttons. We're going to use the last two buttons to insert and format the image.
6. Click on the Insert Picture button (the second-to-last button with an image of a mountain)
7. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
8. A text "&[Picture]" is now placed in the middle box named "Center section".
9. Click on the Format Picture button (the last, right-most button).
10. Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".
11. At this point, you can click "OK" to finish, and do a "Print Preview" to see your watermark. However, you will notice that the image is placed far on the top of the page, which doesn't look usual for watermarks. To fix this, click on the middle box named "Center section" again and enter a few blank lines before the text "&[Picture]".
12. Once you're all done, click "OK" to exit and open "Print Preview" to see your watermark. (The watermark will not be displayed in normal view.)

Microsoft Excel 2007/2010:

1. Open the Excel document that you want to add watermark to.
2. Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".
3. Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.
4. On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".
5. Navigate to the folder where your watermark image is located. Select the image and click "Insert".
6. A text "&[Picture]" is now placed in the middle box of the header.
7. To move the picture down on the page, click on the header and place the cursor before the text "&[Picture]", then hit Enter a few times.
8. To see the watermark, either open the "Print Preview" or click on any cell of the document.

Add Watermark to a Word Document

You can insert a watermark into a Microsoft Word document as either text or image.
Here is a sample Word Document with text watermark:


And here is an example of picture watermark:



Step-by-step to add a watermark to Word document (applied for Microsoft Word 97-2010):
Microsoft Word 97/2000/XP (2002)/2003:

1. Open the Word document that you want to add watermark to.
2. Select "Format" from the top menu, then select "Background", then "Printed Watermark".
3. In the "Printed Watermark" dialog:
   
   A. To insert a text watermark:
   • Select the "Text watermark".
   • Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
   • Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
   • Watermark is now inserted into your document.
   
   B. To insert an image watermark:
   • Select the "Picture watermark".
   • Then click on the button "Select Picture...".
   • Navigate to the directory where your watermark picture is located. Select it and click "Insert".
   • Select a customized scale if desired, then click "OK".
   • The image is now inserted into your document as watermark.

Microsoft Word 2007/2010:

1. Open the Word document that you want to add watermark to.
2. Select the "Page Layout" Tab from the top menu
3. In the "Page Background" group, select "Watermark".
4. You can now select one of the pre-defined watermarks, or if you wish to use your own text/image, select "Custom Watermark" at the bottom.
   At the "Printed Watermark" dialog:
   
   A. To insert a text watermark:
   • Select the "Text watermark".
   • Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
   • Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
   • Watermark is now inserted into your document.
   
   B. To insert an image watermark:
   • Select the "Picture watermark".
   • Then click on the button "Select Picture...".
   • Navigate to the directory where your watermark picture is located. Select it and click "Insert".
   • Select a customized scale if desired, then click "OK".
   • The image is now inserted into your document as watermark.