How can I format an excel document to look like a word document report?

Question

How can I format an excel document to look like a word document report?

Answer 1

You can still type in excel, just leave out the solid lines, this way, you will still have the grid witch will guide you to have a structured report, without solid lines looking like a table.



Another option will be to make use of PowerPoint, as you will have more choices of backgrounds, formats etc. So many people think that PowerPoint is only for slide shows, even if it looks like one, once printed, it looks just like any other document.



Hope it helps!

Answer 2

How approximately commencing out with the help of removing the gridlines... equipment/thoughts - View Tab positioned gridlines around the particular information which you extremely prefer highlighted. positioned web site numbers in record/web site Setup

Answer 3

You have a couple of routes to take:



1. stick with excel. select the are you want to print and use menu option Format|Autoformat. you have several styles to choose from.



if you print from Excel, make sure you also go to View|Page Layout View so you can see where Excel sets margins (in blue). You can drag them to where you want them. Also use File|Page Setup to add header rows that stay on every page.



2. copy and paste into word or powerpoint as a table and format from there. Powerpoint can really add pizazz, but its a lot of work. In word, its helpful to go into the table, right click and change the table properties.



check the help link below.... good luck :)

Answer 4

I am not seeing so much of the problem here. I have used excel sheets for statistics reports and they are great because they keep all the information inline whereas doing it on a word doc looks all mumbo gumbo unless you know how to work the tables properly (I have also learned how to do it this way as well for school). what would be the program you are using that it kicks it out of excel? that would be useful to know. But I honestly would prefer it to be organized looking on an excel, you can add colors and such to make certain things "pop" in the report just go to your table or tool button and they can show you suggestions that you can edit as well. Hope all goes well good luck