General Question

ETpro's avatar

In Excel, how can I add a popup definition to each column header in the header row?

Asked by ETpro (34605points) May 10th, 2012

I’m using Microsoft Office 2007 Professional, and Windows 7 Enterprise Edition, so I can save the spreadsheet as an .XLSX file; but I’d prefer to keep it an .XLS file. That’s because I need to send this file as a database template to customers who have all sorts of Operating Systems and Spreadsheet Programs. Therefore, I want to make it as universally compatible as possible.

The template is for database uploads to a Yahoo! Store. There are a long series of variables in each row of the database. I need to define each, tell new Yahoo! Store users what each is and where it ends up on the item or category page it generates, tell them what limits and data standards apply to the given variable (column header), and explain how best to write content for SEO.

However I do this, the data can’t export when you save the file as a .CSV file. Excel experts, can this be done? If not, maybe I need to make a video explaining the database template. I have a Word document file where I wrote up all this info, but most Americans are so resistant to reading that they invariably call me up and use up 2 hours of my time asking all the things that are in the Word .DOC file I already sent them.

Observing members: 0 Composing members: 0

2 Answers

Kayak8's avatar

I typically right click the cell and scroll down to select “Add Comment.” It will add a little red triangle in the upper right corner of the cell that one must click to read the comment. Much like the little green triangle that Excel puts in the upper left corner if it suspects some weird calculation result in the cell.

ETpro's avatar

@Kayak8 That’s the charm. Perfect. I’ll still get calls, but all I will have to do is tell ‘em hoe to read the comments.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther