Wish more people knew about itin reference to: http://blogs.office.com/b/microsoft-word/archive/2010/08/09/show-me-the-style-area-pane-in-word-2010.aspx (view on Google Sidewiki)
Saturday, January 15, 2011
It’s Excel’s 25th Anniversary Year. As someone who is lives and breathes Excel, it’s great to see Excel greats from Microsoft speak. People like Charles Simonyi who gave us the Hungarian Naming Convention (and influenced not only Excel VBA but many other products) had a hand in Excel. And I remember this colleague called Mei Ling – she was into Multiplan as well – when I said why? It’s R1C1 – that’s dyslexically confusing compared to Lotus 1-2-3, Supercalc, Visicalc and now Excel’s A1 (grin). Little did I know when you program Excel in VBA, it’s often easier to think in R1C1 for cell addressing. Two videos from the Office team:
Friday, January 14, 2011
2010 is Excel's 25th anniversary and here's news from the start up daysin reference to: http://www.thedailybeast.com/blogs-and-stories/2010-12-27/microsoft-excel-the-programs-designer-reveals-the-secrets-behind-the-software-that-changed-the-world-25-years-ago/ (view on Google Sidewiki)
Saturday, January 8, 2011
I remembered demonstrating Garbriola aesthetics in a class and promptly lost my reference. Here is the how to.in reference to: http://www.howtogeek.com/howto/13484/use-advanced-font-ligatures-in-office-2010/ (view on Google Sidewiki)
I’ve been teaching more than doing recently, so this start of 2011, I am by chance, having the time to work with some documents with Word 2010. The management of Styles has been enhanced and modified to some extent. I found my favourite keystrokes to strip paragraph formatting Ctrl+Q and to strip direct character formatting, Ctrl+Space didn’t do it for me. Puzzled, I looked around at how things had subtly changed.
Really, if you are writing, you don’t want to be bothered with formatting. And yet when you cut and paste, the alien paragraphs indeed look alien. First thing is to check out the default Paste attributes:
The defaults are to keep source formatting – ask yourself whether you want to change that to Merge Formatting or to Use Destination Formatting. Sure avoids all that frustrating alien looking chunks and the obsessive compulsive behaviour in cleaning up after every Paste.
If you really need to strip Paragraph and direct Text formatting, you need to get the Style Inspector. One way to get it is to click on the Styles Pane Dialog Launcher in the Ribbon – Home Tab. Then click on the icon exposing the Style Inspector. If you are going to use it frequently, consider dragging it to the left or right so that it becomes a static vertical pane (non floating).
Then all you have to do is to place your cursor appropriately in the document and hit the Reset or Clear buttons. There are four of them in All.
Notice the Clear All button. By the way, in the Styles Pane there is a Clear All pseudo style. I did try that, it didn’t seem to deliver the goods.
Thursday, January 6, 2011
Wednesday, January 5, 2011
Here we are, Tables in Excel, in 2010, version 2 and it's got even better. But reading responses from users, people are seldom satisfied with anything, all together.....in reference to: Table Improvements in Excel 2010 - Microsoft Excel 2010 - Site Home - MSDN Blogs (view on Google Sidewiki)