Leading the way in Microsoft Office Development

Merged Cells

To quickly create duplicate merged cells, merge your first cells and then drag the fill handle to create the additional merged cells.

To select cells in a range excluding one value. Select the whole column range. Hold down Ctrl and select the cell of the value you want to exclude. Press (Ctrl + Shift + “ | ”). If your data is in rows then press (Ctrl + Shift + “ \ ”).

Double click on the paint brush (located on the Formatting toolbar) to copy a format to a selection of non-contiguous cells. Single click it afterwards to cancel.

You can create automatic list numbering next to cells that contain data with the following formula ("=IF(B1<>"",COUNTA($b$b1:b1)&".","")".

Using the “Extended Formats and Formulas” options Excel will now automatically format a new item added to a list. There must be three of the preceding five rows with the same format. This feature also copies down a formula if the preceding rows contain the same formula.