The official: Excel Help Thread

[ranchlandsselling]

I browsed a bit and found a few recent threads with excel help questions. Someone concluded one with a suggestion for an official excel help thread. So I thought I'd get it started with mine.

It's more of a - can I use excel for this type of thing. At which point I hope to be able to figure it out myself. Unless people make great suggestions and my task gets easier

Mods - move to Tech Forum if thread warrants.

Basically I have a word document, company letterhead, that I print off quite often and within it has a bunch of text, info, etc. Accompanying that is a few tables with numbers that get updated for every print off. Ideally I think it would be much easier to have an excel template so I only need to do a few entries to populate my tables and then printout? I have office 2010 or whatever reasonable recent version.

Pretty easy?

[Kavvy]

Originally Posted by ranchlandsselling

Basically I have a word document, company letterhead, that I print off quite often and within it has a bunch of text, info, etc. Accompanying that is a few tables with numbers that get updated for every print off. Ideally I think it would be much easier to have an excel template so I only need to do a few entries to populate my tables and then printout? I have office 2010 or whatever reasonable recent version.

Pretty easy?

I am confused, are you asking if you can insert and format a header and footer in excel like you can with word? You can, it just isn't as simple as a process.

Go to the 'Page Layout' Ribbon and click the arrow on the bottom right corner of the page setup section and play with it there... or..

The easier path is to go to the 'view' ribbon and click "Page Layout", then click the header and play with the functions on the Header and Footer tools ribbon..

Click 'Page Break Preview' when your done to ensure it all fits on the pages you want, or just set the width to # of pages (i.e. 1) in the page layout ribbon.


Anyone looking for help on excel, I would recommend the site below, you may get answer quicker then here.
http://www.mrexcel.com/forum/index.php

[ranchlandsselling]

Thanks for the reply / link.

I have a word document that has a 7 x 10 table within it. I fill in the tables manually with numbers I calculate elsewhere. Every Time I change the scenario I manually type the new numbers into my table.

I could build something in excel and copy and paste the table every time. That would save a lot of time. However, if I could embed the excel sheet into my word doc or vise versa that would seem to be even more efficient... I think?

.

[calumniate]

Maybe copy your table from excel and 'paste special' - 'as link' into word? Then you can just right click your table and 'update'.