I'll press escape to close out the options button and I'll press command Z to undo my change. Fill formatting only is very useful because if you already have values and a sequence of cells, but have only applied formatting to one of them, you can copy the formatting over and you won't change the values, you'll just change their appearance. I could copy the cells, fill the series, fill with formatting only, or fill without formatting. So if I click that, I get a list of things that I could do. I also see an options button and that is the auto-fill options. Now, if I click and drag to the right, you'll see that I get calendar year 18, 19, 20 and 21. So if I drag my mouse pointer over it, you'll see that it's changed to a black crosshair. There is a small green box, which is called the fill handle. If I want to create a numerical series starting with calendar year 17, then I can click cell B2 and move my mouse pointer over the bottom right corner of the selected cell. So there I have my header for a calendar year 17, and I'm taking advantage of formatting that I already had in place. I could start by clicking cell B2, which I actually already have selected and then type CY, followed by an underscore, and then the number 17, and press return. So starting with calendar year 2017 and moving on to calendar year 2021. Let's say that I wanted to set up data for a number of years. My sample workbook contains two worksheets and we're currently on sheet one. In this movie, I will show you several techniques for entering data into your workbooks. Entering data into Excel worksheets is often a straightforward process, but there are some ways to make it go faster.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |