This article itemizes the keyboard shortcuts for Excel for Mac. For information about changing the key assignment of a keyboard shortcut, see Mac Help for your version of the Mac OS or see your utility application. Also see Shortcut conflicts later in this topic. Fill Down + D or CONTROL + D. Fill Right + R or CONTROL + R. Insert cells.
List of browser shortcuts that are not available to Sheets when “Override browser shortcuts” is turned off.
![]()
If the formula already exists in a cell you can fill it down as follows:. Select the cell containing the formula and press CTRL+ SHIFT+ DOWN to select the rest of the column ( CTRL+ SHIFT+ END to select up to the last row where there is data). Fill down by pressing CTRL+ D.
Use CTRL+ UP to return up On Mac, use CMD instead of CTRL. An alternative if the formula is in the first cell of a column:.
Select the entire column by clicking the column header or selecting any cell in the column and pressing CTRL+ SPACE. Fill down by pressing CTRL+ D.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |