Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
Absolute vs Relative Cell Referencing
Absolute Reference is when you anchor a particular cell(s) in your formula. When you copy an absolute reference to another location, Excel does not change the absolute cell reference. However, the reference will change when it is a Relative Cell Reference.
This autofill feature allows you enter a series of numbers or characters in a specified range, and have Excel complete the entry you started typing. You can have Excel automatically prefill cells with months, days of the week, quarters, dates, number sequencing and a custom list you create.
Ask us how we can service your company's training requirements.