It would be nice to simply select each remaining chart series and hit F4 rather than go through the gyrations of the formula bar, F9 and Enter, in order to make the entire chart object static. For example, if you select a series in a chart, you click into the formula bar and hit F9 and Enter, that will make that series static. Whether or not that happens is another story. When I was at Microsoft last month, I suggested that they expand their available uses for F4 in future versions. Then hit F4 as many times as you want to repeat the action of inserting a new sheet. ![]() Hit Shift+F11 (or, on the Home tab, Insert > Sheet). ![]() For example, on a version 2007 or later, open a workbook. Hello Ethan, thanks for your comment and for following my Excel blog.į4 does work in versions past 2003 but not with every single action as in 2003, and generally with limited actions anyway.
0 Comments
Leave a Reply. |