Cell View Add-In
This page describes the CellView.xla Add-In For Excel.
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.
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.
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 are free to distribute the code as you wish and you are free to examine and modify the VBA code. The password for the
VBProject is 'a', a lower case 'a' character.
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.
This page last updated: 6-October-2007
