But the system you describe sounds maddeningly over-engineered to me. Or you could let your supervisor write on a hard copy and you type the changes. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. a line break can also be entered directly into the formula bar by pressing ALT + Enter. In cell B19 in the screenshot above, we have the following formula. (13) on a Mac) is equivalent to inserting a new line into a formula. It sounds to me like your company needs the services of a good IT professional to set up some sort of environment in which your supervisor has direct access to the data that needs editing. Excel online has a limited version of the Windows character set. If working on a Mac, we highly recommend installing Windows as a virtual machine (WST recommends VMware) and installing Excel for Windows. Training recommends Excel for Windows due to keyboard shortcut compatibility issues. Also, ensure that your Num Lock key is turned on. You must use the numeric keypad to type the alt code.
So how is it done Using Shift-Enter doesnt work, but fortunately there is another key combination that does work: Ctrl-Alt-Enter (or Ctrl-Option-Enter) That works perfectly - problem solved Im using Excel for Mac 2011 but I expect it will work in all Mac versions. For Windows users, use the Alt Code method by pressing down the Alt key whilst typing the Not Equal To symbol alt code which is 8800. Simply hitting the enter key makes Excel jump to the next cell. Now the Paste and Keep Text Only button will get Alt 3 as the keyboard. Mac Excel Compatibility Critical Keyboard Shortcuts Excel for Mac (2008 & 2011) Wall St. For Mac users, the keyboard shortcut for Not Equal to Symbol is Option +.
How did you two come up with this way of doing things? The result is the same as in Excel: The value from D3 (250) is copied to F3 as.
This may sound a little harsh, but … can your supervisor not simply edit the file in Excel? Does s/he not have Excel? Or has it but doesn’t know how to use it? What’s the barrier to simply attaching the Excel sheet to the outgoing email, rather than dumping the text into the body of the email? I don’t really get how this copy-and-paste process you describe evolved.