Excel Template????????????????????????????????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

On Sat, 30 Sep 2006 11:12:02 -0700, Robert Perry <Robert
 
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 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,
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.
 
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
 
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,
K. Glad I could help.

Robert Perry said:
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
Click to expand...
 
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
 
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.

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
Click to expand...

Gord Dibben MS Excel MVP
 
WOW, You are the man Gordan!!!!!!!!!!!! Thanks for your help, it worked !!!!!

Semper Fi,

Bob
 
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 !!!!!

Semper Fi,

Bob
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top