The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,854 other subscribers

Archive for the ‘Office’ Category

Microsoft Excel 2007/2010 – Protecting Workbooks and Worksheets

Posted by jpluimers on 2012/05/04

One of the things about the Office 2007 and 2010 Ribbon is that it makes the things that you have remembered for 10+ years go into hard to find places.

My point is that according to the ribbon documenation:

A ribbon can replace both the traditional menu bar and toolbars.

Microsoft has decided to read the “a ribbon can replace” as “the ribbon replaces”. Thereby also introducing a whole new naming for the UI elements used in ribbons (see at the bottom).

Tab "Review"; Group "Changes"; Commands "Protect Sheet" / "Protect Workbook"

Tab “Review”; Group “Changes”; Commands “Protect Sheet” / “Protect Workbook”

Protecting a worksheet and workbook have been in the menu “Tools”, submenu “Protection” forever. But alas: No more “Tools” menu, and accompanying keyboard shortcut productivity (and I needed “unprotect workbook” because you cannot copy workbooks inside a protected workbook).

As “password protect worksheet” shows, it is now under:

  1. Tab: Review
  2. Group: Changes
  3. Commands: Protect Sheet / Unprotect Sheet / Protect Workbook / Unprotect Workbook

–jeroen

via: Microsoft Excel 2007 – Protecting Workbooks.

Naming of ribbon UI elements

Naming of ribbon UI elements

Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »

Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro

Posted by jpluimers on 2012/03/16

Unlike most tools where you use Shift-Enter to add a line break character (ASCII 10: line feed), Excel is different:

Sometimes it’s necessary to have more than one line inside a worksheet cell, which is easily done with a line break.

Add a new line by holding down the Alt key while you press enter. It’s the keyboard shortcut Alt+Enter. In Excel 2008 and 2011 for Mac use Cmd+Option+Enter.

–jeroen

via: Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro.

Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Power User | Leave a Comment »

Ref: Microsoft Word Help FAQ. How to create heading numbering and outline numbering in Microsoft Word

Posted by jpluimers on 2010/03/16

I’m always fighting with numbering and formatting headings in Word. Legal documents, manuals, etc, all benefit when the headings are numbered and formatted right.

In Word, I love styles, so the best thing to get this right is to modify the styles of your headings.

Shauna Kelley wrote a great reference titled Microsoft Word Help FAQ. How to create heading numbering and outline numbering in Microsoft Word on this topic.

No need to add anything to that :-)

–jeroen

Posted in Office, Power User, Word | Leave a Comment »