Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
generalreference:excel [2020/07/06 19:01] laura [Pivot Tables] |
generalreference:excel [2020/07/06 20:59] (current) |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| ===== Stop rows being inserted or deleted in Excel ===== | ===== Stop rows being inserted or deleted in Excel ===== | ||
| + | <color #ed1c24>**NOT MOVED TO ODOO, DOES NOT SEEM VERY HELPFUL (AND COULD NOT EVEN FIGURE OUT HOW THIS WORKS). FOR THIS PURPOSE, ONE CAN USE PROTECTION, SEE ARTICLE BELOW.**</color> | ||
| {{:generalreference:excel:stop_rows_being_inserted_or_deleted_in_excel.png|}} | {{:generalreference:excel:stop_rows_being_inserted_or_deleted_in_excel.png|}} | ||
| Line 21: | Line 22: | ||
| ==== Data > Group/Ungroup ==== | ==== Data > Group/Ungroup ==== | ||
| + | <color #ed1c24>**NO CONTENT TO TRANSFER**</color> | ||
| //VIDEO clip on to be inserted// | //VIDEO clip on to be inserted// | ||
| Line 28: | Line 29: | ||
| ==== Locking cells: Home > Font ==== | ==== Locking cells: Home > Font ==== | ||
| + | **<color #ed1c24>TRANSFERRED TO ODOO IN UPDATED FORM. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT LAURA OR SHINOH.</color>** | ||
| Step 1 | Step 1 | ||
| Line 55: | Line 56: | ||
| ==== Protect sheet: Review> Protect sheet ==== | ==== Protect sheet: Review> Protect sheet ==== | ||
| + | <color #ed1c24>**NO CONTENT TO TRANSFE**R</color> | ||
| ---- | ---- | ||
| ==== How to remove the password encryption ==== | ==== How to remove the password encryption ==== | ||
| + | **<color #ed1c24>NOT TRANSFERRED AS NOT CLEAR IF THIS IS HELPFUL - IS THIS ONLY ABOUT UNPROTECTING THE SHEET?</color>** | ||
| In the workbook you want to remove the password encryption, click **File > Info**, click the Protect Workbook button, and select Encrypt with Password in the drop-down menu. | In the workbook you want to remove the password encryption, click **File > Info**, click the Protect Workbook button, and select Encrypt with Password in the drop-down menu. | ||
| Line 74: | Line 76: | ||
| ==== Combine data from 2 cells (e.g. text) ===== | ==== Combine data from 2 cells (e.g. text) ===== | ||
| + | <color #ed1c24>**MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, CONTACT LAURA OR SHINOH.**</color> | ||
| You can combine data from multiple cells into a single cell using the Ampersand symbol (&). | You can combine data from multiple cells into a single cell using the Ampersand symbol (&). | ||
| Line 86: | Line 89: | ||
| ---- | ---- | ||
| ===== Input message ===== | ===== Input message ===== | ||
| + | <color #ed1c24>**THIS AND THE TWO BELOW HAVE NO CONTENT TO TRANSFER.**</color> | ||
| ---- | ---- | ||
| Line 99: | Line 102: | ||
| ==== How to convert CSV ==== | ==== How to convert CSV ==== | ||
| + | **<color #ed1c24>THE BELOW ARTICLE HAS BEEN MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT SHINOH OR LAURA</color>.** | ||
| [[tecdoc:csv2xls|How to save CSV as Excel]] | [[tecdoc:csv2xls|How to save CSV as Excel]] | ||
| Line 104: | Line 108: | ||
| ===== Pivot Tables ===== | ===== Pivot Tables ===== | ||
| - | <color #ed1c24>**MOVED TO ODOO UNDER 'USERFUL RESOURCES FOR EXCEL'**.</color> | + | <color #ed1c24>**MOVED TO ODOO UNDER 'USEFUL RESOURCES FOR EXCEL'**.</color> |
| There are many tutorials on the Web explaining what a pivot table is and how to create one. | There are many tutorials on the Web explaining what a pivot table is and how to create one. | ||
| Line 114: | Line 118: | ||
| ==== Extra Quotation Marks ==== | ==== Extra Quotation Marks ==== | ||
| + | <color #ed1c24>**MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT LAURA OR SHINOH.**</color> | ||
| When copying cells that contain multiple lines separated by one or several line breaks, the pasted text will have extra quotation marks. | When copying cells that contain multiple lines separated by one or several line breaks, the pasted text will have extra quotation marks. | ||