Excel New Year Resolutions

Well folks, it’s officially the year 2012. And even though the Mayans have put a stigma on 2012 with all their “end of the world” mumbo jumbo, I’m very excited about the upcoming year.

.

This is the time for new-year’s resolutions. I was going to put down “stop procrastinating” on my list, but I never got around to creating it.

.

If you too have yet to create your list of new-year’s resolution’s, here are a few Excel resolutions you can adopt for 2012.

  1. Stop emailing workbooks called Book1.xls
  2. Stop using Merge and Center
  3. Stop hiding cell content using White font
  4. Start making your workbooks Print-ready, so we don’t print 25 blank pages when we print it
  5. Stop printing Excel eye charts with 8 pitch font

Feel free to add your own. Happy New Year!

9 thoughts on “Excel New Year Resolutions

  1. David Tyler

    (regarding #1)
    Fine. For 2012, I’ll email workbooks called Book1.xlsx

    Just kidding, of course. Hope you have a great 2012!

  2. David

    Why not use merge and center? What if you have a header that should be centered above two or more subheaders?

  3. David

    fyi.. something seems to be wrong with the timestamp of the post. It is currently January 3, 2012 7:00 AM central time when I post. The timestamp says it is 4 PM.

  4. Janice

    David,

    Merge and Center can be achieved by using Merge Across instead. DataPig probably has his own reasons for recommending this, but for me it makes it easier to format and manipulate cells – have you ever gotten the message from Excel saying it can’t complete the function because cells are merged? If you merge across instead, you see the same visual effect but have less of a headache when trying to work with the cells.

    Just my .02

  5. ruve1k

    Merge across is equally bad. You should use Center Across Selection.
    (Format cells dialog > Alignment tab > Horizontal > Center Across Selection)
    It provides the same visual effect without merging the cells. It’s a darn shame that they (MS) didn’t make this feature more accessible.

  6. PataRock2

    Ohhh yeesss, totaly agree with you Ruve1K.

    and I recoginze I hide content whit blank fonts….and of course I forgot it…what a shame.

  7. Alberto

    Hey, thanks for all the information that you share about access, those are exellent videos tutorials……thanks and bless you the Lord,

    Regards from Dominican Republic

  8. Steph Locke

    Felt the no merge one was very good for 2013 too – so here’s a bit of macro to chuck into your personal workbook so that you can add it your ribbon and use it instead of merge. You need to have the cells selected before you press it – just like standard marge options.

    Cheers,
    Steph

    Sub CenterAcrossSelection()

    ‘ CenterAcrossSelection Macro


    With Selection
    .HorizontalAlignment = xlCenterAcrossSelection
    .VerticalAlignment = xlBottom
    .WrapText = False
    .Orientation = 0
    .AddIndent = False
    .IndentLevel = 0
    .ShrinkToFit = False
    .ReadingOrder = xlContext
    .MergeCells = False
    End With
    End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *