I became aware of this issue in http://www.sciencemag.org/news/sifter/one-five-genetics-papers-contains-errors-thanks-microsoft-excel?utm_source=newsfromscience&utm_medium=facebook-text&utm_campaign=excel-6929. The following user-defined Function is a start. You can add to the Case statement to add whatever gene names you like, with the caveat that once Excel finds a match, it will jump out … Continue reading
Windows 10 makes it easy to view two documents side-by-side. Click into one of the docs, and press the Windows key + left arrow. The windows will slide to the left side, taking up exactly half of the screen. All … Continue reading
We have all hit the Send button a little too soon, and then wished we could somehow retrieve the message. If you create a rule in Outlook that delays sending all email by 2 minutes, you can simply delete the … Continue reading
Suppose you need to hide a small section of data in Excel, but you still want to calculate with it. Highlight the cells, right-click, and select Format Cells. Click the Number tab, and select the Custom category on the left. … Continue reading
To save a chart as a template: Create your chart, and then right click it. Select Save as Template… You’ll save a file with a CRTX extension in your default Microsoft Excel Templates folder. To create a new chart based … Continue reading
Right-Clicking in Google Drive You can now right-click on items in Google Drive to display a context-sensitive menu. Using the SHIFT and CTRL Keys in Google Drive You can now use the SHIFT key to select a group of items. … Continue reading
To set default text: Select the text you want to make the default for all documents. Click the Styles drop-down menu, and then select Normal text > Update ‘Normal text’ to match. This sets the current text style as normal. … Continue reading
To quickly “star” (or “unstar”) an item in Google Docs, press the “s” key on the keyboard. To view all starred items (favorites), click Starred in the left column of the Google Drive main screen.
To quickly view keyboard shortcuts in Google Docs, press CTRL + / (forward slash).
The best solution to this problem is to change an option in Word that sets up a DDE connection with Excel, and displays the zip code the way it is formatted in Excel, with all leading zeroes. (See Mail Merge … Continue reading