![]() 0.5" looks good to me change as you like. The cells are smaller than I'd like, so to change this I right click the rows on the far left and go down to "row height". To do so, click "wrap text" (second image). Click the arrow in the top left corner of the grid (see first picture) to select all cells, or press ctrl/command + a.įor the formatting, I like to make all cells' text wrap to another line if it's longer than the cell's width. To pre-format all your cells, you'll first need to select all of them. NOW let's finally move onto the expense tracker, shall we? Step 12: Cell Size and Formatting There are others, of course, but these are the ones I see as most useful. ctrl/command + h = hides window from screen (doing illegal business, eh?).ctrl/command + f = find specific cells with keywords.ctrl/command + y = redo the previous command.ctrl/command + z = undo the previous command.ctrl/command + x = cuts the cells you've selected.ctrl/command + c = copies the cells you've selected.ctrl/command + p = open print dialogue window.ctrl/command + n = opens a new blank workbook.(fifth picture)Īdditionally, you may find some keyboard shortcuts handy: Note: Excel is great in that it provides a small box to guide you on how to fill out the formula (the syntax of cell that go into the parentheses).COUNTIF() counts up cells that meet a certain criteria. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |