To fulfill this step with a keyboard shortcut, check out. There are two options that I am aware of and both (unfortunately) require two steps. Option 1 • With a single cell selected, hit Shift + Space to select the row. • Hit Control + Shift + + (Plus Sign) to insert a row above the current row. Option 2 • With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row. • Hit Enter to accept the default of Shift Cells Down. If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row. This inserts a new empty row. To copy the row, you just need to hit Ctrl+ C between the steps one and two. Keyboard Shortcut to Lock Cells in Excel (Mac Office) February 28, 2009 34 Comments While using a Macbook for a period of time in 2013, I realised that there are some differences when using Mac Office and Windows Office. This way the content gets automatically pasted after step two. So, this option works great, but only if you're working within the same workbook. I ended up here because the 'Insert copied cells' option does not exist if you're trying to paste rows/cells from another workbook. The simplest workaround I found was to copy the rows or cells you want from the one workbook, then paste them in a new blank sheet of the workbook you want to ultimately insert them into, the re-copy them from that new sheet, right-click the location you want to insert them on the worksheet, and the 'Insert copied cells' option should now show up. Choose that, and you're done! Well, then it is an add-in that is causing your problem. For instructions on how to remove an add-in read here: You can probably safely ignore Analysis ToolPak and the Solver Add-in - they are part of the standard installation. Ditto for (if you have them installed) the Conditional Sum Wizard, Euro Currency Tools, Eurotool, and Lookup Wizard. So, uncheck any other add-ins you have, one at a time (make notes!) and then close Excel entirely. ![]() Restart in normal mode and see if the problem is fixed. If it is, the add-in you unchecked was causing it - otherwise, re-check the one you unchecked and try a different one. If there are no others, I would probably try Euro Currency Tools and Eurotool, unless you are using a European version of Office and Windows (since I am in the USA, I don't have those installed.). No, no templates - it's a pretty basic installation, though I do run with the Developer tab showing as I have written macros for several of my sheets (nothing very fundamental - just automated sorts, insert row plus copy down formulae, stuff like that). I have tried turning off the Developer tab, but the problem persists. I'll probably uninstall Excel then re-install from disk and see where that gets me. BTW I've just noticed your Experience level - hope it wasn't me (though suspect it may have been)! If so then Not Stupid - but this is a peculiar one! No matter how much I think I know, I always am finding people here who know more, so that Experience level seems to fit me well enough! (And I find people who know almost nothing about a program and then say they are 'Advanced' to be incredibly annoying.a little humility goes a long way.) But, no, this is just a strangeness that I can't even find other people on the web having. I mean, it could be some minor or odd thing like your mouse driver or who knows, too. Try installing a different mouse (even of a different type - say, a PS2 instead of a USB or whatever you are using) and see if that makes a difference.? Again, no dice (probably). I am using a laptop and the trackpad. Tried plugging in a USB mouse but got the same problem - the movement was fine, right-click brought up the context menu, but the 'Cut' and 'Copy' were still greyed out. Vendor info missing in quickbooks for mac. I DID notice, on loading Excel, a very quick message in the bottom right of the status bar. I think it was 'Loading Funcres.xlam, press ESC to cancel', but it's so fast I can't re-read it to check. On searching for this online, I think it's part of the Analysis Toolpak I installed yesterday, so probably not an issue. I'll try and find time to do the new install over the weekend - got to wind up for today now - and will let you know if that sorts it out, or if (dum, dum, DUM!) I've managed to baffle Techguy! Well, it's finally fixed: I thought you might like to know! First, I tried a Repair (an option from running Setup from the original Office 2007 disk). I logged in as another user (I inherited this computer from my late mother) and on that account it worked fine. Then my husband (who is quite bright really.) had a look online and suggested that I use Regedit to delete this registry key: HKEY_CURRENT_USER Software Microsoft Office 12.0 Excel Options (we actually renamed it Options.old). On restarting Excel, it restored default settings and all is now OK! A huge amount of hassle for a very minor problem - but it was IRRITATING!!!
0 Comments
Leave a Reply. |