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

Digital Signatures in PDF Do Not Print

-
Image
Trouble getting the digital signature in a PDF to print? The solution is actually simpler than you might think. With your document open in Adobe Acrobat Reader, click File >> Print. When the Print dialog box opens, look for the "Comments and Forms:" drop-down below the Properties button, located in the upper-right. Click the drop-down and select "Document and Markups." Now print. That's all there is to it.
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 looku
Read more

25 Years of PCs

-
Image
I stumbled across several sites celebrating the 25th anniversary of the PC. Of course IBM has something -- check out their archive page . PC World has a great article that covers many aspects of the days developing the PC at IBM. There is another site, Vintage Computers , ran by Eric Klein. Here is what Eric has to say about his collection, "My vintage computer collection is small by most standards but it contains examples of what I consider to be some of the most significant machines and items from the early days of personal computer history." Mr. Klein has done a great job in providing photos and facts on so many early computers. Another good site for old computers is OLD-COMPUTERS.COM , ran by Thierry Schembri and Olivier Boisseau. I remember my first PC, which I bought used during the summer of 1982. It was a Sanyo MBC-555 that used the 8086, so it was not completely IBM compatible. It came with two 180K floppies, which I could use to run WordStar, and a green monochrome
Read more