![]() 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: 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. On your keyboard, key the command ATL + E + A + F.The "Format Paintbrush" is an icon on my toolbar that looks like a wide paintbrush.From the drop down menu of the Clear button, select Clear Formats.Select Clear from the Editing portion of the Home tab.Highlight the portion of the spreadsheet from which you want to remove formatting.Check out the video above and read the steps below to learn more. Here are three ways to quickly remove formatting from your spreadsheet. However, when the time comes when you need to share the spreadsheet with someone else who doesn’t need to see your annotations, for example, cleaning up your formatting could become a daunting task. Whether you’ve added a comment to a certain cell to call attention, or bolded the line items most important to remember, your annotations can help you parse through a spreadsheet. Formatting is a great way to annotate an Excel spreadsheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |