Select the first value of the new trendline and copy the function by using Excel's Auto Fill feature, dragging the fill handle in the cell's lower right corner to the right until the cell of the last value is selected as well. This way the selection will stay exactly the same when this formula is copied and will not be adjusted according to the new position. ![]() Note: By pressing F4 the cell reference type of the selected cells will change to absolute cell references.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |