A series refers to a sequence of ordered entries in adjacent cells, such as the days of the week or months of the year. The fill technique can be used to create these in a worksheet for you reducing the amount of time taken for data entry, and ensuring that the spelling is correct. Excel provides days and months as special built-in series that you can access.
Try This Yourself:
Before starting this exercise you MUST open your file as like below format.
1. Click on cell A4
2. Move the mouse pointer to the small square (the fill handle) at the bottom right corner of the cell until the mouse pointer appears as a thin, black cross
3. Drag the mouse pointer to column F Excel will fill the range with the first six months of the year…
4. Click on cell steps 2 and 3A5 to create the and repeat series of months with their full names
You can also fill more than one row at a time…
5. Select the range A6:A12
6. Repeat steps 2 and F 3 to fill across to column F
7. Examine each of the series created by the filling process
For Your Reference…To fill a series:
1. Click on the first cell in the series
2. Drag from the fill handle across as many columns as required
Handy to Know…As you drag the fill handle across, a tool tip appears below the fill pointer displaying the current value in the series. This is really handy when you want to end on a particular month, day or value.
Tags:
filling a series in excel
autofill in excel
fill series excel
excel fill series not working
fill series
autofill numbers in excel
excel fill series shortcut
excel series fill
autofill handle excel
fill series in excel not working
fill the series in range with a growth trend
fill handle is to fill the series of data
excel fill series with letters and numbers
fill series excel shortcut
fill series shortcut
fill series with linear trend excel
auto fill series in excel
excel fill down series
autofill series in excel
excel fill series formula
fill date series in excel
fill series option in excel
shortcut for fill series in excel
date autofill in excel
fill series shortcut in excel
fill alphabet series in excel
series fill in excel
enter a series of values using autofill
shortcut key for fill series in excel
excel autofill series
fill with linear trend in excel
excel online fill series
drag outside selection to extend series in excel
excel fill series keyboard shortcut
excel drag and fill
excel auto fill option not showing
fill series excel mac
shortcut key to fill series in excel
excel fill date series
drag number sequence in excel
excel 365 fill series
excel extend series
auto fill series shortcut excel
fill series formula in excel
excel fill a column with a series of numbers
excel 2016 fill series
fill series excel online
fill series date in excel
cara fill series di excel
fill number series in excel shortcut
excel drag to continue sequence
autofill series in excel not working
fill series of numbers in excel
0 মন্তব্য(গুলি):
একটি মন্তব্য পোস্ট করুন