how to add a simple 4x4 table at the bottom of a spreadsheet?

**djkatt** · 08-29-2007, 12:16 PM

Hello,
I have a spread sheet which I use for entering my monthly petty cash expenses.
At the bottom of the spreadsheet I would like to add a simple 4x4 table for office use. This table would be 4 evenly sized columns and 4 rows. I can create this table in MS Word however I can't figure out how to import it.
Is there a way to define this table in my Excel document or is there a way to import the table from MS Word?
Thanks.
Doug

**StephenR** · 08-29-2007, 02:39 PM

Not sure why you can't simply copy and paste it but why not do the table in Excel using Data > Pivot table?

**djkatt** · 08-29-2007, 03:22 PM

hi Stephen,
I'm working on my 2nd Excel doc so I know I have a lot to learn.
I don't see how the "pivot table" can help me.
All I want is a blank 4x4 grid at the bottom of the page. No data in it
at all. I've tried to paste in the blank table that I created in MS word again, numerous times actually, and it doesn't work. I tried the pivot table a few times and that seems to be looking for data. I don't have any data. I just want the grid .
Thanks.
Doug

Stephen,
I think that part of the problem is that the definition (size) of the columns carries all the way to the bottom of the page. Excel doesn't like me trying to change the size of the columns down on line 51. Do you know if there is any way to terminate the definition (size) of the columns at say line 45 and define new columns at line 50?
Thanks.
Doug

**StephenR** · 08-29-2007, 03:32 PM

No you can't but if it's only appearance that matters, why not just add borders around a 4 x 4 grid. I don't really understand what you're trying to do. What is the point of a grid with nothing in it?

Btw, although it's not generally regarded as good practice, you can merge cells across columns.