Sunday, January 11, 2015

Embed Excel into Word

Embed Excel into Word

we need to know how to Embed Excel sheet into Word documents in case you have to create reports for presentations and want to include an Excel sheet for reference. It’s no trouble at all simply to embed the excel file directly in your Microsoft Word documents and how you do it.

Excel chart show in Word File

1. Select the tables or cells in the Excel sheet which you want to embed in your Word document file and copy it to the clipboard by pressing Ctrl+C.
Embed Excel into Word


2. Now go to your Word document and click the cursor where you want the chart to be placed, go to the Paste button in your toolbar and click Paste Special.
Embed Excel into Word


3. When you select paste special then open dialogue box select the Microsoft Excel Worksheet Object as the method of pasting.

Embed Excel into Word

4. then Ensure that the  radio button is selected and click OK to insert the linked chart into your  excel document embed excel sheet (Paste Link means that when the original changes, the destination cell automatically changes as well, so it’s easier to update worksheets.)
Embed Excel into Word

Friday, January 9, 2015

Use Ctrl Easily Navigatecells

 Use Ctrl  Easily Navigate cells


         When you're debugging a worksheet, you can easily navigate through all the cells referenced in a formula.
  • Highlight the cell and press Ctrl-[ (that's Ctrl-open-square-bracket). 
  • Excel highlights all the cells referenced by the formula, and moves the current selection to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell
  • Continue to press Enter to move though the rest of the referenc