-
15 Spreadsheet Formatting Tips For the last couple years I’ve been meaning to pull together some of the tips that I’ve learned working on the Excel team about how to make nice looking spreadsheets. Well, last week, Rob Collie (a previous Excel Program Manager, and now CTO at Pivotstream and...
-
We've noticed some of you searching for help using "$" — a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. In this post, we'll talk a bit about both uses of the dollar sign. ......
-
For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0120-1%20banded%20rows.shtml Tushar Mehta Read More...
-
Do you like to spend your free time writing and editing crossword puzzles? Who doesn’t. Well, hopefully this crossword template will make it easier.
It starts with this blank puzzle. You enter a space to indicate a black cell and the opposite cell also becomes black. When you’re done entering...
-
From Wikipedia:
Runways are given a number between 01 and 36. This indicates the runway’s heading: A runway with the number 36 points to the north (360°), runway 09 points east (90°), runway 18 is south (180°), and runway 27 points west (270°). Thus, the runway number is one tenth of the runway...
-
I recently complained about listing conditional formatting in 2007. Now it’s time to do 2003. Excel 2003 was a little easier in some ways and harder in others. Far less “Types” to worry about, but no AppliesTo property. So I had to go cell by cell and check for FormatConditions. Whenever...
-
A few times in a man’s life, technology meets genius to create something truly remarkable. This is one of those times.
Applying a style to a cell with the keyboard is a pain. As I’ve mentioned in a previous post, I created a macro and assigned it the hotkey Ctrl+M.
Sub MakeComma()
...
-
Here’s a utility to format unlocked cells using conditional formatting so that I can easily see that I’ve set the Locked property appropriately.
Private msFormula As String Sub ToggleLockedCellFormat()
Dim sh As Worksheet
Dim rng As Range
...
-
I wrote some code to list out all the conditional formatting rules in a worksheet. It wasn’t as easy as I thought it would be. In Excel 2007, MS introduced some new format conditions like Icon Sets and Databars that complicate things. As a result, I didn’t get too fancy with the [...] Read...
-
CR rants:
One thing about Excel 2007 that really bugs me are the tab colors. Most of the choices look so washed out, rather than a nice solid color. One does not have a choice when Excel makes the tab text white or black. Sometimes, Excel chooses a white font for the text [...] Read More...
-
In New Zealand, we format our dates dd/mm/yy. However, the United States format as mm/dd/yy.
When I see a date by itself, like 12/01/09, I ask “is this the 12th of January or the 1st of December”?
When I started working with Oracle RDBMS, a habit I picked up was to format dates dd-mon-yyyy...
-
Nothing wrong with this sheet, right? Until you get to the end… The teeny-tiny vertical scrollbar handle is usually a give away. Hundreds of rows tacked onto the end of the list to give the illusion that the whole column has been formatted.
The trouble with formatting columns as per the above image...
-
It is possible to get a cell to display one thing, but store another.
Create a Custom Format by right-clicking the cell, select Format Cells…, then from the Number tab select Custom.
In the Type box use whatever text you want displayed, but be sure to enclose it in “double-quotes”....
-
Excel has a Text format that can be applied to cells. When a cell is formatted as Text, anything you type in the cell will appears in the cell. That may seem obvious, but it applies to numbers and formulas too. For instance, if you type a formula in a cell formatted [...] Read More...
-
If you type a number into an unformatted cell in Excel, that number is stored in the Double data type. When you format that number, you show it in a specific way, but you don't change the number. For instance, if you format the number 1 as a Comma style, you get 1.00. [...] Read More...