 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Excel 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 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 >Hello, > [quoted text clipped - 10 lines] > >Robert Perry 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=CT011 377101033 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. > Which template is it? > [quoted text clipped - 19 lines] > > > >Robert Perry 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. > 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=CT011 377101033 The gray line is at row 40. [quoted text clipped - 26 lines] > > > > > >Robert Perry 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 > Robert, > If you select the last two lines on the form template (one shaded & one [quoted text clipped - 34 lines] > > > > > > > >Robert Perry 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. > Thank you FloMM2. It seems that there should be an easier way to do this. Are > these templates just for demo purposes? [quoted text clipped - 47 lines] > > > > > > > > > >Robert Perry 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 > Robert, > After fooling around with the templatye, there is an easier fix. [quoted text clipped - 57 lines] > > > > > > > > > > > >Robert Perry 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 > Flomm2, > [quoted text clipped - 72 lines] > > > > > > > > > > > > > >Robert Perry Robert, K. Glad I could help. > Ok Flomm2 I figured out what you meant; it's plain as day after I looked at > it for a few more minutes. [quoted text clipped - 85 lines] > > > > > > > > > > > > > > > >Robert Perry Robert You can extend the rows down to 65536 should you choose. Gord >Ok Flomm2 I figured out what you meant; it's plain as day after I looked at >it for a few more minutes. [quoted text clipped - 85 lines] >> > > > > > > >> > > > > > >Robert Perry Gord Dibben MS Excel MVP Robert Open the template through Windows Explorer, not through File>New>Template. 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 Format>Conditional Formatting>Formula 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 >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=CT011 377101033 The gray line is at row 40. [quoted text clipped - 26 lines] >> > >> >Robert Perry WOW, You are the man Gordan!!!!!!!!!!!! Thanks for your help, it worked !!!!! Semper Fi, Bob > Robert > [quoted text clipped - 42 lines] > >> > > >> >Robert Perry Actually that should have been A3:I500 but you must have figured that out. Gord >WOW, You are the man Gordan!!!!!!!!!!!! Thanks for your help, it worked !!!!! > [quoted text clipped - 48 lines] >> >> > >> >> >Robert Perry Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.