I'd like to have text in a cell that is just informational. I would
not want it to print, or more importantly, if the file were saved as a
..csv file, I would not want it included in that delimited file.

I believe inserting a comment would work except that I would not want
to accept that the user would be intuitive enough to look at the
comments.

Any suggestions are appreciated.

Barney,

Text in a cell will print, unless hidden before the print is done. It will also be included
in a csv file.

You could put the text in a text box, which could be formatted to not print. You'd use the
Drawing Toolbar to make the text box. To format it to not print, right-click the box,
Format AutoShape, Properties tab, uncheck "Print object." YOu could remove the border from
the box: Right click it, Format AutoShape, Colors and Lines, and set the line color to
"none." You could also set the Fill Color to none similarly. Now you have only text,
floating around the worksheet.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
<Barney Fyfe> wrote in message news:(E-Mail Removed)...
> I'd like to have text in a cell that is just informational. I would
> not want it to print, or more importantly, if the file were saved as a
> .csv file, I would not want it included in that delimited file.
>
> I believe inserting a comment would work except that I would not want
> to accept that the user would be intuitive enough to look at the
> comments.
>
> Any suggestions are appreciated.
>

On Sat, 2 Jun 2007 17:07:23 -0400, "Earl Kiosterud"
<(E-Mail Removed)> wrote:

>Barney,
>
>Text in a cell will print, unless hidden before the print is done. It will also be included
>in a csv file.
>
>You could put the text in a text box, which could be formatted to not print. You'd use the
>Drawing Toolbar to make the text box. To format it to not print, right-click the box,
>Format AutoShape, Properties tab, uncheck "Print object." YOu could remove the border from
>the box: Right click it, Format AutoShape, Colors and Lines, and set the line color to
>"none." You could also set the Fill Color to none similarly. Now you have only text,
>floating around the worksheet.

Earl thanks very much for the options. Would it be possible to change
the column letters to text other than A, B. C etc.

Barney

One other method...............

In a cell enter a formula like such...............

=A2*A1+N("my wage+bonus-4 weekly loan repayments")

Anytning after the "n" will not show in the cell, although it will show in the
formula bar when you select that cell.

When saved as a *.csv file just the value comes across, not the formula with the
info text.


Gord Dibben MS Excel MVP


On Sat, 02 Jun 2007 16:42:11 -0400, Barney Fyfe wrote:

>I'd like to have text in a cell that is just informational. I would
>not want it to print, or more importantly, if the file were saved as a
>.csv file, I would not want it included in that delimited file.
>
>I believe inserting a comment would work except that I would not want
>to accept that the user would be intuitive enough to look at the
>comments.
>
>Any suggestions are appreciated.

Not possible to change these.

Most common workaround..........................


In row 1 have your titles.

Go to Tools>Options>View and turn off "row and column headers"

Select A2 and Window>Freeze Panes to keep row 1 in view as you scroll down the
sheet.


Gord Dibben MS Excel MVP

On Sat, 02 Jun 2007 17:25:50 -0400, Barney Fyfe wrote:

>Earl thanks very much for the options. Would it be possible to change
>the column letters to text other than A, B. C etc.

On Sat, 02 Jun 2007 14:39:04 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>Barney
>
>One other method...............
>
>In a cell enter a formula like such...............
>
>=A2*A1+N("my wage+bonus-4 weekly loan repayments")
>
>Anytning after the "n" will not show in the cell, although it will show in the
>formula bar when you select that cell.
>
>When saved as a *.csv file just the value comes across, not the formula with the
>info text.
>
>
>Gord Dibben MS Excel MVP
>

Thanks Gord for your insight.