Bonus tip 2: Ctrl+D can also be used to duplicate shapes. (2) Type the data (3) Press CTRL+Enter (4) Done See the animation aside to understand how this works. (1) Select all the cells where you want to enter the same data. You can use CTRL+Enter to do this in a snap. Sometimes, we want to enter same data in to several cells. I remember this by D for down, R for row. Here is a quick Excel tip to kick start your week. Bonus tip: Ctrl+R is the shortcut to copy across.

The value in the active cell (usually the first cell in the selected range) is copied down with Ctrl+D. Then type a password for the sheet, and verify it by typing it again. Ctrl+D is the keyboard shortcut to copy down the value/formula in the selected range. If there are other cells that still need to be locked, on the Review tab, click Protect Sheet or Protect Workbook. Then click to clear the Locked check box so that it is not selected. Select the cells that you want to unlock. On the Review tab, click Unprotect Sheet or Unprotect Workbook. You may need to temporarily turn off protection so that you can unlock cells. If so, under Allow users of this sheet to, choose the elements that you want people to be able to select or change. If you want people to be able to select and fill out unlocked cells, click to select Select unlocked cells.īefore you click OK to finish, you might want people to do other things to the locked cells, like select them or format them. If you don't want people to select locked cells, click to clear the Select locked cells check box. If you lose the password, you can't access the protected parts on the sheet. If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. Into your destination cell and Ctrl+V to copy the formula. Press the Esc button to exit from the formula bar, which prevents a change in reference. Ctrl+C or Ctrl+X to copy or cut respectively. To the formula bar and highlight the formula. If you do not supply a password, any user can unprotect the sheet and change what was protected. Click on the cell which contains the formula you want to copy.

Copy cells down in excel for mac