MS Office: Spreadsheet or chart fomatting help, please!

I

:slight_smile:

I’m not sure if Excel has flow control like InDesign, Quark, or PageMaker. I don’t think you can You can’t take text boxes and have them flow into boxes.

Excel works thru cells. You can have cells auto-size (vertically) to fit the text. I believe that’s about it. You can also horizontally re-size the columns to anything you like; perhaps each column taking half the available size.

Excel is not really made for complex formating. :slight_smile:

You can use Excel. You’ll probably have copy and paste all the text on your own. Think of it as a table.

After putting stuff in Excel, formatting is easiest with cell styles. Paragraph, character, cell styles. Taking the time to use them in any any program and it makes life so much simpler.

gary is right, Excel isn’t the best software to use for this kind of layout. To get these results, you have to do it manually, or write a very very busy (complicated) macro

Maybe Microsoft Publisher can do what you need - this is Microsoft’s DTP component for Office. But I’ve never used it :idunno:

Do you have a fancy laser printer? To get the results you want, I would cut’n paste the Nickolodean output into word - even straight over with the (Rich text/HTML) formatting. Then I would set my printer setting to print 2 to a page portrait. You can control typeface sizing easily in Word, too, to make sure it fits into your small space.

If you don’t have a high-faluting laser printer, you can do the same with the help of a reducing copier (shrink A3 down to A4) - but like the Excel solution, more effort that its worth.

Wish I could be more helpful.

Thank you for your help. Thanks for reminding me about the terms “text box” and “flow”. I think Word may have text box flow control since they say you should be able to make newsletters.

Right now, I think I’ll try to paste the two column spreadsheet into word. Then ask it to print two pages per paper.

What publishing software should I buy? I can use the ability to create custom charts in worksheets and handouts that I make.

Any offer teacher’s discount. My wife is a

:slight_smile:

Hey Taiwan_Student.

I think word can only have multiple columns where each column on one page wraps to the next, and then the last column wraps to the next page.

If you really desktop publishing you’re used to, Quark and InDesign are the options.