Excel – Conditional Formatting based on another Cell
When you want to format a cell based on the value of a different cell, for example to format a Read More …
Tag: 2007
Print Email Attachments without opening the message (Microsoft Outlook)
If you want to print Outlook Email’s attachment without open them, then let’s look at various methods by which you Read More …
Extract 300 DPI High Resolution Image Files for Publications (Microsoft Powerpoint)
You may have known already that most of publishers do not accept PowerPoint slides as figures. By default, when you Read More …
Evaluate value between numbers (Excel)
Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) Generic formula =AND(val>MIN(num1,num2),val<max (num1,num2)) Read More …
Filter CC or Bcc emails (Outlook)
In daily work you may receive some emails that are CC or Bcc to you in Microsoft Outlook frequently. Now, Read More …
Remove Bookmarks & Cross-References (Microsoft Word)
Have you ever been in the situation that you editing a document with many bookmarks you want to get rid Read More …
Adding page numbers (Microsoft Word)
Word can automatically label each page with a page number and place it in a header, footer, or side margin. Read More …
How to control Macro Settings using registry keys or GPOs
For Office applications (Excel/Word,..), there are group policies that control the Macro Settings that can be checked in File (Backstage)->Options->Trust Read More …
Turn off e-mail matching for certificates in Outlook
When you send an encrypted email message to a recipient, Outlook uses the recipient’s certificate to secure the message. If Read More …
Import and export certificate (Digital IDs) in Outlook
For the sake of identification and secure communication, you may use or be required to use the digital ID or Read More …