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:07] laura [Data > Group/Ungroup] |
generalreference:excel [2020/07/06 20:59] (current) |
||
|---|---|---|---|
| Line 29: | 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 56: | 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 75: | 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 87: | Line 89: | ||
| ---- | ---- | ||
| ===== Input message ===== | ===== Input message ===== | ||
| + | <color #ed1c24>**THIS AND THE TWO BELOW HAVE NO CONTENT TO TRANSFER.**</color> | ||
| ---- | ---- | ||
| Line 116: | 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. | ||