of selected cells by clicking on the small box at the bottom of the workbook close to the middle. Easily find out the sum, counts, mean, max, etc.Use a colon to select a range of cells.Minor trick = to stop the shimmering around a selected cell, press esc (selection is still loaded).Track changes in your document (very useful if you shared it with someone else for editing) going to tools > track changes > highlight changes (can reject or accept them too).If I leave out the dollar sign, it'll do B1 - A1, B2 - A2, etc. For example, I want to subtract cell A2 from a whole column so I type " = B1 - $A$2 " into B1 and drag the lower right corner to do that for the column of B.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |