Can I Have Text In A Cell For Viewing Only?

  • Thread starter Thread starter Barney Fyfe
  • Start date Start date
B

Barney Fyfe

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,

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.
Click to expand...

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
 
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
 
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
Click to expand...

Thanks Gord for your insight.
 
Back
Top