« 'exceltoxl' wishing you a | Prepare a Gantt Before Sipping a Tea » |
Dec
28
Auto Filling Tricks in Excel
Learn Excel, Excel TipsHi there,
We have an user friendly feature in Excel which is "Auto Filling". Auto Filling will help the excel lovers to fill the below cells with respect to the parent cell and same time it helps to fill right hand side cells with respect to the parent cell. Let us see how this feature works with respect to formulas, values, dates and characters. Let's AutoFill...
READY......
GET ......
SET .....
GO....
...
AutoFill Numbers:
- Copy Cells
- Fill Series
- Fill EVEN Numbers
- Fill ODD Numbers
- Fill Formatting Only
- Fill Without Formatting
AutoFill Letters/WeekDays:
- AutoFill Letters
- AutoFill Days (series)
- AutoFill WeekDays
- AutoFill Working Days
AutoFill Dates:
- AutoFill Years
- AutoFill Series
- AutoFill Dates
- AutoFill WeekDays
- AutoFill WeekDays excluding Weekends
AutoFill Formulas:
- AutoFill Formulas
- AutoFill towards Right and Down
- AutoFill cells using Relative References
- AutoFill Cells using Absolute or Fixed References
TURNOFF AUTOFILL OPTIONS:
To turnoff autofill feature one has to click on
- Office Button
- Excel Options
- Advanced
- Editing Options
- Uncheck "Enable fill handle and cell drag-and-drop" option
HOW To ALERT BEFORE OVERWRITING CELLS?
Check mark the option "Alert before overwriting cells". This option is available in
- Office Button
- Excel Options
- Advanced
- Editing Options
- Check mark "Alert Before Overwriting Cells"
SMALL EXERCISES FOR YOU:
- Try using fill handle for TIME
- Try using fill handle for Quarters (1,2,3....)
DID YOU USE AUTOFILL?
Have you used autofill options at your work. Did you find any challenges while working this option. Why are you waiting for? Use this space to share with valuable comments, ideas, suggestions, tips and tricks in the below comments section.
If you find this post usefull to you then please do share or like it by using social networking sites placed around the blog.
To support me for maintaining this blog please do REGISTER here for free and to receive latest updates from exceltoxl.com
SOME IMPORTANT LINKS:
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments