Is there a one button shortcut for "copy cell above & paste here"
I have large data entry spreadsheets (10-20 columns) often with one or two
cells duplicated in the next row down. Is there a shortcut key which will effectively act as "ditto" and enter the value & format from the cell above? Can I MAKE a short-cut key to do this? copy/paste and autofill by mouse take too long |
Is there a one button shortcut for "copy cell above & paste here"
irishseawatcher wrote:
I have large data entry spreadsheets (10-20 columns) often with one or two cells duplicated in the next row down. Is there a shortcut key which will effectively act as "ditto" and enter the value & format from the cell above? Can I MAKE a short-cut key to do this? copy/paste and autofill by mouse take too long Follow the directions in the help file under "Create a Macro". For step #8, you want "Relative Reference" selected. For step #9, press the up arrow, select "Copy" from the Edit menu, press the down arrow, select "Paste" from the Edit menu. This is based upon the help file for Excel 2003. Your version and help file text could vary. |
Is there a one button shortcut for "copy cell above & paste here"
Glenn wrote:
irishseawatcher wrote: I have large data entry spreadsheets (10-20 columns) often with one or two cells duplicated in the next row down. Is there a shortcut key which will effectively act as "ditto" and enter the value & format from the cell above? Can I MAKE a short-cut key to do this? copy/paste and autofill by mouse take too long Follow the directions in the help file under "Create a Macro". Forgot to mention to select "Record a Macro" in the help file to display the list of steps. For step #8, you want "Relative Reference" selected. For step #9, press the up arrow, select "Copy" from the Edit menu, press the down arrow, select "Paste" from the Edit menu. This is based upon the help file for Excel 2003. Your version and help file text could vary. |
Is there a one button shortcut for "copy cell above & paste here"
Ctrl+D
With a single cell selected, copies format from cell above. If doing a large range, select the cell to be copied AND the cells you want to copy to. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "irishseawatcher" wrote: I have large data entry spreadsheets (10-20 columns) often with one or two cells duplicated in the next row down. Is there a shortcut key which will effectively act as "ditto" and enter the value & format from the cell above? Can I MAKE a short-cut key to do this? copy/paste and autofill by mouse take too long |
Is there a one button shortcut for "copy cell above & paste here"
Luke M wrote:
Ctrl+D With a single cell selected, copies format from cell above. Cool! Didn't know fill-down would work that way. |
All times are GMT +1. The time now is 02:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com