Browse by Tags

Merging Cells with Styles

I was trying to delete the contents of a cell with the delete key and I got the error: The cell or chart you are trying to change is protected and therefore read-only. I know the sheet was protected, but I was certain the cell was unlocked. I was certain because I created a style for [...] Read More...

Published Mon, Apr 04 2011 7:30 AM by Daily Dose of Excel

Filed under: Formatting Cells, Protection

Runway Math

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 centerline’s magnetic azimuth, [...] Read More...

Published Thu, Jul 07 2010 7:30 AM by Daily Dose of Excel

Filed under: String Functions, Formatting, Formatting Cells

Show Locked Cells

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 Dim fc As FormatCondition Dim lFcIndex As Long Set sh = [...] Read More...

Published Tue, Jun 06 2010 7:00 AM by Daily Dose of Excel

Filed under: VBA, Formatting, Formatting Cells, Protection

Date Formatting

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. This avoided the dd/mm [...] Read More...

Published Wed, Dec 12 2009 3:29 AM by Daily Dose of Excel

Filed under: Formatting, Formatting Cells

The Whole Column

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 is that it causes the [...] Read More...

Published Thu, Oct 10 2009 2:44 AM by Daily Dose of Excel

Filed under: Formatting, Formatting Cells, Tutorials

Numbers in Disguise

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”. I admit, this is a pretty dirty trick, [...] Read More...

Published Tue, Oct 10 2009 1:59 AM by Daily Dose of Excel

Filed under: Data Validation, Formatting, Formatting Cells

Styles in Excel

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 [...] Read More...

Published Thu, Feb 02 2009 11:55 AM by Daily Dose of Excel

Filed under: Excel12, MVP, Range Object, Formatting, Formatting Cells

Syndication

Recent Posts

Tags

News

Archives