In, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that post and then come back.

Is it possible through VBA to give a command to have a cell bring it's contents 'to front'? I have code that needs to populate column A first, then column B. Still split mac hard drive for windows. Unfortunately what is happening is the contents of column A may be long, and are then 'hidden' as column B contents are covering A.

Otherwise, your data will look like one of those housewives who goes to grocery store with curlers and a moo moo sporting red lipstick. Enough chatter. Let’s jump in. If you want to follow along, you can. (Just click the Download button in the upper-right corner of your browser window. Don’t ask me why Dropbox sticks it up there.

Developers ) Standard Number Formatting You would think everyone would use number formatting; it’s so rudimentary. But I can’t tell you how many times I see decimals in charts that should be formatted as percentages or no thousandths separators (a pet peeve of mine) or two decimal places filled with 0’s because the number didn’t need decimals. These newbie mistakes are uncalled for because Excel placed several number formatting options front and center in the Number section of the Home tab. Click for larger image. For the neophytes, here are what those icons mean, from left to right: Currency Convert to currency.

This option will left-align the dollar symbol and right-align the number. Technically, this is referred to as Accounting formatting. (If you want the currency symbol to be flushed up against the number, don’t use this icon; use the Currency option in the drop-down menu above this row of icons.) You can also choose different currencies from the drop-down menu to the right of the currency icon.% Convert decimals to a percentage., This is not a comma; it’s a thousandths separator. And if you have a number greater than 9999 you should use it. (I usually use it for numbers greater than 999.) One weird quirk with this button is it adds two decimal places whenever you apply it.

Most of the time they’re unwarranted. If you don’t have decimals, you should ditch the decimals because they just add noise. But that’s what the next icons are for. Increase Decimal Add decimals. Since I’m not [overly] neurotic or a scientist, I very rarely use this option.

Decrease Decimal Lob off unwanted decimals. I use this all the time. PSA: Please — for the love of all that is holy and measurable — get rid of decimals in chart axes. Select the axis, press Ctrl-1 (Mac: Command-1) to bring up the formatting options, and adjust it in the Number section. Click for larger image. More Ribbon Options Both PC and Mac offer more number formatting options from the ribbon. All you have to do is click the drop-down menu above the icons we just looked at.

(Yeah, guess who Microsoft loves more.) These options are pretty lame. The only one I use on occasion is Fraction. When you see the flexibility you have with the custom number formatting, you’ll snub your nose at these bourgeois offerings. Custom Number Formatting Options Okay, this is where it starts to get fun.

At the risk of sounding cliche, your options are nearly endless once you learn how to rock the Custom option. Pro Tip: To open formatting options, just select the cell(s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc. Date Formatting Excel gives you quite a few options to choose from under Number > Date in the Format Cells dialog (which, again, you get to by pressing Ctrl-1 or Command-1 on the Mac).