Aggregated Posts (sorted by date)
Indenting Cell Contents
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-08):
You can align information in a cell in just about any manner you can imagine. This tip explains how you can indent cell contents from either the left or the right side of the cell. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).)Read this ExcelTip:Indenting Cell ContentsMicrosoft Excel Tips - Learn Excel Faster!
Understanding Views
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-08):
Word allows you to view your document in any of four different methods. This tip describes the four methods completely so you can decide which viewing mode is best for you. ((This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.).)Read this WordTip:Understanding ViewsMicrosoft Word Tips - Learn Word Faster!
SharePoint Governance
Abstract from Scott Jamison (Indexed 2008-07-07):
I hope everyone in the USA had a fantastic 4th of July! I watched the fireworks in Boston...what an amazing show. Which leads me to today's topic...governance. The number one topic that my customers ask me about is SharePoint governance. What does governance mean? It means determining what users can, should, and should not do, as well as who is responsible for permissions and what policies are in place. In short, SharePoint governance uses roles and responsibilities, policies, ...(truncated)...
Setting the Calculation Default
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-07):
When you open a workbook, you normally expect Excel to automatically calculate the formulas it may contain. If you aren't seeing automatic calculation by default, then the information in this tip will be helpful. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).)Read this ExcelTip:Setting the Calculation DefaultMicrosoft Excel Tips - Learn Excel Faster!
Where is AutoFormat?
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-07):
AutoFormat, a handy feature in many versions of Word, seems to be missing from Word 2007. If you are using the latest version of Word and you want this feature back, here's how to get it. ((This tip works with Microsoft Word 2007.).)Read this WordTip:Where is AutoFormat?Microsoft Word Tips - Learn Word Faster!
Some new gadgets I have bought
Abstract from Sven Cipido (Indexed 2008-07-06):
Lately I have bought me some new gadgets. 24" monitor : Samsung Syncmaster 245BPlus [Image] [Image] A SLR camera : Nikon D80 [Image] These are the specs of this camera : Effective pixels ...(truncated)...
Classic Colors for Excel 2
Abstract from Andrew's Excel Tips (Indexed 2008-07-06):
I received some requests for additional features in relation to my Classic Excel Colors add-in.So, here is what has been added.You can now launch the form from the top menu when a chart is selected.An option to color borders16 extra colorsA ...
Preventing Printing
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-06):
Want to prevent your worksheet from being printed? You may be out of luck, as a determined person may be able to find a way to do what you don't want. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).)Read this ExcelTip:Preventing PrintingMicrosoft Excel Tips - Learn Excel Faster!
Odd Sorting
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-06):
Sorting information is a common task in Word. Sometimes, however, it is difficult to determine exactly how to sort certain types of information. This tip shows how to use a macro to sort a series of names that may have suffixes associated with them. ((This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.).)Read this WordTip:Odd SortingMicrosoft Word Tips - Learn Word Faster!
Office Community Clips
Abstract from Dick Kusleika (Indexed 2008-07-05):
Have you seen the new Microsoft Office Community Clips?People upload videos that demonstrate how to perform a task. I guess people like this because it's almost like watching TV. Never mind that you actually have to click and watch in order to determine if it's useful. And, a 3-minute video contains roughly the same content [...]
Specifying a Data Validation Error Message
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-05):
Data validation is a great tool that helps you control exactly what can be entered in a cell. Part of data validation allows you to specify an error message that can be displayed if the user enters the wrong type of data. This tip explains how to set up that error message. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).)Read this ExcelTip:Specifying a Data Validation Error MessageMicrosoft Excel Tips - Learn Excel Faster!
Left and Right Aligned on One Line in a Label
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-05):
If you need to put information on a label that has both left- and right-aligned information on the same line, it can be frustrating to get the formatting just right. Here's the steps you need to follow to get just what you need. ((This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.).)Read this WordTip:Left and Right Aligned on One Line in a LabelMicrosoft Word Tips - Learn Word Faster!
Office Community Clips
Abstract from Daily Dose of Excel (Indexed 2008-07-05):
Have you seen the new Microsoft Office Community Clips?People upload videos that demonstrate how to perform a task. I guess people like this because it's almost like watching TV. Never mind that you actually have to click and watch in order to determine if it's useful. And, a 3-minute video contains roughly the same content [...]
Microsoft StyleCop, Totalitarian Rules
Abstract from Bil Simser (Indexed 2008-07-04):
I got turned onto a fairly new tool by a friend and was interested in checking it out. It's called Microsoft StyleCop and done in the style of FxCop but rather than analyzing assemblies it looks at code for formatting and style rules. The original use was within Microsoft for keeping code across all teams consistent. Imagine having to deal with hundreds of developers moving around an organization like Microsoft where there are dozens of major teams (Windows, Office, Visual Studio, Games, etc.) a...(truncated)...
Developing Reciprocal Conversion Formulas
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-04):
Would you like to develop a worksheet that has two cells that will convert whatever is entered in either of the cells? For instance, you might put a measurement in inches in one cell and have it converted into millimeters in the other, and vice versa. This tip explains how you can (and why you must) do this using macros. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).)Read this ExcelTip:Developing Reciprocal Conversion FormulasMicrosoft Excel Tips ...(truncated)...
Defining Styles
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-04):
Styles are a powerful component of Word. You use them to determine the way that your text should appear. This tip explains how you can define styles or modify existing styles. ((This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.).)Read this WordTip:Defining StylesMicrosoft Word Tips - Learn Word Faster!
Office Live Small Business has >1M subscribers
Abstract from OfficeRocker (Indexed 2008-07-03):
[Image] Following on from my Office Live demo at the NCVO event, Tim Kimber sent me this today which is worth sharing I thought: Microsoft Office Live Small Business has reached a pivotal milestone: In less than two years since its November 2006 commercial debut, the online service that helps entrepreneurs take, promote and manage their businesses online has surpassed more than 1 million subscribers. This 1 million worldwide subscribers milestone demonstrates that increasing numbers o...(truncated)...
Catching Save or SaveAs in Word 2007 (Harry Miller)
Abstract from Paul Cornell (Indexed 2008-07-03):
You can override Ribbon commands and run your own code for Save or Save As, or you can simply cancel attempts to save a document in the DocumentBeforeSave event handler.Code and resources:Forum post: Microsoft Word 2007 Disable Save AsTemporarily Repurpose Commands on the Office Fluent RibbonDocumentBeforeSave eventVideo duration: 51 seconds[Image]";" galleryimg="no" mce_src="http://blogs.msdn.com/blogfiles/vsto/WindowsLiveWri...(truncated)...
Using SUM In a Macro
Abstract from Allen Wyatt's Excel Tips (Indexed 2008-07-03):
If you need to use the SUM worksheet function from within a macro, you can easily do it by using the techniques discussed in this tip. You can even use the function with a variable number of cells in a column. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).)Read this ExcelTip:Using SUM In a MacroMicrosoft Excel Tips - Learn Excel Faster!
Deleting All Headers and Footers
Abstract from Allen Wyatt's Word Tips (Indexed 2008-07-03):
Headers and footers add a finishing touch to documents, but sometimes they can be bothersome. You may need to remove them all from a document, and the easiest way is with a macro that does the work for you. ((This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.).)Read this WordTip:Deleting All Headers and FootersMicrosoft Word Tips - Learn Word Faster!
Reporter Network