Excel for Mac 2011 question

Discussion in 'The Howard Stern Show' started by Bye You!, Mar 23, 2014.

  1. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529
    this has been driving me crazy for years.

    I know how to use excel. but one thing i have NEVER been able to figure out is how to size the spreadsheet. lets say i want 5 columns and 10 rows. I cannot figure out how to do it, and i always get spreadsheets that go to infinity. This annoys the crap outta me.

    Anyone know how to do this?
     
  2. RevHortonHeat

    RevHortonHeat Active Member VIP

    Reputations:
    1,667
    Joined:
    Jan 15, 2012
    Messages:
    362
    Likes Received:
    214
    I don't think you can do that. But you could hide those columns and rows. Would that work?
     
  3. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529

    HOW?????? it's making me nuts.
     
  4. John Smith

    John Smith Well-Known Member VIP

    Reputations:
    14,629
    Joined:
    Jul 8, 2012
    Messages:
    2,626
    Likes Received:
    2,883
    Sorry I don't have the answer Bye You, but the entire Office for Mac suite is horrible compared to Office for Windows...it just doesn't have the same functionality. When I'm working on a document for my job I have to use Remote Desktop to plug into my office computer; that's the only way I can be sure everything matches up and works properly.
     
  5. RevHortonHeat

    RevHortonHeat Active Member VIP

    Reputations:
    1,667
    Joined:
    Jan 15, 2012
    Messages:
    362
    Likes Received:
    214
    Shift+Ctrl + right arrow to select all the cells you want hidden, right click select hide.

    Let me grab my computer to verify
     
  6. John Smith

    John Smith Well-Known Member VIP

    Reputations:
    14,629
    Joined:
    Jul 8, 2012
    Messages:
    2,626
    Likes Received:
    2,883
    There is no Ctrl key for Mac, unless you mean the Command key.
     
  7. bobartbooey

    bobartbooey Well-Known Member VIP

    Reputations:
    14,882
    Joined:
    Sep 18, 2011
    Messages:
    4,256
    Likes Received:
    663
    Are you talking about printing or just viewing? If the former set the print range to only include the cells you want. If viewing RHH's sol'n might work, although you could also try adjusting the zoom
     
  8. NotMyBro

    NotMyBro VIP Extreme Gold

    Reputations:
    68,396
    Joined:
    Nov 7, 2012
    Messages:
    6,790
    Likes Received:
    4,975
    Excel is always "infinite" in all directions. Are you trying to do something like this?

    [​IMG]
     
  9. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529

    YES!!!! i cannot stand having all those excess cells hanging around.
     
  10. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529
    but why can't i just GET RID OF the cells past G and anything below 10, for example?
     
  11. NotMyBro

    NotMyBro VIP Extreme Gold

    Reputations:
    68,396
    Joined:
    Nov 7, 2012
    Messages:
    6,790
    Likes Received:
    4,975
    There is a Ctrl key. I think you mean Alt which is called Option (and almost all keyboard have Alt/Option on it). It doesn't have Windows key which is probably equivalent to Command (haven't used Windows in a long time so don't remember anymore).
     
  12. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529

    i'm simply too anal for that to appease me.
     
  13. RevHortonHeat

    RevHortonHeat Active Member VIP

    Reputations:
    1,667
    Joined:
    Jan 15, 2012
    Messages:
    362
    Likes Received:
    214
    my macbook has a Ctrl key - but both work.

    Click on a column, then Shift + Command + Arrow right, then right click and select Hide
     
  14. NotMyBro

    NotMyBro VIP Extreme Gold

    Reputations:
    68,396
    Joined:
    Nov 7, 2012
    Messages:
    6,790
    Likes Received:
    4,975
    Step 1: Layout tab, uncheck Gridlines checkbox.

    [​IMG]


    Step 2: Select a bunch of cells you want to have "lines" and go to Home tab and click on the Border button and pick one of the formatting options.

    [​IMG]

    I only know this because I had to submit reports in Excel few times and the template gov uses are formatted this way.
     
  15. John Smith

    John Smith Well-Known Member VIP

    Reputations:
    14,629
    Joined:
    Jul 8, 2012
    Messages:
    2,626
    Likes Received:
    2,883
    Yes, I was wrong...there is a control key. Sorry!
     
  16. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529

    this is what i got

    [​IMG]


    :nooo:
     
  17. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529
    THAT WORKED!!!!! thank you!!!

    i guess it's OK, even though i still KNOW there are those extra cells floating around, at least they won't clutter things up. :flowers:
     
  18. balloon knot

    balloon knot Well-Known Member

    Reputations:
    39,663
    Joined:
    Nov 15, 2012
    Messages:
    4,001
    Likes Received:
    6,754
    "the person that helps with the spreadsheets" :c
     
  19. Bye You!

    Bye You! The n word guy Gold

    Reputations:
    339,535
    Joined:
    Sep 3, 2010
    Messages:
    79,567
    Likes Received:
    41,529

    I NEED ONE OF THOSE!

    at least i know how to save my spreadsheets, as gigantic as they may be.
     
  20. GaryPuppet

    GaryPuppet Well-Known Member

    Reputations:
    246,262
    Joined:
    Jan 15, 2012
    Messages:
    25,366
    Likes Received:
    48,966


    .


     
    Last edited: Mar 23, 2014