In this lesson we discuss cell references, how to copy or move a formula, and format cells.

To begin, let’s clarify what we mean by cell references, which underpin much of the power and versatility of formulas and functions.

relative and absolute dating powerpoint-47

A “cell reference” means the cell to which another cell refers. Cells in the spreadsheet are referred to by rows and columns. For learning purposes about cell references, we will at times write them as row, column, this is not valid notation in the spreadsheet and is simply meant to make things clearer. Absolute – This means the cell reference stays the same if you copy or move the cell to any other cell.

This is done by anchoring the row and column, so it does not change when copied or moved.

Relative – Relative referencing means that the cell address changes as you copy or move it; i.e. Mixed – This means you can choose to anchor either the row or the column when you copy or move the cell, so that one changes and the other does not.

For example, you could anchor the row reference then move a cell down two rows and across four columns and the row reference stays the same. Let’s refer to that earlier example – suppose in cell A1 we have a formula that simply says =A2.

I'm trying to write a little script to help manage my windows via keyboard shortcuts.

In order to do what I want, I need to be able to find the current location and size of the "active" (focused) window.By location, I mean the X, Y coordinates of the window on the desktop, and by size I mean the height and width of the window.Is there a command line utility that can fetch this information?That means Excel output in cell A1 whatever is inputted into cell A2.In cell A2 we have typed “A2” so Excel displays the value “A2” in cell A1.Now, suppose we need to make room in our spreadsheet for more data.