•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to custom margin/print/row?
Our take
Customizing margins and row orientations for printing on 4”x6” cards can enhance your Excel project. To achieve this, start by adjusting the print settings in your spreadsheet application. Set custom margins to fit your card dimensions and experiment with font sizes and spacing to ensure clarity. For printing each row vertically, you can use the "Orientation" feature to rotate the text by 90 degrees. This approach allows you to print your words neatly on the cards without tables, resulting in a clean and professional presentation.
I want to use custom margins and rows to print each row in an excel spreadsheet into a vertical position on this printing card. The card is 4”x6”, and I’m willing to experiment with the font size and spacing to print onto each row of the paper. I’ll just be using words, and no tables or anything similar to worry about. Also I’ll need to rotate the columns by 90 degrees, so is this possible in a spreadsheet or while printing one?
If you had any advice, that’d be great!
The link above is to the same paper I’ve been talking about.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to print multiple pages of a single (but very wide) spreadsheet in what would otherwise be empty/wasted whitespace?Apologies in advance that I am not going to describe this very well... I've used Excel (at a very low level, lol) for ~20 years, so I am not what you would call/consider a 'power user'. I have no idea how to describe this properly, so maybe I should start off with what I'm not wanting to do. I am not trying to get multiple different sheets within a multi-sheet workbook to print on one page... This is also not something that can be solved (at least not completely) by scaling (e.g. 'Fit Sheet on One Page'). I have just one sheet. It is a very wide spreadsheet that is not very tall (13 rows tall: 1 header row + 12 data rows). But it's so wide that it's currently going to print on 4-6 pages (6 pgs in Excel; 4 in Google Sheets). But there is (frustratingly) still a lot of wasted whitespace below the workbook/print area on all 4-6 pages. So what I'm trying to do is to take advantage of all that whitespace and have subsequent pages print below. I could probably get the first three 'pages worth' of the spreadsheet to print on the actual [printed] page 1, and the rest of the spreadsheet to print on page 2. In Microsoft Word and in Adobe Acrobat, I can print multiple pages per sheet. In Microsoft Powerpoint, I can print multiple slides per page. But I don't seem to be able to do the equivalent in Excel. I can't attach a copy of my Excel file, but I copied it into Google Sheets, in case actually seeing the file is easier than me telling you about it: https://docs.google.com/spreadsheets/d/1Jn7m9wT6j1elE4_ikA-FZpXum93DdXEi1uP9UNTOwnU/edit?usp=sharing If you click 'Print' on this (in Google Sheets), you will have a good idea what I mean in Excel. I can also save some room by hiding one of the two time-related fields, and probably also the 'Email' and 'Name' fields... but it's still too wide, and I have the same problem. submitted by /u/jakesyma [link] [comments]
- Excel to PDF and keep formatting!Mostly I’m talking about Row Heights. This excel file is letter summaries. (I have five or eight such gules to do.) I have only two rows - date, and as stated, a summary of the letter. I have tried export, I have tried print to PDF, I have tried save as PDF. None of the options keep my formatting. Some summaries are one, two, or three lines, some summaries are as many as 10, 11, or 12 lines. The column is formatted for wrap text. In the first file I’m working with it’s about 33 pages. On my screen each line looks exactly as I want it to look. Uniform space above and below the letter summary. Which means almost no space, I don’t need any space above and below. My rows are separated with top and bottom borders. No matter what I do, when I turn the file into a PDF, it adds a lot of space above and below the text on the letter summary. This often results in a large portion of the page sometimes remaining empty. I have tried outputting with the default formatting, - meaning I undid wrap text, set the row to adjust to the default height of my font, then re-clicked wrap text so that the height of the row was now determined by how many rows of text in the cell. (I’m sorry if this sounds confusing I’m trying to be very clear. ) Looked great but still had poor formatting when it reached PDF with lots of space in each cell below and above the words of the summary. So I tried tried manually adjusting row heights so that there is very little space above and below the words. Same output. All my googling tells me this is a common occurrence. I am doing this for a client family archives. It needs to look good as a PDF when printed or when viewed on a monitor. The amount of space it’s giving me is a terrible look and not clean or consistent in any way. This might not be the route to go to get the look I need. Can anybody help me with some advice to turn this clean Excel sheet into a clean looking PDF with appropriate formatting? submitted by /u/JvaGoddess [link] [comments]
Tagged with
#rows.com#row zero#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#Excel alternatives for data analysis#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#Excel alternatives#spreadsheet API integration#financial modeling with spreadsheets#custom margins#excel spreadsheet#print