+ Reply to Thread
Results 1 to 20 of 20

The size of the font on your printout

  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    The size of the font on your printout

    Why does it seem to change sizes on me? I never change anything about my sheet. It is not a choice I have to make each time is it?

    I fel like it's a guessing game to make a print, with the variables that you can't control or see.
    Last edited by 6StringJazzer; 01-14-2018 at 09:40 AM. Reason: changed title to work around forum bug when title ends in "print"

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: The size of the font on your printout

    I have never seen anything like what you are describing (in 25 years of using Excel). Font sizes on the printed sheet do not change if there have been no changes in the sheet itself.

    What layout options are you using? Are you allowing defaults, or setting "1 sheet wide" or something like that?

    Are you always using the same printer? What type of printer is it?

    Does this happen with all your files, or just one? Can you attach one where this happens?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    I don't know how to attach it yet.

    I hit print preview, and lose my visual of my sheet by the way. (This happens to you right? Do you like it?)

    Then I have some choices. I was told to choose fit all columns onto one page to make it work. Because it wouldn't print right before: It saves columns and puts them at the back of the printout and freaking ruins it. Why? Someone tell me?

    So You have to work with it and change things. When you do it changes **** about your sheet. It changed the size of the print. I'm trying to find out how this happens. Is it the printer making trouble?

    How is this software deciding what to print? I mean size, columnization, treatment of blank space, etc etc. I can't control about 3 or 4 things going on here, even though I have been trying desperately. It is just ******* with me and taking up my evenings now. Is there an alternative to excel?

    Is there any way under god that the program just remembers what you need it to? It sure doesn't now. Can font size change because of the printer? What is it looking for?

    I really need the control center for this and I think they made it obscure and hard to figure out. Why?
    Last edited by jeffreybrown; 01-14-2018 at 05:41 PM. Reason: Please do not quote whole posts!

  4. #4
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    BTW: You do realize that in the print preview you can choose to do things that manipulate the image to beyond recognition. So this is a change to font and size right?

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: The size of the font on your printout

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Please note that the Paperclip icon (Attachments button) does not work on this forum.

    Under the Page Layout tab of the ribbon, you have Page Setup, which controls most of the parameters related to printing.

    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Quote Originally Posted by Pete_UK View Post
    It would help if you attached a sample Excel workbook.
    I can try. My files are my work. I don't share them. If I make up a dummy it might take me hours and might not even work to show you, and I'm back struggling with this.

    But I really would like answers to the basic stuff so I can go forward.

    I've stated my problems here about how to control the print. Am I missing something?

    Size of font, columns, cramming stuff into too small a space, printing 100 percent extra wasted pages, not carrying formats from a drag and drop? Do I need to attach a printout to explain this? Is there anything excel does intuitively?

    How do I maintain my file and use it well. I want it to stay what it is and not be messed with while I use excel. When I print shouldn't it print what I want to see? It's a computer program after all. The things I need are small and concrete. It can't do that? Because?
    Last edited by jeffreybrown; 01-14-2018 at 05:40 PM. Reason: Please do not quote whole posts!

  7. #7
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Maybe just tell me what happens when you go to print your files? Why does it work for you? What choices do you have to make? It seems like a lot of them just confuse the software and make a bad print, wasting paper for me. Why doesn't that happen to you?

  8. #8
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    The print and font will change under print preview manipulation. You may print the whole sheet on one piece of paper if you want.

    So is it really true that there is no change to size, font or print?

  9. #9
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Let me ask this one question: If my spacing makes the excel need to print my sheet with some of the columns at the end and ruin it, why can't it tell me that before? 99.99 % of these events end the same way: FIX IT! So a software program that doesn't know this and can't act, is pretty poorly designed

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: The size of the font on your printout

    Are you unable to post a workbook so someone can try to figure out what you're talking about?
    Entia non sunt multiplicanda sine necessitate

  11. #11
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: The size of the font on your printout

    Perhaps you are saving the file as a .csv file, in which case all formatting (and print settings) will be lost.

    Generally, you should highlight the area that you want to print, then click on Page Layout | Print Area to set the highlighted range as the print area.

    Then you can use Page Layout | Page Setup to control how the printed page will look (Landscape or Portrait, Headers/Footers etc.)

    Hope this helps.

    Pete

  12. #12
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: The size of the font on your printout

    You never answered the questions I asked in my very first post:

    What layout options are you using? Are you allowing defaults, or setting "1 sheet wide" or something like that?

    Have you set a "Print Area"?

    If you have modified the default layout, then when you go to Print Preview, instead of immediately showing the preview page you will get an icon that says "Show Print Preview." If that is what is happening, it may appear that font changes are changing, when it reality the page is being scaled to match the options you have selected. You said that this changes when you change nothing in your sheet, but that is unlikely.

    It is difficult to diagnose this without a sample, and your descriptions are mostly complaining about Excel rather than telling us the details of what you are doing.

  13. #13
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Quote Originally Posted by Pete_UK View Post
    Perhaps you are saving the file as a .csv file, in which case all formatting (and print settings) will be lost.

    Generally, you should highlight the area that you want to print, then click on Page Layout | Print Area to set the highlighted range as the print area.

    Then you can use Page Layout | Page Setup to control how the printed page will look (Landscape or Portrait, Headers/Footers etc.)

    Hope this helps.

    Pete
    I save as an excel worsheet. I wouldn't even know how to do anything else.

    It's a file for creativity and songs etc. Not business. I can't just pubish it here. The file is 10 years old and has 7500 items. I copy some of it to another worksheet to print some piece of it. The whole file is 100 pages.

    When I copy some of it and paste it into a blank sheet it loses my columns and ruins the thing for printing. It wants equal 1 inch columns. Why? What part of this don't I know about? Isn't this a question that has only one answer?

    I am printing the way you said and it does work. But there are many ways to handle files. Not sure why any way isn't good. I got used to using the mulitple worksheets to isolate my printing jobs. I didn't like the idea of changing anything about my master file at all.

  14. #14
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Quote Originally Posted by 6StringJazzer View Post
    You never answered the questions I asked in my very first post:

    What layout options are you using? Are you allowing defaults, or setting "1 sheet wide" or something like that?
    Have you set a "Print Area"?

    If you have modified the default layout, then when you go to Print Preview, instead of immediately showing the preview page you will get an icon that says "Show Print Preview." If that is what is happening, it may appear that font changes are changing, when it reality the page is being scaled to match the options you have selected. You said that this changes when you change nothing in your sheet, but that is unlikely.

    It is difficult to diagnose this without a sample, and your descriptions are mostly complaining about Excel rather than telling us the details of what you are doing.
    What does it mean to modify the default layout? Can I reinstate it? How many layout options are there? Is it one choice or a few? I think I was forced into using "all columns on one page" because of other advice gotten here, having to do with excel leaving columns off the page and printing them at the end and wasting half your paper. Did this change something? I was only doing it to be able to print the columns on one page. I didn't want to change anything else at all.

    But choosing that means that the whole thing changes in other ways? That i didn't want or intend?

    The layout options are not intuitive or clear at all to me. Why do I need to opt for columns on one page, when it messes it all up? Why does it not just print all columns on one page because that;s they way human beings look at stuff? I've set print areas a million times. I still can't control them.

    You got a bunch of things: setting the print area, formatting your layout, the right columns on a page, keeping a format while pasting or dragging, all these things to go wrong. I don't even know what to do first, or what makes what unnecessary, or what screws what up by being done or not being done. My process is just to print what I see and it is a problem when it won't do that. Obvioulsy you can't just make one change and have it know what you need. No matter how simple or mundane.

  15. #15
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Why does excel respond to an optional change, one of many there, to one column for instance, by making your file unprintable when it knows what you need already by being your program?

    Shouldn't there be a guide to how those changes affect things if they have a dynamic effect on the file, and stop you from using the software usefully?

  16. #16
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Is layout the things you adjust on the print preview screen?

  17. #17
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: The size of the font on your printout

    I am sorry but you are ranting about Excel instead of telling exactly what you did in your own file. There is abundant information about this in Excel Help pages and thousands of web pages. It appears that you are a bit of a novice in Excel and may not know what things you have changed.

    Reference the image below. Go to the panel for Page Layout, and click on the small arrow in the corner (red circle). Then go to the Page tab and note what you see in the Page Scale area (red rectangle). If it does not look like the picture below, that is your problem.


    PageSetup.jpg

  18. #18
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    Quote Originally Posted by 6StringJazzer View Post
    I am sorry but you are ranting about Excel instead of telling exactly what you did in your own file. There is abundant information about this in Excel Help pages and thousands of web pages. It appears that you are a bit of a novice in Excel and may not know what things you have changed.

    Reference the image below. Go to the panel for Page Layout, and click on the small arrow in the corner (red circle). Then go to the Page tab and note what you see in the Page Scale area (red rectangle). If it does not look like the picture below, that is your problem.


    Attachment 556111
    Sorry for the rant. Thanks for the response.

    If you mean that scaling says "adjust" to 100% on mine, yes it does. What does that mean?

  19. #19
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: The size of the font on your printout

    The default is to print the sheet at 100% of the actual size. You have an option to shrink or expand it for printing if you want. You also have the option to let Excel automatically size the sheet to print the whole sheet on one page, the width of one page, etc. If your window looks exactly like the above then you are using the default and there is no reason that the printout should not look exactly like what your sheet looks like.

    Is there any chance you could replace your sensitive data with some sort of fake data so you can provide your file? What you are describing is not something that I've ever seen and doesn't make sense, so the only way to get any further with this is to see the file.

  20. #20
    Registered User
    Join Date
    07-17-2017
    Location
    New England
    MS-Off Ver
    2016
    Posts
    32

    Re: The size of the font on your printout

    OK. Sometimes it feels like the settings apply randomly and I need to keep riding them, when most programs just leave it where you put it. Maybe it's an illusion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Font style & Font size not displaying when I select in the word doc
    By raju.r.083 in forum Word Formatting & General
    Replies: 13
    Last Post: 10-24-2022, 08:12 PM
  2. Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.
    By avarshav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2016, 11:50 AM
  3. Replies: 15
    Last Post: 05-31-2012, 10:34 AM
  4. Macro to convert several font sizes to another font size - with an exception
    By ddd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-08-2012, 05:17 PM
  5. Replies: 3
    Last Post: 07-06-2011, 01:30 PM
  6. Replies: 5
    Last Post: 04-22-2011, 10:21 AM
  7. Dropdown list for font size, font type and number formats
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1