You can use the Freeze Panes command to “freeze” (lock) rows and/or columns in place so that headings remain visible at the top of your report as you scroll down your spreadsheet.
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.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.