tfosorciM.org

Copying Data from Excel to OneNote 2003

The following describes one technique to copy data from an Excel spreadsheet to OneNote.

1. Select the the desired data in Excel, for example by dragging the mouse. Unless you want lots of whitespace in OneNote be careful not to include blank columns in Excel.
2. Use Ctrl+C to copy the Excel data
3. Go to the desired OneNote page and hit Ctrl+V to paste (or right click and select Paste from the context menu).

At that point the columns will often include some undesired whitespace. To adjust the width of columns to give a more tidy display do the following:

1. Click in text to the right of the column whose size you want to change.


2. A four-headed arrow will appear about 0.5cm to the left. Right click on it and select the Resize Previous Column option (it's the last one on the context menu).


3. Then drag the two-headed arrow which displays in front of the four-headed arrow to the left until you achieve the desired column width.

Be careful when making a column narrower because data can then spread over two lines rather than one.