I'm creating dividers for trading card management >.< so each divider will have a set code as well as the cards sequence number in the top right IE M20- 001

an A4 sheet of paper cuts up into 9 equal portions which are very suitable for 9 dividers but i need numbers 1-400+ for this specific code (M20)
I need the spreadsheet to have those codes in the top right, and fit an A4 sheet of paper perfectly.
I also need it to be editable so that once i've done the M20 for example i'm able to change one thing and all the 400+ codes change along with it so as not to have to change that code manually 400+ times.

i'm an absolute excel novice but if someone thinks they can help me with this yell out or if my needs aren't very clear i can try clarify/explain better.

This post was edited by Insured on Jul 2 2023 08:25pm

To create dividers for trading card management in Microsoft Excel with the specific code format and the ability to automatically update all the codes, you can use formulas and Excel's fill handle. Here's a step-by-step guide:

1. Open Microsoft Excel and create a new spreadsheet.
2. In cell A1, enter the initial code for the set, such as "M20-001" without the quotes.
3. In cell B1, enter the number 1.
4. Select cells A1:B1 and drag the fill handle (a small square at the bottom right corner of the selected cells) down to cell B9. This will populate cells A2:A9 with the same code as A1 and cells B2:B9 with the numbers 2 to 9.
5. In cell A10, enter the formula to generate the next code. Assuming the code format is "M20-xxx" and you want to increment the "xxx" part by 1, you can use the formula `=LEFT(A1,4)&TEXT(B10,"000")`.
6. In cell B10, enter the number 10.
7. Select cells A10:B10 and drag the fill handle down until you reach the desired range (e.g., A400:B400). Excel will automatically update the code and number based on the previous cells' values.

Now, you will have a column (A) with the set codes and a column (B) with the sequence numbers. You can adjust the row height and column width to fit the A4 sheet of paper perfectly.

To change the set code, follow these steps:

1. Go to cell A1 and modify the set code to your desired value (e.g., "M21-001").
2. Excel will automatically update the rest of the codes in column A based on the formula in cell A10.
3. You can then drag the fill handle down to update all the codes up to the desired range (e.g., A400).

By using this method, you can change the set code once, and all the codes will be updated automatically, saving you from manually changing each code individually.

Note: Ensure that you save your Excel file so that you can easily modify and update the codes whenever needed.

Feel free to donate.

So i've used your guide to create what i need, but when i print (and this was happening with a sheet that the brother in law created for me as well) the print has a big dirty empty space on the bottom of the page, and if I adjust the size of the cells if it's too big it knocks it into the next page and if i can adjust them so the print preview looks nice but it prints with a larger space at the bottom so it's not breaking the page into equal parts which i need.

I do appreciate the response! learnt some new things with it!


This post was edited by Insured on Jul 2 2023 09:26pm

Thanks for the donation!

I'm sorry to hear that you're experiencing issues with printing. Let's try to troubleshoot the problem and find a solution. Here are a few steps you can follow:

1. Check printer settings: Verify that your printer settings are correctly configured. Make sure the paper size matches the size of the document you're trying to print. Additionally, check the margins and page orientation settings.

2. Adjust print scaling: In some cases, the print scaling settings might cause unexpected spacing issues. Open the print dialog box and look for the "Scale" or "Fit to Page" option. Ensure it is set to 100% or "Actual Size" to prevent any unwanted resizing.

3. Preview before printing: Before printing, always preview the document to ensure it looks as expected. In the print preview, check if the cells are evenly distributed across the page. If you notice any issues, go back to your spreadsheet and adjust the column widths or page layout settings accordingly.

4. Page setup settings: Double-check your page setup settings to ensure they are optimized for printing. Adjust the margins, paper size, and orientation as necessary. You can usually access these settings by going to the "Page Layout" or "File" menu in your spreadsheet program.

5. Consider printing to PDF: If adjusting the settings doesn't solve the problem, you can try printing the document to a PDF file first. This way, you can review the PDF and make any necessary adjustments before printing the physical copy. Most spreadsheet software and operating systems have built-in options to save documents as PDFs.

6. Contact technical support: If you've tried the above steps and the issue persists, it may be helpful to reach out to technical support for your printer or spreadsheet software. They can provide more specific guidance based on the make and model of your printer and the software you're using.

I hope these suggestions help you resolve the printing issue. If you have any further questions, feel free to ask!

https://tinypic.host/image/358023327-1857223601345249-7946871035914982702-n.DN86Q

not sure how to upload images >.<
In print preview even though i have 0 for all settings footer header sides etc it still has a small gap between the sheet and the edge of the page but then when i print, it throws in a big right gap and big bottom gap.

It may simply be your page alignment:
Click Page Layout > Margins > Custom Margins. In the Page Setup dialog box, under Center on page, select Horizontally and Vertically. This will center the sheet on the page when you print.

I only had horizontal ticked and ticking both corrected the left to right alignment but the bottom is still much larger than the top. I don't want any gaps on the sides to begin with to achieve the right sizes, otherwise the middle card is much thinner then the right and left and same with their lengths >.<

You could always screenshot and manually adjust for printing purposes. JS.

ah yeah, that could work too - however i'd need to screenshot every page and alter?
I'm trying to get it as ready to go as possible, but it's starting to seem like it might be more of an involved process
in any case, it will beat writing each card by hand - which i started out doing >.<

appreciate the help my man, i'll keep at it and see what i can come up with

YW. Thanks to you too. Are you having the same issue in other applications? Have you looked at possibly copying the excel spreadsheets into Word, or printing just anything else?