| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to switch from "fill down" to "copy" with mouse drag | Excel Discussion (Misc queries) | |||
| copy and paste the cell with formula ="1" | Excel Discussion (Misc queries) | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
