Excel Table Autosize?

Question

Hi

I have an excel worksheet that basically adds up the amount of hours people have worked and calculates the total at the bottom (along with tax etc).

My question is: Is there a way so that when i copy the details from the time sheets to the expenses form, the table automatically resizes itself making all the totals at the bottom, as opposed to having too much spare space under them, or the pasting over-writing the total cell formulas.

Thanks

Answer 1

In Excel 2003 there is a feature called LIST

Data > List > Create List

or Control + L

Select how wide you want it and if your table has headers.

Now you'll have 1 or 2 rows.

when you click within the Blue outline you'll see a new row created with an Asterix (*) on it in the first column.

whatever you type in here will be added to a new row as well as any formula's being carried down from the other rows.

If you need any more information please Email me and i'll help out as much as i can.

Thanks