XChris1632X Posted November 6, 2014 Report Share Posted November 6, 2014 I have had a small amount of training with excel but forget a lot due to never using it. I have started my own little project at work and I am trying to make a little price sheet. I have a great template that I found but I am running into a few issues. What I have is a basic table that has starts with Product number, name, and price across the top. Underneath will be a listing of each. I would like to be able to print this out and give it to each employee while still allowing it to be updated every year and things added in as necessary. The biggest problem I am facing now is how can I basically set up this table to repeat itself on each page with it starting with the top of the table and the Product number, name, and so on? I thought I almost figured it out but then once I got the first page full and went to add another thing in it pushed everything on the next page down. I can not figure out how I can keep going and get the next item to bump down and start on line 1 of the table on the second page and so on. Hopefully you are following what I am trying to say. I have been working on this for over a year now with no luck in figuring it out. Quote Link to comment Share on other sites More sharing options...
Ramsey Posted November 6, 2014 Report Share Posted November 6, 2014 (edited) go to page layout, print titles, select rows to repeat at top. fixt Edited November 7, 2014 by Ramsey Quote Link to comment Share on other sites More sharing options...
Miller Posted November 6, 2014 Report Share Posted November 6, 2014 go to page layout, print tiles, select rows to repeat at top. Couldn't have said it better myself. It took me about 5 minutes to figure out what the hell you were asking :dumb: that's on me though. I have some pricing experience back in my younger years. Do you guys have a strategy in how you price? I could write you up something that could automatically price your stuff based on margin and whatever cent value you add based on your price tiers (such as items below $20 get .99, something over $500 is .95, etc to infiniti). Quote Link to comment Share on other sites More sharing options...
XChris1632X Posted November 7, 2014 Author Report Share Posted November 7, 2014 Thanks guys. I'm going to try it all out tonight. Miller, I don't really deal with the price part. I am just trying to go the extra mile and help with some organization. Quote Link to comment Share on other sites More sharing options...
Turbs3000 Posted November 7, 2014 Report Share Posted November 7, 2014 go to page layout, print tiles, select rows to repeat at top. just FYI he means Print Titles not tiles though I'd assume you'd figure that out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.