|
Excel Template????????????????????????????????
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 |
Excel Template????????????????????????????????
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 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 |
Excel Template????????????????????????????????
Thank you so much for the quick reply. It's driving me nuts. Here is the URL:
http://office.microsoft.com/en-us/te...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 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 |
Excel Template????????????????????????????????
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/te...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 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 |
Excel Template????????????????????????????????
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/te...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 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 |
Excel Template????????????????????????????????
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: 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/te...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 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 |
Excel Template????????????????????????????????
Flomm2,
I really appreciate you messing around to find an answer for me. I don't understand what you mean by copy the last two lines down to 79? Maybe there is a template you can recommend for me. All I want to do is inventory my posters, Title, cost, discription, size, comments. Thats about it. I have a couple thousand so I need more entrys then the template in question has to offer. It really makes no sence to me. Semper Fi, Robert Perry "FloMM2" wrote: 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: 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/te...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 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 |
Excel Template????????????????????????????????
Ok Flomm2 I figured out what you meant; it's plain as day after I looked at
it for a few more minutes. I got it to work and I want to thank you for your time. The only thing I don't understand is why would someone make a template that only allows 39 entrys for an inventory. No need to answer that I was just making a statement. Thanks again. Semper Fi, Robert Perry "Robert Perry" wrote: Flomm2, I really appreciate you messing around to find an answer for me. I don't understand what you mean by copy the last two lines down to 79? Maybe there is a template you can recommend for me. All I want to do is inventory my posters, Title, cost, discription, size, comments. Thats about it. I have a couple thousand so I need more entrys then the template in question has to offer. It really makes no sence to me. Semper Fi, Robert Perry "FloMM2" wrote: 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: 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/te...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 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 |
Excel Template????????????????????????????????
Robert,
K. Glad I could help. "Robert Perry" wrote: Ok Flomm2 I figured out what you meant; it's plain as day after I looked at it for a few more minutes. I got it to work and I want to thank you for your time. The only thing I don't understand is why would someone make a template that only allows 39 entrys for an inventory. No need to answer that I was just making a statement. Thanks again. Semper Fi, Robert Perry "Robert Perry" wrote: Flomm2, I really appreciate you messing around to find an answer for me. I don't understand what you mean by copy the last two lines down to 79? Maybe there is a template you can recommend for me. All I want to do is inventory my posters, Title, cost, discription, size, comments. Thats about it. I have a couple thousand so I need more entrys then the template in question has to offer. It really makes no sence to me. Semper Fi, Robert Perry "FloMM2" wrote: 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: 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/te...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 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 |
Excel Template????????????????????????????????
Robert
Open the template through Windows Explorer, not through FileNewTemplate. You want to be working on the template, not a copy. To make sure the stripes stay as white, gray, white, gray select A3:A500 FormatConditional FormattingFormula is: =MOD(ROW(),2)=1 This will force Excel to retain the striping even when database is sorted. Also add the borders to the new cells same as the first 39 rows. Gord Dibben MS Excel MVP On Sat, 30 Sep 2006 12:33:02 -0700, 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/te...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 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 |
Excel Template????????????????????????????????
Robert
You can extend the rows down to 65536 should you choose. Gord On Sun, 1 Oct 2006 05:00:01 -0700, Robert Perry wrote: Ok Flomm2 I figured out what you meant; it's plain as day after I looked at it for a few more minutes. I got it to work and I want to thank you for your time. The only thing I don't understand is why would someone make a template that only allows 39 entrys for an inventory. No need to answer that I was just making a statement. Thanks again. Semper Fi, Robert Perry "Robert Perry" wrote: Flomm2, I really appreciate you messing around to find an answer for me. I don't understand what you mean by copy the last two lines down to 79? Maybe there is a template you can recommend for me. All I want to do is inventory my posters, Title, cost, discription, size, comments. Thats about it. I have a couple thousand so I need more entrys then the template in question has to offer. It really makes no sence to me. Semper Fi, Robert Perry "FloMM2" wrote: 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: 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/te...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 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 Gord Dibben MS Excel MVP |
Excel Template????????????????????????????????
WOW, You are the man Gordan!!!!!!!!!!!! Thanks for your help, it worked !!!!!
Semper Fi, Bob "Gord Dibben" wrote: Robert Open the template through Windows Explorer, not through FileNewTemplate. You want to be working on the template, not a copy. To make sure the stripes stay as white, gray, white, gray select A3:A500 FormatConditional FormattingFormula is: =MOD(ROW(),2)=1 This will force Excel to retain the striping even when database is sorted. Also add the borders to the new cells same as the first 39 rows. Gord Dibben MS Excel MVP On Sat, 30 Sep 2006 12:33:02 -0700, 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/te...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 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 |
Excel Template????????????????????????????????
Actually that should have been A3:I500 but you must have figured that out.
Gord On Tue, 3 Oct 2006 06:30:01 -0700, Robert Perry wrote: WOW, You are the man Gordan!!!!!!!!!!!! Thanks for your help, it worked !!!!! Semper Fi, Bob "Gord Dibben" wrote: Robert Open the template through Windows Explorer, not through FileNewTemplate. You want to be working on the template, not a copy. To make sure the stripes stay as white, gray, white, gray select A3:A500 FormatConditional FormattingFormula is: =MOD(ROW(),2)=1 This will force Excel to retain the striping even when database is sorted. Also add the borders to the new cells same as the first 39 rows. Gord Dibben MS Excel MVP On Sat, 30 Sep 2006 12:33:02 -0700, 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/te...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 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 Gord Dibben MS Excel MVP |
| All times are GMT +1. The time now is 12:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com