How To Autofill A Series In Excel For Mac Without Mouse

Technically, you cannot drag without using a mouse. But I suppose what you. Answered Jul 6, 2016. 1) Excel Auto-Fill a Series Without Mouse (Keyboard Only).

[Instructor] Excel 2019 provides many different ways for you to enter data. In most cases, you can click a cell, type the value you want, and press Return. However, there will be times when you need to enter a lot of data by hand. For example, if you track sales by month, you might need to enter a long string of month names by hand when you're setting up your workbook. In Excel, you can streamline that process in several ways. In this movie, I will show you how to enter data quickly and efficiently.

My sample file is the Enter Data workbook and you can find it in the chapter three folder of your exercise files collection. The most basic way to enter data into a worksheet is to click the cell and start typing. For example, in cell B2, which I already have selected, I might want to type in calendar year 2017 so in cell B2, I'll start typing CY2017 and then I might realize, oh, I have data from 2016 so I can either backspace over CY2017 to change the seven to a six or, if I want to stop editing entirely, I can press the Escape key and the cell is reset to its original value. So if it already had a value or a formula, pressing Escape would leave it.

Since I know that I have data for 2016, I'll type CY, which is short for Calendar Year 2016 and Enter. Now I can enter my data into cell B3 so let's say that I know I have revenue of $25,000. So I'll just type $25,000, press Return, and I get my value $25,000 and I've already applied formatting to a bunch of cells in this worksheet so don't worry if it doesn't appear the way you want it the first time when you do it.

If I want to enter values into multiple cells at the same time, I can select the cells. So let's say that I know that I have sales of $30,000 for the months of February, March, and April, which is unlikely, but let's say that that happened. I will select cells B4, B5, and B6 and then I'll type $30,000 and with all those cells still selected, I'll press Command Return and Excel enters the same value into all those cells.

This is a free OS X driver which allows your Mac to interface with a Canon PIXMA MP160 all-in-one photo printer. The Canon PIXMA MP160 is a color bubble jet, compact and stylish all-in-one photo printer for your Mac. Canon PIXMA MP160 Driver Download – is the excellent Canon MP160 Driver Windows 10/8/8,1/7/XP/Mac/Linux multifunction printer for my requirements. As a regular computer customer I print a few web pages regularly as a part of my day-to-day usage. Driver for canon mp160 mac.

You can also extend series so for example, I have the month of January in cell A3. The months of the year are a series that Excel recognizes so I can drag the fill handle to extend that series.

The fill handle is the green square that appears at the bottom right corner of a selected cell range and if I move my mouse pointer over it, you'll see it changes to a black crosshair. If I drag down, you'll see from the tool shift that appears that the series is extending. So I have February, March, and April. I can do the same thing for CY2016 and because there's a number at the end, that number will increment.

So if I drag the fill handle to the right, you'll see it goes CY2017, CY2018. However, if I were to hold down the Option button and then drag the fill handle, you can see that the mouse pointer is now not just a black crosshair, but it has a small black crosshair at its top right corner. So if I drag to the right now, you'll see that, in fact, it's repeating instead of extending.

If I release the Option button and then increase the series extension, you can see that my tool tip now says 2018. And when I release, those are the values that I get. Now let's say that I want to assume constant growth for each month over the next couple of years, so for January of 2017, I'll put $30,000 and then for C4, I'll put $32,000. So I'm assuming $2,000 growth. For March, I'll say $33,000 and for April, I'll say $34,000 and Return, okay. If I want to extend the series, I can do so by selecting the cells and then dragging the fill handle to the right and you can see that I get 35, 34, 36, and 38.

And the reason I got those values is because $25,000 to 30 is a $5,000 increase so I see that here, $2,000 from 32 to 34, three from 33 to 36 and four from 34 to 38. So you can see, if you want to build in a series with a standard progression, you can do so. Now I'm gonna switch over to Sheet two and show you a very interesting and very useful capability.