Excel Template???????????????????????????????? Robert Perry 30.09.2006 18:12:02 Hello, I am new to Excel. I just downloaded an Inventory Template and have a question. I was inputing data in the fields, they are Gray and then white. Everything was working fine until I came to a Gray line. After this line it appears that there are no longer defind cells. There is no gray and white rows, they are all whate now. It seems like this template is only set up to input so much data. How do I extend the template to input more data? Sorry if this is confusing. Any help would be great. Semper Fi, Robert Perry

Re: Excel Template???????????????????????????????? Gord Dibben <gorddibbATshawDOTca> 30.09.2006 19:19:40 Which template is it? Post the URL. I'm sure it is just a matter of extending the formats by using the Format Paintbrush, but if I have the template I will know for sure. Gord Dibben MS Excel MVP On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert Perry[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Hello, > >I am new to Excel. I just downloaded an Inventory Template and have a >question. I was inputing data in the fields, they are Gray and then white. >Everything was working fine until I came to a Gray line. After this line it >appears that there are no longer defind cells. There is no gray and white >rows, they are all whate now. It seems like this template is only set up to >input so much data. How do I extend the template to input more data? > >Sorry if this is confusing. Any help would be great. > >Semper Fi, > >Robert Perry

Re: Excel Template???????????????????????????????? Robert Perry 30.09.2006 19:33:02 Thank you so much for the quick reply. It's driving me nuts. Here is the URL: http://office.microsoft.com/en-us/templates/TC060827171033.aspx?CategoryID=CT011377101033 The gray line is at row 40. Another thing I have noticed is that when inputing data and going to the next row, it doesn't always change the background color of the row so for instance the rows will be Gray, Gray, white, Gray, White, white, white, etc. "Gord Dibben" wrote: [Quoted Text] > Which template is it? > > Post the URL. > > I'm sure it is just a matter of extending the formats by using the Format > Paintbrush, but if I have the template I will know for sure. > > > Gord Dibben MS Excel MVP > > On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert > Perry[ at ]discussions.microsoft.com> wrote: > > >Hello, > > > >I am new to Excel. I just downloaded an Inventory Template and have a > >question. I was inputing data in the fields, they are Gray and then white. > >Everything was working fine until I came to a Gray line. After this line it > >appears that there are no longer defind cells. There is no gray and white > >rows, they are all whate now. It seems like this template is only set up to > >input so much data. How do I extend the template to input more data? > > > >Sorry if this is confusing. Any help would be great. > > > >Semper Fi, > > > >Robert Perry > >

Re: Excel Template???????????????????????????????? FloMM2 30.09.2006 20:03:01 Robert, If you select the last two lines on the form template (one shaded & one white), you can copy and paste. However it will only allow you to get to row 43, before it automatically inserts a pagebreak. I would suggest you use the template and Save As Your file name here part1. Then continue on the next template and Save As Your file name here part2...... Hope this helps. "Robert Perry" wrote: [Quoted Text] > Thank you so much for the quick reply. It's driving me nuts. Here is the URL: > http://office.microsoft.com/en-us/templates/TC060827171033.aspx?CategoryID=CT011377101033 The gray line is at row 40. > > Another thing I have noticed is that when inputing data and going to the > next row, it doesn't always change the background color of the row so for > instance the rows will be Gray, Gray, white, Gray, White, white, white, etc. > > "Gord Dibben" wrote: > > > Which template is it? > > > > Post the URL. > > > > I'm sure it is just a matter of extending the formats by using the Format > > Paintbrush, but if I have the template I will know for sure. > > > > > > Gord Dibben MS Excel MVP > > > > On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert > > Perry[ at ]discussions.microsoft.com> wrote: > > > > >Hello, > > > > > >I am new to Excel. I just downloaded an Inventory Template and have a > > >question. I was inputing data in the fields, they are Gray and then white. > > >Everything was working fine until I came to a Gray line. After this line it > > >appears that there are no longer defind cells. There is no gray and white > > >rows, they are all whate now. It seems like this template is only set up to > > >input so much data. How do I extend the template to input more data? > > > > > >Sorry if this is confusing. Any help would be great. > > > > > >Semper Fi, > > > > > >Robert Perry > > > >

Re: Excel Template???????????????????????????????? Robert Perry 30.09.2006 20:16:01 Thank you FloMM2. It seems that there should be an easier way to do this. Are these templates just for demo purposes? All I want to do is inventory a poster collection I have. I guess I will have to make my own template. Thank you again for your reply. It amazes me how nice people can be to take there own time to help others. Semper Fi, Robert Perry "FloMM2" wrote: [Quoted Text] > Robert, > If you select the last two lines on the form template (one shaded & one > white), you can copy and paste. However it will only allow you to get to row > 43, before it automatically inserts a pagebreak. > I would suggest you use the template and Save As Your file name here part1. > Then continue on the next template and Save As Your file name here part2...... > Hope this helps. > > "Robert Perry" wrote: > > > Thank you so much for the quick reply. It's driving me nuts. Here is the URL: > > http://office.microsoft.com/en-us/templates/TC060827171033.aspx?CategoryID=CT011377101033 The gray line is at row 40. > > > > Another thing I have noticed is that when inputing data and going to the > > next row, it doesn't always change the background color of the row so for > > instance the rows will be Gray, Gray, white, Gray, White, white, white, etc. > > > > "Gord Dibben" wrote: > > > > > Which template is it? > > > > > > Post the URL. > > > > > > I'm sure it is just a matter of extending the formats by using the Format > > > Paintbrush, but if I have the template I will know for sure. > > > > > > > > > Gord Dibben MS Excel MVP > > > > > > On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert > > > Perry[ at ]discussions.microsoft.com> wrote: > > > > > > >Hello, > > > > > > > >I am new to Excel. I just downloaded an Inventory Template and have a > > > >question. I was inputing data in the fields, they are Gray and then white. > > > >Everything was working fine until I came to a Gray line. After this line it > > > >appears that there are no longer defind cells. There is no gray and white > > > >rows, they are all whate now. It seems like this template is only set up to > > > >input so much data. How do I extend the template to input more data? > > > > > > > >Sorry if this is confusing. Any help would be great. > > > > > > > >Semper Fi, > > > > > > > >Robert Perry > > > > > >

Re: Excel Template???????????????????????????????? FloMM2 30.09.2006 20:34:01 Robert, After fooling around with the templatye, there is an easier fix. 1)Save the template. 2) Copy the last two (2) lines down to line 79. 3) Under Page Setup set to print "Portrait" not "Landscape". 4)View "Page Break Preview". Select "OK" 5) Drag and drop the blue dashed line to the right. This should adjust your page to "Page 1". I was able to extend the form to 79 lines. "Robert Perry" wrote: [Quoted Text] > Thank you FloMM2. It seems that there should be an easier way to do this. Are > these templates just for demo purposes? > > All I want to do is inventory a poster collection I have. I guess I will > have to make my own template. > > Thank you again for your reply. It amazes me how nice people can be to take > there own time to help others. > > Semper Fi, > > Robert Perry > > > > "FloMM2" wrote: > > > Robert, > > If you select the last two lines on the form template (one shaded & one > > white), you can copy and paste. However it will only allow you to get to row > > 43, before it automatically inserts a pagebreak. > > I would suggest you use the template and Save As Your file name here part1. > > Then continue on the next template and Save As Your file name here part2...... > > Hope this helps. > > > > "Robert Perry" wrote: > > > > > Thank you so much for the quick reply. It's driving me nuts. Here is the URL: > > > http://office.microsoft.com/en-us/templates/TC060827171033.aspx?CategoryID=CT011377101033 The gray line is at row 40. > > > > > > Another thing I have noticed is that when inputing data and going to the > > > next row, it doesn't always change the background color of the row so for > > > instance the rows will be Gray, Gray, white, Gray, White, white, white, etc. > > > > > > "Gord Dibben" wrote: > > > > > > > Which template is it? > > > > > > > > Post the URL. > > > > > > > > I'm sure it is just a matter of extending the formats by using the Format > > > > Paintbrush, but if I have the template I will know for sure. > > > > > > > > > > > > Gord Dibben MS Excel MVP > > > > > > > > On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert > > > > Perry[ at ]discussions.microsoft.com> wrote: > > > > > > > > >Hello, > > > > > > > > > >I am new to Excel. I just downloaded an Inventory Template and have a > > > > >question. I was inputing data in the fields, they are Gray and then white. > > > > >Everything was working fine until I came to a Gray line. After this line it > > > > >appears that there are no longer defind cells. There is no gray and white > > > > >rows, they are all whate now. It seems like this template is only set up to > > > > >input so much data. How do I extend the template to input more data? > > > > > > > > > >Sorry if this is confusing. Any help would be great. > > > > > > > > > >Semper Fi, > > > > > > > > > >Robert Perry > > > > > > > >