Daily posts of Excel tips…and other stuff
Archive for the ‘Formatting Cells’ Category.
Hi all,
I’ve just published a new article on my website. Here is the introduction:
“This article explains how you can use styles to ease maintenance of your spreadsheet models.
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done [...]
It’s college football bowl season once again. I have a spreadsheet I use to help me identify winners and losers (for entertainment purposes only).
The four yardage columns are yards per game for rushing offense, rushing defense, passing offense, and passing defense, respectively. I’m trying to identify teams that have better defenses (because defense [...]
Here's what my (partially obfuscated) desktop looks like:
I put information I need on my desktop so I'm a Windows+M key combination away from what I need. The Excel file sits in my XLStart directory so the calendar gets updated every day.
VBA from Excel to Desktop
In the Workbook_Open event, I have
Private Sub Workbook_Open()
[...]
Stu asks:
Is there a number format that I can use that will display numbers in the thousands without actually using a formula? So, 20,000,000 in sales in a cell would actually be displayed as 20,000.
Good question, and yes there is.
The number format #,##0, works because of the comma at the end.
I love the Comma style. I use for almost all of the numbers in my spreadsheets. I have been using the Number style because I could use Control+Shift+1 to apply that format easily. I doesn't dash-out the zeros, though. Microsoft at Home says that Alt+apostrophe will take me right to the [...]
Why am I just hearing of this? Keyboard Shortcuts for Applying Borders. I've always wondered why the Border tab of Format Cells didn't have hotkeys. Now I know - it did. This will be a great time saver for me. It appears that it only applies to Excel 2002 and [...]
I have a report listing sales orders, or more specifically, each line of a sales order. I want to alternately color each sales order so there's a nice visual separation, but I don't know how many lines each sales order will have. If my sales order numbers were animal names and I was [...]
While putting together the last post, something caught my eye. Something that I'd never noticed about cell formatting.
It was a custom cell format that was created without my action: [$-1409]dddd, d mmmm yyyy
It looked like a date format, but what was that [$-1409] ?!
Recognising 1409 as the New Zealand locale ID, I guessed it had [...]
