Editing
Microsoft Excel
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== Copy & Paste == === from spreadsheet application to another spreadsheet application === {{#widget:Iframe |url=https://docs.google.com/spreadsheet/pub?key=0AuFlnVY9TNrsdDJodlRYRG1zWUY4dFd4SktiZzVyYlE&single=true&gid=0&range=A1%3AH8&output=html |width=100% |height=AUTO |border=1 }} [https://docs.google.com/spreadsheet/ccc?key=0AuFlnVY9TNrsdDJodlRYRG1zWUY4dFd4SktiZzVyYlE&usp=sharing 線上編輯上面表格] * Microsoft Excel --> Google Spreadsheet: ** columns & rows: Copy & Paste is ok * Plain text --> Google Spreadsheet: ok ** columns: {{kbd | key = Tab}} separated columns --> Google Spreadsheet: ok ** rows: {{kbd | key = Enter}} separated rows --> Google Spreadsheet: ok * Plain text --> Microsoft Excel: ok ** columns: {{kbd | key = Tab}} separated columns --> Microsoft Excel: ok ** rows: {{kbd | key = Enter}} separated rows --> Microsoft Excel: ok * Microsoft Excel --> Table of Google Document: ** columns & rows: Copy & Paste is ok * Plain text --> Table of Google Document: fail {{exclaim}} Suggest you copy to Microsoft Excel first and then copy paste to Google Document from Microsoft Excel. ** columns: {{kbd | key = Tab}} separated columns --> Table of Google Document: fail ** rows: {{kbd | key = Enter}} separated rows --> Table of Google Document: fail * Plain text --> Microsoft Excel: ok ** columns: {{kbd | key = Tab}} separated columns --> Microsoft Excel: ok ** rows: {{kbd | key = Enter}} separated rows --> Microsoft Excel: ok * [http://www.youtube.com/watch?v=Q43U-7r5AMk&desktop_uri=%2Fwatch%3Fv%3DQ43U-7r5AMk&nomobile=1 How-to Create and Copy a Table in Google Mail (Gmail) from Excel - YouTube] further reading * [http://www.playpcesor.com/2016/03/note-to-table-google-sheet.html 純文字筆記也能一鍵轉表格! Google 試算表小技巧 - 電腦玩物] === from spreadsheet application to editor application === * Copy the table from Gmail/HTML ... ** Paste to MS Excel: the border line of table is missing {{exclaim}} ** Paste to MS Word: the border line of table is exists after posted * Copy the table from MS Excel ... ** Paste to Gmail: the border line of table is missing {{exclaim}} ** Paste to MS Word: the border line of table is exists after posted * Copy the table from MS Word ... ** Paste to Gmail: the border line of table is exists after posted ** Paste to MS Word: the border line of table is exists after posted
Summary:
Please note that all contributions to LemonWiki共筆 are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see
LemonWiki:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
Tools
What links here
Related changes
Special pages
Page information