Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
2x2 Binder Thickness
>
Reply to Thread
Message:
<p>[QUOTE="quarter-back, post: 1788074, member: 47022"]The lay-out was trial and error, but the end result is an excel page with alternating thick and thin rows and columns. Rows 1, 3, 5, 7, 9, and 11 have row heights of 6.75. Rows 2, 4, 6, 8, and 10 have row heights of 193. Columns A, D, F, H, and J have column widths of 1.14. Column B has a width of 0.25. Columns C, E, G, and F have widths of 31.57. Page set-up is Letter, 600 dpi, Portrait, adjust to 79% of normal size. Margins are 0.12 top and bottom, 0.13 top and bottom, header and footer are 0.13. Printing requires a printer that will print pretty much to the edge of the page. It ends up matching pretty well with the pockets hold the coins. I don't know what types of files can be up-loaded but I could post a blank lay-out (*.xls file) if the moderators do not mind. </p><p> </p><p>Putting the text into the box is relatively simple. Not sure how things work on a MAC, but on a PC , Shift-Enter will move the cursor to the next line within a cell. </p><p> </p><p>As for pictures, most are ones I've found on the web, and are only for my use. I could not give copies since they from a variety of web sites. You will have to find your own to fit your needs. When I find what I want, I put into PhotoShop, set to gray-scale crop it how I like it, adjust brightness and contrast to taste, and then set the height to a standard of .75 in. Width is based on retaining proportions when setting height. The resulting picture is just copied and pasted into Excel where they can moved about as needed. I have found that trying size the pictures in Excel is difficult, so use your photo editing software.[/QUOTE]</p><p><br /></p>
[QUOTE="quarter-back, post: 1788074, member: 47022"]The lay-out was trial and error, but the end result is an excel page with alternating thick and thin rows and columns. Rows 1, 3, 5, 7, 9, and 11 have row heights of 6.75. Rows 2, 4, 6, 8, and 10 have row heights of 193. Columns A, D, F, H, and J have column widths of 1.14. Column B has a width of 0.25. Columns C, E, G, and F have widths of 31.57. Page set-up is Letter, 600 dpi, Portrait, adjust to 79% of normal size. Margins are 0.12 top and bottom, 0.13 top and bottom, header and footer are 0.13. Printing requires a printer that will print pretty much to the edge of the page. It ends up matching pretty well with the pockets hold the coins. I don't know what types of files can be up-loaded but I could post a blank lay-out (*.xls file) if the moderators do not mind. Putting the text into the box is relatively simple. Not sure how things work on a MAC, but on a PC , Shift-Enter will move the cursor to the next line within a cell. As for pictures, most are ones I've found on the web, and are only for my use. I could not give copies since they from a variety of web sites. You will have to find your own to fit your needs. When I find what I want, I put into PhotoShop, set to gray-scale crop it how I like it, adjust brightness and contrast to taste, and then set the height to a standard of .75 in. Width is based on retaining proportions when setting height. The resulting picture is just copied and pasted into Excel where they can moved about as needed. I have found that trying size the pictures in Excel is difficult, so use your photo editing software.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
2x2 Binder Thickness
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...