Excel: Fill in fields automatically - how it works
Related Videos: How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in Excel (May 2024).
Microsoft offers you an option in Excel to have fields in a table filled out automatically. This automation saves you a lot of unnecessary work and time.
Have fields filled in automatically in MS Office Excel
Below we present the practical automation mechanism at Excel based on the months.
- For example, if you want the month names as column headings, first enter the month name with which you want to start in a cell. This works vertically as well as horizontally.
- We traditionally start in January. Incidentally, it doesn't matter whether you wrote out the months or preferred to use only the first three letters.
- Then click on the corresponding cell and move the mouse pointer to the small square at the lower right corner of the border.
- As soon as you see a black cross, press the left mouse button and drag the frame over the empty cells of your table that you want to fill up.
- Excel then automatically provides the marked fields with the corresponding month names.
- This also works with the date, the days of the week, the time, continuous series of numbers and other content. Of course, you can also have the same value or the same word entered into the cells automatically several times.
- In order for Excel to recognize which rhythm you want to use, you have to fill out three fields yourself, for example the time. Then mark them and proceed as described above. In this case, the spreadsheet would automatically calculate one hour further.
- Tip: If you select the "Start" tab and click on "Format" in the "Cells" area of the ribbon, you will find a number of format specifications under "Format cells" and you can also create your own formats.
In the next practical tip, we will show you how to create a dynamic calendar in Excel.