Many people are accustomed to design tables in spreadsheet and then insert it into document. However, in Google document and spreadsheet, when you select an area of table in spreadsheet, copy and then paste it in Google document, the format of the table will lost. => you just can't do it in this way
Well, now you can follow next steps to do this:
- export Google spreadsheet to your computer in MS Excel format (.xls)
- open it with MS Excel, select the area of the table and copy,
- then paste it to Google document.
1. if you don't have MS Excel software, you can download the free Excel Viewer to open the file. The download link is: Excel Viewer 2003
Now you will get the table in Google document with the format you expect.
tip 2 - Create a temp document and temp spreadsheet for random use
Usually each document and spreadsheet has its specific usage and also has a meaningful name. However, there's some time you just want to type something and you don't want to keep them long or keep it in an organized method, for examples:
- In spreadsheet, you only want to test that a function in a Formula works well in an spreadsheet
- In document, you jot down some of you thoughts, and want to arrange them later
To meet the needs, just creating temp document and temp spreadsheet. When you have no idea on the right file to work, you can use the temp document or spreadsheet. => Seems a very simple tip, but it is useful.
tip 3 - Hide files in "active file" view of Docs home
The "active" file view list all the files in the last 30 days. To have a clean look, you may want to hide some files that you don't work in it.
To do this, just select the file and then click the "Archive" in the top, the file then will be hidden.
To see it again, select browse "all" view
tip 4 - Enable spelling check with Fixfox
In Google document, the spelling can be checked with a button at the left-down corner. However, till now, this function is not available in Google spreadsheet.
This problem can be partly resolved by using Firefox. Firefox can check spelling when you type words. When the words typed is worng, a red line will be shown under the words, so that you can be informed and correct the words.
============================================
to be added

No comments:
Post a Comment