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.To go left or right: Tab (left) or Shift+Tab (right) or arrow keys.To go up and down in the cells: Enter (down) or Shift+Enter (up) or arrow keys.In addition to the more common shortcuts such as copy, cut, paste, and save, Excel has a number of shortcuts that you will find helpful - some you may know, others maybe not! Are you pasting a formula? Do you want just the value of the cell? To keep the same formatting? Once you choose, click the appropriate button to paste the data. If you hover over one of the Paste Option icons, you will see a preview of what the data will look like.
Copy the data, and then right-click the cell you would like to paste it into.
