The sample MSOffice2K_X tagset can be used to freeze column and row headings in an Excel worksheet. The row headings can be frozen using the FROZEN_ROWHEADERS= option. This option enables you to specify the column to freeze, and includes all of the columns to the left of the value specified.

The column headings in the worksheet can be frozen using the FROZEN_HEADERS= option. The argument specified for this option is the row number to freeze, and includes all of the rows that precede the argument specified.

The example code below demonstrates these options as well as using the URL access method to download the sample tagset from the ODS Markup download page. The tagset can also be downloaded from the following location:

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information