![]() ![]() There's actually an alternative and *MUCH, MUCH* easier work-around:įirst, some quick set-up. Since the macro can be assigned to a shortcut key, you end up with an easier shortcut than what has already been discussed. To use the macro, follow steps 1 through 3 as previously outlined, and then run the macro. ![]() The following is an example of such a macro. If you prefer a real shortcut key (only a single key press), then you will need to develop your own macro to paste only the format. The first displays the Context menu for the cells and the other uses the regular menu system. ![]() In step 4 you could also press Shift+F10 rather than Alt+E. This sequence displays the Paste Special dialog box and chooses to paste only the format. Select the cells to receive the format.Select the cell from which the format is to be copied.You can, however, use the following steps: Unfortunately, Excel doesn't provide a single shortcut key you can use for the Format Painter. He would find it much easier to use if there were a shortcut key instead. Let’s say we manipulate the above chart so it looks as follows.Fred loves to use the Format Painter, but doesn't like to use the mouse to use the tool. You can create a chart with exactly the same formatting at the original by using this fantastic shortcut. If you can’t copy the original chart there is a work around that is simple and easy to replicate. It can be frustrating when you spend a whole lot of time on formatting a chart so it is just right then you have to create a similar chart. So remember Control 1 (CTRL 1) is your friend when it comes to making a chart. This brings up the specific menu for the changes to be made to the chart element. A rule of thumb is to click on whatever element you want to change and press CTRL 1. Or you could create the format you wish from scratch. This will mean every chart in the future will have the specific formatting that you assign to the chart. To change the future format from the baseline chart above you could create a charting template and save that down as your default. ![]() I generally include the chart title in the Excel spreadsheet as I find I have more control over it as text in Excel. There is an example of how I would present the above below. I always change my charts to take the noise out o them. Excel instantly produces a chart for you to manipulate or present if you are good with the generic Excel chart produced. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |