For those good with EXCEL, please help!

  • Creator
    Topic
  • #192444
    leglock
    Participant

    I am not too proficient with Excel and wanted to know if there is a way to achieve what I am attempting.

    I want to print some data all on one sheet of paper. I have a spreadsheet with approximately 14 columns of data. If I put all 14 columns on one sheet, the font size becomes extremely small when printed. So what I thought I would do is cut columns 10 -14 and put them under the first 9 columns , thus making the spreadsheet less wide. However, when I do this, the column width of rows 1-5 is already set such that when I paste columns 10-14 below them, many of the headings of columns 10-14 don’t fit. So now I’m trying to find a way to be able to manipulate the column width of columns 10-14 after I paste them below 1-9 without affecting the width of 1-9. So my question is what is the best way to do this so I can print columns 10-14 below columns 1-9 and be able to maniuplate the column width of columns 10-14 without affecting the column width of the columns directly above columns 10-14.

    I was going to try to cheat it and paste columns 10-14 on a separate sheet (thus giving me the ability to manipulate the column width) and leave about 15 rows above it blank and print them, and then put the paper back in the printer and then print only columns 1-9; however, I know there has to be a different way to achieve this. Changing from landscape to portrait also doesn’t help.

    Any help is greatly appreciated.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Author
    Replies
  • #649456
    Anonymous
    Inactive

    You can't change a column width partway down. What you could do is paste your lower half in using every other column and then use a merge to make them into wider cells, but that can get messy as well.

    #649457
    mla1169
    Participant

    Or you could wrap the text in the headers for columns 10-14 so the headers become

    This VS. This is your Header

    is

    your

    Header

    FAR- 77
    AUD -49, 71, 84
    REG -56,75!
    BEC -75

    Massachusetts CPA (non reporting) since 3/12.

    #649458
    Anonymous
    Inactive

    You could wrap it as suggested above or change the orientation of the text. Then check out page layout and set the height / width to 1 page for print preview.

    #649459
    Anonymous
    Inactive

    Go to View and then click on Page Preview. Your text on the screen will look smaller but you will see blue lines. You can move those lines and make whatever you want print on page 2.

    #649460
    ScarletKnightCPA
    Participant

    As mentioned before, there are some things you can do with merge cell but it's not going to be a completely clean solution.

    Far: 76 (Wiley Test Bank)
    Aud: 77 (Wiley Test Bank)
    Reg: 61, 76 (Wiley book, Wiley Test Bank)
    Bec: 86 (Wiley Test Bank)

    MBA in progress

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.