![]() You can also click on the Expand icon to open the traditional Format Cells dialog box that contains tabs for these various categories. Use absolute references to “lock” in a cell (for example =H2*$I$1)(see tab above for more information)įrom the Home ribbon, you can format the font, number, alignment, border, pattern, and protection of your cells, rows, and columns.The Esc key or red X in the Formula bar will abort your change.If filling down a column, you can double-click it instead (must be content to the cell to the left of this cell) (see tab above for more information) Use lower right corner (AutoFill) of cell to fill down/across.To get the same content in multiple cells, highlight the cells, type in text/number and then press Control+Enter.the whole column or row): Shift+Command+Arrow (Mac) or Shift+Control+Arrow (Windows) To select all of the cells in a row or column that have data (vs. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |