![]() ![]() Moving the mouse to select "Yes" instead of the default "No" (default), results in another area being selected, which is then completely ignored! (The original selected area is extended to the source area size). If the destination area is smaller than the source area, you get a message warning that the clipboard area is larger. Mouse left click works fine so long as mouse over ANY of the selected cells (Otherwise area of formats are pasted onto same size, STARTING on the cell the mouse is over).ĭuring testing I found other problems using the mouse only: Paiter format shortcat excell how to#Select destination cells by keyboard - (? how to action Paintbrush) Select source cells by keyboard - start Format Paintbrush by assigned hotkey Select destination cells by keyboard - Paste Special by macro to change formats only by Ctrl+Alt+V (assigned hotkey). Select source cells by keyboard -Copy with Ctrl+C oops! mouse on not in selected area, so undo CTRL+Z, then try again, and again until ok Select destination cells with keyboard - move mouse over any of the selected cells - left click to action ![]() Select source cells with keyboard - move to mouse, double click Paintbrush icon However it does allow the use of Undo as follows: Paiter format shortcat excell plus#Plus us old guys can use keyboard much quicker and precisely than using the mouse.ĭouble clicking Paintbrush is an alternative, but requires a lot more work. Problem is shaking hand can result in mouse moving onto a different cell/row. Note: At least using the Mouse to action the Format Paintbrush does not delete comments - so I suppose I should be grateful. What I can't do is "Action" the Format Paintbrush on the destination cells by just using the keyboard - I have to press the left button of the mouse, while remembering to move the mouse cursor into the destination selection (it can be any of the cells)! I can select the source cells and start up Format Paintbrush, I can also select the destination cells (all just using the keyboard). So I would not only have to remember to press the unnecessary hotkey to reset the Paste Special options, but also remember to not do it on a cell that has a comment! Oh I could create another macro to copy a cell, Paste Special it back on itself with these options only, but this has also has the other annoying side effect of deleting any comment, even though the "Comments" option is not set! So how can I reset the Paste Special Options to Text/Numbers/Date? ![]() While this does what I wanted, it has the annoying side effect of leaving the Paste Special options changed. I have set up a macro to do the Paste Special - Formats only. Rem -ĭocument = ĭispatcher = createUnoService(".DispatchHelper")ĭim args1(5) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:InsertContents", "", 0, args1())Īnd you can paste (by this macro) the applied styles of the source cell range into the target cell range too. How would Cell Styles help? Would I not need to select each cell individually and then choose a style by the shortcut key assigned to it. What I was looking for was the keyboard equivalent of "do a mouse left click", which works fine. Plus when you want to use Paste Special for other uses, you then find all your usual defaults are changed - a real pain! Select cells to be formatted and Paste Special works, but as you say you have to switch off all the options you do not want and switch on "Formats". Select cells already formatted and Copy is the same as Select cells and Edit/Format Paint - same number of key-strokes. (1) Would a macro work when the cells to be selected / cells to be copied to can be any number of cells and can be anywhere? I find this option very useful as once you have set up formats, you can then copy them onto other cells without changing the contents. You might know it as "Format Painter" in Excel. When you select a group of cells, then click it with the mouse, the cursor changes from an arrow to a paint tin with paint pouring out of it. The "Format Paintbrush" is an icon on my toolbar that looks like a wide paintbrush. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |