0

Sometimes I need to save a block of cells in a worksheet in RTF format. I am using Excel 2007. I currently:

  1. open an instance of Word
  2. copy the cell bock from the worksheet
  3. paste into Word
  4. save the Word document as .rtf
  5. close Word

I do this either manually or with a macro.

Is there a better way to do this in Excel 2007 ??

As I am using a relative old version of Excel, is SaveAs .rtf or export as .rtf available as an option in a more recent version of Excel ??

2 Answers 2

1

I wouldn't expect RTF to be supported by Excel. RTF stands for "Rich Text Format" and is basically a "Word Processor" format. You're saying that you must save "spreadsheet data" (rows and columns) to RTF. The reason you can get away with such an activity is that modern "word processor" documents can contain objects, like images.

Really, Spreadsheet data belongs in a Spreadsheet format. So rows and columns can go into .xls (Excel Spreadsheet) format (or .ods format, the Open Document Spreadsheet favored by LibreOffice). For convenience, modern software allows you to include data from other formats, which is much better than the old ways of doing things (which is to read a reference, and then open up some other software to be able to see the related data). However, there's no technical advantage to complicating software by trying to directly save in a format that is intended by other software (like a Spreadsheet trying to save in a Word Processor format), nor is there a large advantage to the average user's "user experience". So, I'm not expecting such a feature to be added.

In fact, RTF is not a format that I see people talking about much. I used to really like the RTF format for its apparent compatibility advantages. (However, I believe RTF is actually a bit of a loose standard, with lots of specific details being left up for individual software to make its own interpretations. This may make it easier for a software manufacturer to have some support for an RTF format, while making it more challenging to try to have all the software agree with every nuance. The result is that an RTF document might have some details that are treated differently by different software. For instance, I've found that Wordpad may open a document with different margin settings than Microsoft Word.) With quite a bit of non-proprietary software (like LibreOffice) providing better and better support for Microsoft Word's .doc format (or even the .docx format), the compatibility advantage of RTF seems to be getting less and less significant. I think it is more likely that Microsoft might drop support for RTF (which they did with the Windows Write .wri format, in Windows XP Service Pack 2) than for Microsoft to expand that format. I believe I did read that RTF is considered to be rather unspectacular from a technical point of view, so there may not be a lot of widespread desire to see its use expanded. Therefore, I suggest not placing much hope in the idea of Microsoft increasing support for this format in newer versions of the software.

0
1

If you are okay with using third-party software, you could try using ImagePrinter Pro. After installation, go to your spreadsheet and print it to the ImagePrinter Pro virtual printer. You can then save it as an RTF document.

An alternative is is ePrint, though I haven't tried it much, so I can't recommend it.

A "Save as RTF" option is either not available or impractically well-hidden in Excel 2013 as well, so it just might not be built in to MSOffice apps. You CAN, however, save your spreadsheet as plaintext (*.txt) (tab-delimited, unicode, CSV, etc.) using the export menu.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.