How do you write an equivalent formula in Excel?

How do you write an equivalent formula in Excel?

Using the "Equal to" operator with dates. You might be surprised to know that the Equal to logical operator cannot compare dates as easily as numbers. For example, if the cells A1 and A2 contain the date "12/1/2014", the formula =A1=A2 will return TRUE exactly as it should.

How do you shift down cells in Excel on a Mac?

Insert cells

  1. Select the cell, or the range of cells, to the right or above where you want to insert additional cells. ...
  2. Hold down CONTROL, click the selected cells, then on the pop-up menu, click Insert.
  3. On the Insert menu, select whether to shift the selected cells down or to the right of the newly inserted cells.

How do you shift cells right in Excel?

Move cells by drag and dropping

  1. Select the cells or range of cells that you want to move or copy.
  2. Point to the border of the selection.
  3. When the pointer becomes a move pointer. , drag the cell or range of cells to another location.

How do you shift cells down in Excel using the keyboard?

Your options are:

  1. Ctrl + Shift + “+” + I: Shifts cells right to insert cell.
  2. Ctrl + Shift + “+” + D: Shift cells down to insert cell.
  3. Ctrl + Shift + “+” + R: Inserts entire row.
  4. Ctrl + Shift + “+” + C: Inserts entire column.

What is the F4 key in Excel on a Mac?

The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T.

How do you lock cells in Excel on a Mac F4?

Lock cells to protect them in Excel for Mac

  1. Select the cells that you want to lock.
  2. On the Format menu, click Cells, or press. ...
  3. Click the Protection tab, and then make sure that the Locked check box is selected. ...
  4. If any cells should be unlocked, select them. ...
  5. On the Review tab, click Protect Sheet or Protect Workbook.

How do you ALT F4 on a Mac?

On your Mac keyboard, you have Command (⌘ cmd), Control (ctrl), and Option (⌥ alt) keys....How to use the Alt key on a Mac keyboard.
Closing a windowAlt-F4Command-W