Using custom lists with the fill handle

• Autores: Bill Jelen
• Localización: Strategic Finance, ISSN-e 1524-833X, Vol. 98, Nº. 1, 2016
• Idioma: inglés
• Texto completo no disponible (Saber más ...)
• Resumen

  • After releasing the mouse button, you can choose to fill months, years, or work days. * To have the number 1 extend to 2, 3, 4, and so on, hold down the CTRL key while dragging the fill handle. CREATING A CUSTOM LIST In the seminar, the member frequently had to create reports with Jan through Dec in columns B through M and then Total in column N. You also can imagine scenarios where you want Jan, Feb, Mar, Q1, Apr, May, Jun, Q2, and so on. Note that if you type May, this entry is found in both the month name list and the month abbreviation list. Since the month names are below the month abbreviations in the Custom List dialog, the fill handle will always give you the full month names when you start dragging from May.