ThreeWave Cell View Add-In

This page describes the CellView.xla Add-In For Excel.
ShortFadeBar

Introduction

Quite often when doing copy and paste operations from a non-Excel source such as a web page, you will end up with special control characters in the worksheet cell. These characters are often not visible in a cell but can affect cell formatting and arithmetic and lookup formulas. The CellView add-in shows you exactly what is in the cell.

This add-in will work in 64-bit Excel on 64-bit Office.

See Installing An XLA Add-In for details about installing and loading an XLA Add-In. Note that Excel 2007 does not allow the customizations that Excel97-2003 allowed. Therefore, the CellView command items will appear on the Add-Ins tab of the Excel 2007 Ribbon, rather than on the View tab.

When you install and load the CellView.xla add-in file, it will automatically place a new item on the View menu with a caption of View Cell Contents. When you click that menu item, CellView will display the primary dialog, shown below.

CellViewDialog

In this dialog, the Pos line indicates the position of each character. The Char line shows the actual character in the cell. The Dec or Hex line indictes each character's code, in decimal or hexadecimal. If a character is not a regular, displayable character (e.g., it is a character 9, tab), a ^ character is displayed in the Special line. You can choose at which character to start the view using the Start At Char box. With this box in focus, you can use the up arrow and down arrow to scroll through the cell's contents.

You can download the zip file that contains the XLA Add-In file. Once you have extracted the file to some folder, open Excel, go to the Tools menu, choose Add-Ins and click Browse. In that dialog, navigate to the folder in which you saved the CellView.xla file and click Open.

ShareWare

CellView is shareware, which means you can use it for free, but are encouraged to pay for it if you find it useful.. The downloadable version of CellView on this page is the full version. There are no limitations or restrictions and only one nag message the first time you load CellView.. You can send the $25 fee via PayPal to chip@cpearson.com.

This page last updated: 6-October-2007