Use AutoFill: MS Excel
After you've built a budget for a single period of time, you often have to repeat the process for several other time periods, say the next month, quarter or year. MS Excel provides the AutoFill feature to copy text, numbers and formulas to adjacent cells. You can also use the feature to create a sequence.
AutoFill saves you the trouble of typing the same text, numbers and formulas repeatedly.
Copy Data
The active cell is surrounded by a bold rectangle, and on the lower-right corner is a small black square called the fill handle.
- Select the cell you want to copy.
- Place the mouse pointer over the fill handle. It turns into a black cross (rather than the normal fat plus).
- Drag across or down adjacent cells.
Using AutoFill you can quickly and easily build a large worksheet by copying text and numbers to adjacent cells. Excel is so smart: when you copy formulas using AutoFill, they automatically adjust to refer to the correct items.
Fill a Series
The AutoFill feature is awesome; it correctly figures out what you want to put in adjacent cells. How it works depends on what you select.
To continue a sequence of dates, times or certain time periods from a single cell:
- Select the cell containing the beginning value.
- Place the mouse pointer over the fill handle.
- Drag across or down adjacent cells.
If you hold down the Ctrl key as you drag the fill handle, numbers increase by 1 and dates and times are copied as is, instead of changed to the next value.
To continue a sequence of numbers, dates or time periods based on the data in two or more adjacent cells:
- Type the first few items of the sequence in adjacent cells.
- Select the cells.
- Drag the fill handle to adjacent cells.
The series extends based on the cells you have selected.
As you drag, the yellow Screen Tip shows the contents of the cells. When you select more than one cell, the sequence continues according to the first few items.
You can also create a custom fill series, such as "high, medium, low" or "strongly agree, agree, neutral, disagree, and strongly disagree."
Visit Carol's web site to learn more tips like this one!
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Smart PC Experts? Here's What to Do
- Scammed by Right PC Experts? Here's What to Do
- Scammed by PC / Web Network Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?
![](/graphics/dennisfaas.jpg)
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 20 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
![](https://www.infopackets.com/graphics/bbb.png)
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.