Always have expanded menus in Office apps

-
I just got a new laptop and was reminded of a common annoyance in MS Office products. The menus never fully display immediately -- you either have to click the arrow at the bottom of the menu or wait a few seconds. There is actually a fairly easy way to keep them expanded all the time.
  1. Right-click any toolbar
  2. Select Customize
  3. Check "Always show full menus"
That's it.

Comments

Post a Comment

Popular posts from this blog

Active window loses focus

-
Image
Do you ever have the experience where your typing away, say in Word, and another program pops-up and takes focus, forcing you to click back on the program you were working in? This happens the most to me when a new IM conversation begins in Trillian. It's not a problem once the conversation is going, just for new ones.

Where there are a couple of work-arounds to prevent this from happening. Perhaps the easiest is to get Microsoft's Tweak UI to disable it. Look for Focus in the General section of Tweak UI.

You can also do this through a registry setting:
Start the Registry Editor: Go to Start | Run and enter regedit [Enter]Find HKEY_CURRENT_USER | Control Panel | DesktopGo to the Edit menu and select New > DWORD valueName the DWORD value "ForegroundLockTimeout"Assign a value of 30d40Close the Registry Editor

While your in the Registry Editor, you can also set how many times the Window seeking your attention flashes in your taskbar. This is another setting within HKEY_C…
Read more

Referencing the value of a cell, not its formula

-
Image
In Excel, I will use formulas quite frequently for my analysis. At times I want to reference the resulting value of the formula for comparison or to feed another formula. Unfortunately, if you are doing a comparison, Excel will try to compare the formula instead of the formulas results. Well, turns out there is an easy way to correct this.

If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function.

Here is the syntax for each:
VALUE(text)TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General.
Here is an example of each:
=VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my lookup table.=TEXT(IF…
Read more

Firefox Keyboard Shortcuts

-
Image
I had so much fun assembling the Windows XP Keyboard Shortcuts, and they proved to be so popular, that I put together another one just for Firefox. In addition to the shortcuts, I included additional reference information for configuring Firefox.



Download the Firefox Keyboard Shortcuts tri-fold. Just as with the latest version of the Windows XP Keyboard Shortcuts, do not forget to print double-sided on a single sheet of paper. Also be sure to validate the driver is set to print in landscape.
Read more