Daily posts of Excel tips…and other stuff
Archive for the ‘Formatting’ Category.
I like the Comma style. It's by far my favorite. What I don't like is how hard it is to apply that style with the keyboard. In 2003, all you have to do is:
Alt + O + S + DownArrow + UpArrow x 4 + Enter
Unless you're me. If you're me, [...]
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 Wednesday night. That means I'm drinking Tangueray and reviewing football games (for entertainment purposes only). I like to rate games on a three-star system. Three stars means refinance the house and fly to Vegas. Two stars means I really like a team. And one star means I'd have as [...]
I'm graphing some temperatures and need to display them with the degree symbol, but they need to remain numbers (not text) so they can be graphed. Here's the number format:
+###°C;-###°C;_+0°C
The output looks like this:
60 +60°C
0 0°C
-20 -20°C
The three parts of the number format are separated by semicolons. The first part defines the format for positive numbers, [...]
Over on Swimming Splits, Olly asks:
I am a rowing coach and am putting the data that my crew gives me from their training sessions into a spreadsheet in the mm:ss.00 format. However, if I make a mistake inputing the data e.g type 1:23.03 when it should be 1:23.30 something weird happens.
When I click in the [...]
I had a worksheet table with blank rows separating the groups.
I needed to add another column - a formula - but wanted to retain the blank rows for formatting tidiness.
The table after adding the formula column:
Notice the formula produces zeros for the blank rows. I could just select each cell (D3, D5, D8, D10) and [...]
El Says:
"I have a spreadsheet with dates and on each day, there are several activities with start time and end time. I want to add a row between each day, and also to add up the total time for all the activities in each day."
This is where the Subtotals feature is quite useful.
It can add [...]
From time to time, I am asked to audit a spreadsheet.
One of the common mistakes I see is an inconsistent formula inside a group of cells.
For example:
- A1 has the formula =G1 * 0.105
- A1 has been formula auto-filled to A1:E5
- Then some time later, cell A3 has been changed to =G3 * 0.107
So the [...]
