To insert a spreadsheet into a Write document, position the cursor in the Write document at the point where you want the spreadsheet to go and do one of the following:
Insert a new spreadsheet
Select Spreadsheet/Chart and then New from the Insert menu. A standard spreadsheet will appear, ready for entering data.
Insert an existing spreadsheet
Select Spreadsheet/Chart and then From File from the Insert menu.
Browse to the spreadsheet you want to insert.
Once the spreadsheet, whether new or old, has been inserted, you can display a selected part of the spreadsheet or a certain area of rows and columns. In edit and display mode, you can use the zoom buttons to make the cells - and hence the data within them - display larger or smaller. In scaling mode, you can scale the spreadsheet to fit more neatly into your Write document.
On the standard spreadsheet view, that is in edit mode, use the handles to resize the spreadsheet and the scroll arrows to bring the relevant part of the spreadsheet into view. In this way you can determine the rows and columns that will be displayed and/or a particular cell or group of adjacent cells. Use the zoom buttons on the toolbar, Zoom in and Zoom out
, to increase or decrease the size of the spreadsheet cells and their data. Note that the inserted spreadsheet object (or view) will itself remain the same size until you use the handles to resize it, so you may need to resize in conjunction with zooming.
Click once outside the spreadsheet to go to display mode. The spreadsheet will retain the form you set for it in edit mode, that is the same rows and columns or group of cells will be displayed. In this mode you can’t edit the data or resize the spreadsheet, and the row and column bars are not visible. You can however use the zoom buttons to increase or decrease the size of the displayed cells and their data.
Click once again inside the spreadsheet to go to scaling mode. The spreadsheet is displayed with its handles visible. Use the mouse to drag these handles and hence resize the rows and columns. Dragging horizontally only will increase/decrease the column width for all the columns. Dragging vertically only will increase/decrease the row height for all the rows. Dragging diagonally, using the handle at the bottom right corner, will increase/decrease both the column width and row height for all rows and columns.
Double-click inside the spreadsheet to return to the standard spreadsheet view (edit mode).
Note that when printing a Write document with an inserted spreadsheet, the spreadsheet object is printed without the row and column bars, that is to say, it is printed as if it is in display mode, even if the current screen view happens to show the spreadsheet in edit mode.
If you wish to insert a chart, based on a spreadsheet, into a Write document, see Inserting a chart into Write for more information.
See also: