Office and IE

MS Office Applications – Word, Excel and Access – Time tested tips and tricks that make life easier

The most dramatic solution are found by readers on our Office and Applications forum.

How to properly zoom in Word and Excel – Ctrl+[+] and Ctrl+[-]

2017/08/15
By
Modified: 2017/06/25

    This is cool!   This is fresh!  Make your Word and Excel to respond to human zoom commands like normal applications. In most modern applications you can zoom in and zoom out current window using fast Ctrl + Plus and Ctrl + Minus keyboard shortcuts.   Not so in Word and Excel.  Even in the latest ones – from Office 2013 – you do not have this functionality.  Finally, finally here in this article you learn how to do it with macros.  Word partial idea was published before on other site (see below), but Excel technique uses new and exciting macro.   WORD To make keyboard combinations Ctrl+[+] and Ctrl+[-] to work in Word…

Read more »


WordPress: Image Editor is not loading in IE under tight security

2017/08/09
By
Modified: 2017/06/25
WordPress - Image Editor is not Loading

Let’s say you have a very thigh zone security setup in IE.   All Internet sites are set to High security level, and  Trusted sites are set a Medium-High. In that case you might experience a painful WordPress problem – Image Editor is not loading in IE.  It is getting stuck on a dark loading image. Symptoms: when you click on Add an Image or Edit Image buttons, all you see is your screen is darkening and running image in the middle imitating loading is staying on, forever. To solve this problem without killing your security settings add site about:blank to you trusted site list and here we go – problem is solved!

Read more »

Apply Color Scales Conditional Formatting to Multiple Rows in Excel

2017/07/24
By
Modified: 2017/06/25
Excel - Color Scale Conditional Formatting

When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro?  We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row.  You can try to fix the resulting formatting rules mess manually, or use this macro to set all formats in the range. First you n first row need to select the range were your conditional formatting will apply and clear all formatting rules. Next, you need to setup proper color scale conditional formatting in the first row of the range. Now, you should create a name range to reference…

Read more »

Read Registry value into a batch variable

2017/07/06
By
Modified: 2017/06/25
Rue-Sainte-Catherine--2015-

Before I forget, let me share with you a fantastic way to read values from Registry into a batch file variable. Say you need to determine, what is the date format of this machine.  Normally you would read a value from HKEY_CURRENT_USER\Control Panel\International like this: REG QUERY "HKCU\Control Panel\International" /v sShortDate   That command will produce an output similar to this: HKEY_CURRENT_USER\Control Panel\International sShortDate    REG_SZ    M/d/yyyy But you do not need all that.  All you need is the string  “M/d/yyyy” (or “yyyy-MM-dd”).  To get just that string you need to skip to a second line and read third field on the last line.  How you can do that in a batch…

Read more »

Properly Validate TextArea Length (IE vs. Firefox)

2017/06/26
By
Modified: 2017/06/25
Properly Validate TextArea Length (IE vs. Firefox)

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type="text/javascript"> function TTLength(objTT){ var tt= document.getElementById('TXT1'); tt.value = objTT.value.length; } </script> <textarea onKeyDown="TTLength(this);" onKeyUp="TTLength(this);" rows="10"> This Text Area Contains a string With Newline Characters </textarea>  <input type="text" id="TXT1" value="TT Length"/> Let’s see how this page behaves in IE8 and in Firefox 3.6.11. IE8 Firefox As you can see that IE and FF return two different values for the length of an identical  string in TextArea and that could be a serious problem, if you are trying to validate the string length before updating the…

Read more »

Count Number of Cell with Errors in Excel

2017/06/17
By
Modified: 2017/06/15

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »

IE10 is not saving passwords and user names

2017/04/27
By
Modified: 2017/03/03
IE10 is not saving passwords and user names

I hope this post will help a lot of frustrated users out there. PROBLEM: IE10 was working fine, but at one point it stopped saving user names and passwords for web sites. This most securely-configured browser, so switching was not an option.   Here is my solution.  Please see, if it works for you. SOLUTION: For extra security I’ve checked Delete browsing history on exit (see image 1).  I did it without understanding, what it is I am requesting to delete.  To solve my problem, I had to uncheck Cookies and website data on the very next Delete screen (see image 2).  Now IE10 is preserving user names in passwords for visited…

Read more »

Keyboard Shortcuts for Next, Previous, Euro, Degree Symbols and Moving Around Inside a Worksheet

2017/04/15
By
Modified: 2017/07/15

I never can't remember the Notepad equivalent of "F3" (Find Next) in Word and Excel. Here are the keyboard shortcuts, that are most useful, but almost impossible to remember. Also I constantly need Euro currency symbol (€) and Temperature Degree symbol (°), when writing my travel notes about Europe.

Read more »

Macros to “Paste as Text” for Word and Excel

2017/04/07
By
Modified: 2017/03/14
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »

Horizontal Line in Excel Header and Footer

2017/04/05
By
Modified: 2017/03/03
Horizontal-Line-in-Excel

  We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels and color it in some shade of gray.  Save the image with an appropriate meaningful name.  You will be using this file each time you need to add a line to Excel header of footer. Now, insert this image into Excel header: Note that &[Picture] code should be bellow any other code that you have in the header. Now we have…

Read more »

How to Export Yahoo! Group mebers into Excel – Painfull!

2017/04/04
By
Modified: 2017/03/03
How to Export Yahoo! Group mebers into Excel – Painfull!

This is a poor’s man manual on how to export Yahoo! group members list into Excel. Yahoo! used to have this simple feature right on their page, but it is gone now. Instead you would have to do this painful semi-archaic way of getting the data.   To make it look easy we divived the whole procedure into 3 simple steps: Step1.  Display all your Yahoo! group members in “Display Name” order Step2. Copy into Word and fix data inconsistencies Step 3. Copy into Excel and create a link sheet with a proper list         Step1.  Display all your Yahoo! group members in “Display Name” order That is easy.  You need to…

Read more »