More MRU (Most Recently Used) magic

Office Watch has a post on More MRU magic.

The Most Recently Used list in Microsoft Office can be handy, but it can also have a lot of stuff you don’t need or want again.  This post tells you where to find the lists and remove the unwanted items.

Create Drop-Down Lists In Excel

Lockergnome has a post on how to Create Drop-Down Lists In Excel.

Keep Office 2007 Documents Readily Available

Mysticgeek has a post on how toKeep Your Office 2007 Documents Readily Available the Easy Way .

“How many times have you been looking or a Word of Excel document and what should be an quick retrieval takes several minutes? Sure, you can always search, but for frequently used documents that’s not the best solution.

Today we will look at an easy way to keep your most important documents readily available within Office 2007. This trick works with Word, Excel and PowerPoint just the same… there’s a push pin icon next to each item in the recent documents list.”

10 obscure Excel tricks that can expedite common chores

TechRepublic has 10 obscure Excel tricks that can expedite common chores.

Transpose function in Excel

Microsoft Excel has a transpose function that allows you to swap data between columns or rows.

Microsoft Office blog in TechRepublic has instructions.

Microsoft Office student discount

While this site normally doesn’t promote commercial software (companies have budgets of their own for that!), the Microsoft Office Suite is the campus standard software and many students would like to get it at a discount.

Try the student discount for the ultimate package here.

DocSyncer for Google docs

Somebody had to come up with a way to synchronize the documents you edit in Microsoft Office so they are available in Google Docs.

Try the free service at DocSyncer to migrate files to Google.

Excel 2007 shortcuts

PC Magazine (June 2008) has a list of “11 Killer Excel 2007 Shortcuts”:

Ctrl-Shift-&	Apply the outline border to the selected cells
Ctrl-Shift-#	Apply the Date format with day, month and year
Ctrl-Shift-@	Apply the Time format: hour, minute, AM or PM
Ctrl-Shift-:	(colon) Enter current time
Ctrl-;	(semi-colon) Enter date
Ctrl-O	Hide selected columns
Ctrl-’	(single quote) alternate: cell values/formulas
Ctrl-H	Find and replace
Ctrl-F2	Print Preview
Ctrl-F6	next workbook
Alt-F8	macro dialog box

Here’s looking at you, Office

Microsoft Office viewers are available if you don’t have Microsoft Office programs. Click here for the download page for viewers for all MS Office products, Word, Powerpoint, Excel, Outlook, Access, and Visio.

Remember: you can see the files with these viewers, but you cannot edit them in any way.

You can also use OpenOffice (freeware compatible with MS Office Suite before 2007) to view Word, Powerpoint, Excel, and Access files (before 2007) as well as edit and save them to MS Office formats such as 97-2003 formats.

Remember: you must not use 2007 formats (ending in “x” such as “.docx“) if you want to use other programs such as OpenOffice, WordPerfect, etc. to view or edit them reliably.

Microsoft Excel utilities

Sources of helpful utilities for Excel versions 97 through 2003 are http://www.excel-extools.com and http://www.asap-utilities.com/. Freeware. Recommended by Gizmo’s Tech Support Alert.

Microsoft Excel 2007 – dealing with the bugs

Windows Secrets has a section on the bugs in Excel 2007 and how to deal with them.

Microsoft Excel 2003 cheat sheets for 2007

USC Marshall has some excellent cheat sheets for Excel 2007 giving the equivalents for Excel 2003.