Microsoft Office Development and Consultancy
|Excel > Formatting > Advanced Techniques||< Previous | Next >|
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.
|© Better Solutions Limited 06-Dec-2013||< Previous | Top | Next >|