| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 50325 | 2004-10-17 07:41:00 | Customise Excel's Right click drop down menu | peter_mundy (2855) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 281940 | 2004-10-17 07:41:00 | Sunday, 17 October 2004 Using Excel 2003 and Windows 2000 . Every month I have to take 12 sets of Excel spreadsheets (produced by different, independent people) and copy some 50 odd figures (in a sheet with 100's of figures) from each one of one set and paste "values only" into the other set . The figures appear at different places in each sheet, each month . I display (arrange) the two sheets side by side and copy from one to the other . From one I right click on the source cell and right click and "copy" then I go to the other set and right click and select "paste special", "value only" etc . Which after the first 100 or so gets quite frustrating . Can any one tell me how I can customise the "right click" drop down menu, so the "paste special, values only" option is available within the first displayed drop down menu . ?? Any help may help my sanity!!?? Thanks Peter Mundy ' |
peter_mundy (2855) | ||
| 281941 | 2004-10-17 08:44:00 | If no one comes to your rescue try the excel forum here (216.92.17.166) they should be able to help. hth |
johnboy (217) | ||
| 281942 | 2004-10-17 08:44:00 | If no one comes to your rescue try the excel forum here (216.92.17.166) they should be able to help. hth |
johnboy (217) | ||
| 281943 | 2004-10-17 09:42:00 | Hi Pete, it is possible to add to the context menu but I believe it takes an API call so is a fair amount of coding to achieve. You could just record a macro for pastespecial and choose a shortcut key combo ensuring you click the Relative Reference button when in record mode so that it will work on any sheet. When you say in different places do you mean you need to find the next empty cell to paste to? If theres particular logic then I could write a macro that would automatically do it all for you. |
parry (27) | ||
| 281944 | 2004-10-17 10:45:00 | Another suggestion for you. Although, it doesn't give you a right click option. 1) Right click on the menu bar. 2) Choose customise 3) Click the Commands tab 4) Click Edit 5) In the right hand list box, navigate to Paste Values 6) Select-click Paste Values and drag ' n drop it onto a space part of the menu bar (for example, to the left of the help symbol) You should now be able to copy an entry, then go to your master sheet, then select the cell in the master sheet you want to place the data into and then click the Paste Values icon on the menu bar. All set. |
blank_harry (1661) | ||
| 1 | |||||