OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - Fill Handling

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

Fill Handling

PREVIOUS NEXT

Fill handling is a feature in Excel that autofill cells using a specific pattern. The pattern to be used is usually gotten from the user data entered. This feature can be used in numbers and texts.

Before using fill handling in Excel, you have to check whether it is enabled. In most cases it should already be enabled.

  • ENABLE FILL HANDLING
  • Step 1 - Open your excel worksheet. Click on the File tab.
    • fill-handling
  • Step 2 - Inside the home window, at the left side, click More, then click on Options. (This will open the Excel Options windows)
    • fill-handling
  • Step 3 - In the Excel Options windows, at the left side, click the Advanced option. Inside the advance page, under the Editing Options heading, click to mark the check box beside the Enable Fill Handle and Cell drag-and-drop. If the checkbox is already marked, then just go back to the worksheet.
    • fill-handling
  • FOR NUMBERS
  • Step 1 - Open your excel worksheet. Type in the first two numbers.
    • fill-handling
  • Step 2 - Select both cells as shown below, then move your mouse pointer to the small square icon at the bottom right corner of the last selected cell. You will notice that your mouse pointer changes to a Plus sign.
    • fill-handling
  • Step 3 - Now, click and drag down the plus sign as shown in the image below.
    • fill-handling
  • Step 4 - After dragging it to your desired cell position, release the click button the numbers will autofill the rest cells.
    • fill-handling
    note
    NOTE:

    The formatting pattern used (yellow shading for odd numbers) also effected in the autofill process.

  • Step 5 - After excel autofill the cells, you can also use other autofill options. Click the Autofill Options Icon Dropdown Arrow the autofill options will be displayed for you to use.
    • fill-handling
  • Copy Cells - This option when selected enables the data copied from the selected cells to the dragged cells.
  • Fill Series - This option when selected gets the pattern of the selected cells and autofill it to the dragged cells.
  • Fill Formatting Only - This option is used to paste the selected cells formatting to the dragged cell without the data in the cells.
  • Fill Without Formatting - This option is used to paste the selected cells data to the dragged cell without the formatting in the cells.
  • Flash Fill - This option looks at the previous entered data and when ever you start typing the same data it provides an auto completion suggestion.
  • FOR DAYS OF THE WEEK
  • Step 1 - Open your excel worksheet. Type in the monday or any day of the week, then move your mouse pointer to the small square icon at the bottom right corner of that cell. You will notice that your mouse pointer changes to a plus sign.
    • fill-handling
  • Step 2 - Now, click and drag down the plus sign until the 7th cell is selected.
    • fill-handling
  • Step 3 - The days of the remaining week will autofill the rest of the cells.
    • fill-handling
    note
    NOTE:

    Since there are seven days in a week, if you drag it to the 8th or 9th cell, the pattern will start again from first day you typed in the first cell.

  • FOR MONTHS OF THE YEAR
  • Step 1 - Open your excel worksheet. Type in the January or any month of the week, then move your mouse pointer to the small square icon at the bottom right corner of that cell. You will notice that your mouse pointer changes to a plus sign.
    • fill-handling
  • Step 2 - Now, click and drag down the plus sign to the 11th cell.
    • fill-handling
  • Step 3 - The other months of the year will autofill the rest of the cells.
    • fill-handling
    note
    NOTE:

    As you are dragging down the plus sign, you will see the autofill value of the cell by the left side. This enables you to decide the cell you might want to stop at.

  • FOR DATE
  • Step 1 - Open your excel worksheet. Type in the current date using any format of your choice. Move your mouse pointer to the small square icon at the bottom right corner of that cell. You will notice that your mouse pointer changes to a plus sign.
    • fill-handling
  • Step 2 - Now, click and drag down the plus sign to cell you want to stop at.
    • fill-handling
  • Step 3 - The date will increment and will autofill the rest of the cells.
    • fill-handling
  • Step 4 - After excel autofill the cells, you can also use other autofill options. Click the Autofill Options Icon Dropdown Arrow the autofill options will be displayed for you to use.
    • fill-handling
  • Copy Cells - This option when selected enables the data copied from the selected cells to the dragged cells.
  • Fill Series - This option when selected gets the pattern of the selected cells and autofill it to the dragged cells.
  • Fill Formatting Only - This option is used to paste the selected cells formatting to the dragged cell without the data in the cells.
  • Fill Without Formatting - This option is used to paste the selected cells data to the dragged cell without the formatting in the cells.
  • Fill Days - This option is used to autofill the cells with days of the week.
  • Fill Weekdays - This option is used to autofill the cells with weekdays only without adding weekends.
  • Fill Months - This option is used to autofill the cells with incrementing months. Note that the day number will be the same for all cells and only the month numbers will be changed.
  • Fill Years - This option is used to autofill the cells with incrementing years. Note that the day and month number will be the same for all cells and only the years numbers will be changed.
  • Flash Fill - This option looks at the previous entered data and when ever you start typing the same data it provides an auto completion suggestion.
PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT