(Selection sets are created by clicking on a single cell then, as you hold down the Ctrl key, clicking on other cells you want included in the set.) Type the formula you want to appear in each cell in the set, then press Ctrl+Enter. All you need to do is create a selection set of the cells you want to edit. If you want to retype the formula from scratch, Excel actually provides a shortcut to do this: Ctrl+Enter. He knows he can change the formula in one of the cells and then copy the formula to the other cells, but he's wondering if there is a way to change the formula in all the cells at the same time, without the need to do the copy/paste operation. He needs to change the formula in all the cells to something else. David has several non-adjacent cells that each contains the same formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |