Software

Office challenge: Can you help a user who wants all workbooks to default to R1C1 referencing?

This week, text your Excel skills by providing a permanent solution for a user's R1C1 referencing preference.

One of your Excel users prefers working with R1C1 referencing. As you know, setting the current workbook to use this referencing is simple; getting Excel to always default to this setting is a different matter. Excel retains this setting until you change it or you close Excel. The next time you launch Excel, it reverts to the default A1 style. Right now, your user has to reset this option for most new workbooks. Can you help him avoid this startup task?

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks