Posts

Excel : Copying formulas (with) constraints

Microsoft Excel is a spreadsheet program that contains one or more worksheets. Each worksheet contains a bunch of cells which are located by a row (1,2,3,etc) and a column (A,B,C,etc).

image

Each cell can contain data or a formula. With a formula your able to transform the data from other cells to whatever you may need. You’ll probably want to re-use the formula in different rows, columns or worksheets.

Read more

Was once an enthusiastic PepperByte employee but is now working at Citrix. His blogs are still valuable to us and we hope to you too.