Microsoft Excel - Tilted Forum Project Discussion Community

cierah · 03-18-2005, 04:36 PM

I hope this is in the right section (and that I am allowed to post it) but I have a question about Microsoft Excel. I've never used it before and I need to make tables for a class. I want more than one table to be on the same page so I need the grids to cease in between the different tables and I want to be able to change the size of the column from one table to the next. Am I making sense? Thanks.

vinaur · 03-18-2005, 04:51 PM

Well, first of all, this should probably be in the tilted computers.

As for your question, the easiest thing would be either to put the tables on separate sheets in excel. If only want to adjust the column width of different tables then make the tables side by side, if you want to have different row sizes put them one below the other. If you want to adjust both it you could put them diagonally.

There is also a merge cells feature which you could find useful, but it is not very convenient if you want to adjust the column sizes very accurately.

Other than that, I don't think there is another option, since you cannot have cells of different width in the same column.

cierah · 03-18-2005, 04:55 PM

I need the tables to be on the same page though. But yeah, putting them side by side may work. Do you have any advice on getting rid of only some of the grid lines? Or that is probably not possible either. Thanks in any case.

OMG! I figured it out! I'm a genious! I figured out how to make grids just in the tables!

Does anyone know how to delete a row or a column?

vinaur · 03-18-2005, 05:12 PM

Right-click on the row or column number on the side or at the top and select delete.

BTW, that thing that you figured out, is that the merge cells function (the button with little a with arrows on the side <-a-> or something like that)???

cierah · 03-18-2005, 05:18 PM

Nah, I wanted the grid lines to disappear between the different tables. So I used border to fill them in and then took out the gridlines on the whole page. There is probably an easier way to do it but whatever.
Thanks for your help though.

ShaniFaye · 03-18-2005, 05:27 PM

just a suggestion.....if your tables dont require formulas(you didnt mention if they did or not), you can do fabulous things with tables in Word and they dont have to be side by side

cierah · 03-18-2005, 05:35 PM

That is actually how I fixed that problem as well. I copied and pasted the graphs into Word and messed with the lines there. It should work out now. Thanks!

03-18-2005, 04:36 PM	#1 (permalink)
cierah Crazy Location: Canada	Microsoft Excel I hope this is in the right section (and that I am allowed to post it) but I have a question about Microsoft Excel. I've never used it before and I need to make tables for a class. I want more than one table to be on the same page so I need the grids to cease in between the different tables and I want to be able to change the size of the column from one table to the next. Am I making sense? Thanks.

03-18-2005, 04:55 PM	#3 (permalink)
cierah Crazy Location: Canada	I need the tables to be on the same page though. But yeah, putting them side by side may work. Do you have any advice on getting rid of only some of the grid lines? Or that is probably not possible either. Thanks in any case. OMG! I figured it out! I'm a genious! I figured out how to make grids just in the tables! Does anyone know how to delete a row or a column? Last edited by cierah; 03-18-2005 at 05:01 PM..

03-18-2005, 05:27 PM	#6 (permalink)
ShaniFaye Submit to me, you know you want to Location: Lilburn, Ga	just a suggestion.....if your tables dont require formulas(you didnt mention if they did or not), you can do fabulous things with tables in Word and they dont have to be side by side __________________ *I want the diabetic plan that comes with rollover carbs. I dont like the unused one expiring at midnite!!*

03-18-2005, 04:51 PM	#2 (permalink)
vinaur Insane	Well, first of all, this should probably be in the tilted computers. As for your question, the easiest thing would be either to put the tables on separate sheets in excel. If only want to adjust the column width of different tables then make the tables side by side, if you want to have different row sizes put them one below the other. If you want to adjust both it you could put them diagonally. There is also a merge cells feature which you could find useful, but it is not very convenient if you want to adjust the column sizes very accurately. Other than that, I don't think there is another option, since you cannot have cells of different width in the same column.

03-18-2005, 05:12 PM	#4 (permalink)
vinaur Insane	Right-click on the row or column number on the side or at the top and select delete. BTW, that thing that you figured out, is that the merge cells function (the button with little a with arrows on the side <-a-> or something like that)???

03-18-2005, 05:18 PM	#5 (permalink)
cierah Crazy Location: Canada	Nah, I wanted the grid lines to disappear between the different tables. So I used border to fill them in and then took out the gridlines on the whole page. There is probably an easier way to do it but whatever. Thanks for your help though.

03-18-2005, 05:35 PM	#7 (permalink)
cierah Crazy Location: Canada	That is actually how I fixed that problem as well. I copied and pasted the graphs into Word and messed with the lines there. It should work out now. Thanks!