How to Delete Identical Rows in a MS Excel Worksheet
PROBLEM: Your MS Excel worksheet (see below) contains hundreds of identical rows and you’d like to delete them without spending hours to search and identify them. SOLUTION: Follow these steps… 1) Select all the rows in your worksheet, including the column headers (if any). 2) Click and select the DATA tab on the ribbon. 3) In…
Read MoreHow to Cross Electronic Circuit Wires Properly with Adobe Illustrator
In Adobe Illustrator, one of the most frustrating electronic circuit drawing element is two wires crossing each other likes this: However, there is no Illustrator tool to draw the crossing as above, that is, the elegant way. When you use the Pen, Pencil or Line tool, what is produced is this: Ugh! This is not…
Read MoreD.A.R.T Macros for Pharmaceutical and Regulatory Technical Writing with MS Word
The D.A.R.T.(Document Authoring and Readiness Tool) system of integrated MS Word macros does not offer any “structural authoring” functionality like some other Word macro systems do. For example, in my own field, “single s ourcing” is an important feature that saves untold hours by generating different deliverables from the same single source file. However, D.A.R.T. provides formidable standardization for text,…
Read MoreHow to Embed a Numbered List into a MS Word Paragraph
It’s easy to transform a group of MS Word statements into a numbered list. You just select them and then click the numbered list button on the tool bar. There are many reasons why one would choose to use a numbered list. Some of these reasons include: Easier to read, especially when the list is…
Read MoreHow to Display the Yellow Marker Easily to Highlight a MS Word Document
© Ugur Akinci Would you like to have a digital yellow marker to appear instantly when you need it to mark the important parts of your MS Word document? You can do that easily with a shortcut. Let’s say you have this document: You need your yellow marker? Just press Ctrl + Alt + H…
Read MoreHow to Add Numbered Footnotes Easily to a Word Document
Here is a shortcut that will save you countless hours when entering Word footnotes if you are writing articles and books. This is a great shortcut to add numbered footnotes to your pages. Imagine you have a page like this: (Click all images to enlarge them) Let’s say you’d like to add a footnote to…
Read MoreHow to Merge MS Excel Cells and Justify the Text with Macro
Merging MS Excel cells and centering the contents is so easy: you just select the cells and click the Merge & Center button on the Home tab of the ribbon. But what if you don;t want the content to center? What if you’d like to left- or right-justify the text within the merged cells? Then…
Read MoreHow to AutoRecover Unsaved Files in MS Word
To autorecover unsaved files in MS Word is a bit different than in MS Word 2010. It’s a bit more difficult, but not that difficult, really. Follow these steps: 1) Click the Office button and select Word Options to display the Word Options screen. Click Save from the left navigation bar. Make sure “Save Autorecover…
Read MoreHow to Find N-Character Words in a MS Word Document and Replace Them with Clipboard Content
@ Ugur Akinci PROBLEM: Imagine you’d like to replace the words “Press”, “Drive” and “Click” with “Activate” in a MS Word document with a single Find-and-Replace operation. You don’t want to perform a separate Find-and-Replace procedure for each word that you’d like to replace. Or worse, you know that the words you’d like to find…
Read MoreHow to Add a Watermark to a MS Excel Worksheet
As perhaps you’ve already discovered, MS Excel does not have a simple menu option to add a background watermark to a worksheet. But there is a way. Here is how: 1) Create and save your background image on your machine somewhere; for example, a pale pink “DRAFT” image. Make sure the image is light enough…
Read More