One of the shortcuts provided in Excel 2007 allows you to copy data from the cell above the current cell.
All you need to do is press CONTROL SHIFT "
How does this works. For example if you enter 12345 in cell A4. If you then move to cell A5 and press Control Shift ", 12345 appears in the cell. If you then go to cell A6 and type ABC and press Control Shift ", you end up with ABC12345 in the cell.
This shortcut can be handy when you are entering data that has a lot of similarities like inventory numbers or part numbers.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment