Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

April 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Creating a TOC with Hyperlinks Programmatically

    Today's author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks. Dennis’ code uses the PageSetup.Pages().Count property, introduced in Excel 2007, to calculate the number of pages on each sheet. In addition, the entries in the TOC link to their respective sheets to improve on-screen workbook navigation...

  • Docs for Facebook

    Last week the beta of Docs for Facebook was announced at the f8 developer conference. Driven by Microsoft FUSE Labs , Docs is a great experiment on how the Office experience can come together in Facebook.  Takeshi Numoto recently posted some thoughts on this, to check it out head over to The Office Blog: http://blogs.office.com/b/office_blog/archive/2010/04/27/cloud-creates-new-opportunities-for-office-thoughts-on-docs-com-for-facebook.aspx Read More...

  • Conditional Formatting Rules Simplified

    Thanks to Amit Velingkar for writing this blog post. Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such...

  • Creating Address Labels from a Spreadsheet Programmatically

    Today's author is MVP Bill Jelen of MrExcel.com . The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels. The workbook must contain two sheets, one named "Addresses" and one named "Labels". The addresses on the Addresses sheet must be arranged as one address per row, with the Name in Column A, Address Line 1 in Column B, Address Line 2 in Column C, and the City...

  • Add a Table of Contents to your Workbook Programmatically

    Today's author is MVP Bill Jelen of MrExcel.com . The following code example verifies that a sheet named "TOC" already exists. If it exists, the example updates the table of contents. Otherwise, the example creates a new TOC sheet at the beginning of the workbook. The name of each worksheet, along with the corresponding printed page numbers, is listed in the table of contents. To retrieve the page numbers the example opens the Print Preview dialog box. You must close the dialog box...

  • Excel 2010 Mobile Post

    Over on the Office Engineering blog they have a post describing Excel Mobile 2010: “In our previous post entitled “Mobility in Office 2010” we briefly described the office applications available on your phone that would keep you productive on the go. In this post we will deep dive into Excel Mobile 2010, which supports over 100 of the formula functions available in Microsoft Excel 2010. In addition, its support for creating and displaying all of the common chart types brings the visual experience...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.