Format as Table from your Home tab. It does some nice formatting, but it also gives you a Table Tools tab with many useful options. It recognizes that you want to be able see the column headings of an Excel list when you scroll from the Home tab. You can see how the column headings A, B, and C have been replaced by the table headings. Have you ever noticed the grey gridlines surrounding a cell disappearing? This is because the cell fill setting is set to No Fill rather than White. You probably already know that you can put’before a number in order to make it text. This is useful, for instance, if you don’t want the 0 at first for a phone number. What if there are already a few phone numbers that have missing zeros? You can apply a custom number format. You may be familiar with the fact that Excel’s fill handle can be used to continue the pattern if you enter “January” in a cell. You can also create your own lists. Type the list, select it and go to File, Options and Advanced. Scroll down to General, then click Edit Custom Lists. You can now try it by clicking Import, OK and Do you want your list to be?
