Select a row then insert one row above it Move to right/ to left between nonadjacent selectionsįill a cell’s content down to all cells selected with Shift+Arrow Downįill a cell’s content content up to all cells selected with Shift+Arrow Down Vie w – Freeze first visible Row on screen Split or unsplit Worksheet at current position Vie w – Freeze or un freeze unfreeze works for any Freeze Setting Move worksheet ( Home – F ormat – Move worksheet)Ĭhanges Worksheet tab color, continue with mouse or arrow keys ( Home – F ormat – Tab color) Renames worksheet ( Home – F ormat – Rename worksheet) Rechecks all the dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated Ungroups selected PivotTable items when on group header Selects all Formulas ( Home – Find – Formulas) Go to previous workbook,(workbook) Move to previous tab(Dialog box)Ĭreate name by using names of row and column labelsĬtrl + Shift + the time format with the hour and minute, and indicate AM or PM Select or deselect one word to the left/ rightĮxtend selection to first cell of the worksheetĮxtend selection to last used cell on the worksheet (lower-right corner)ĭisplay Format Cells with Font tab selected
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |