 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Can I Have Text In A Cell For Viewing Only?
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.  SignatureEarl 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... ----------------------------------------------------------------------- > 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 [quoted text clipped - 5 lines] > > Any suggestions are appreciated. >Barney, > [quoted text clipped - 7 lines] >"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. 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 >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 >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 [quoted text clipped - 5 lines] > >Any suggestions are appreciated. >Barney > [quoted text clipped - 11 lines] > >Gord Dibben MS Excel MVP Thanks Gord for your insight.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.