![]() I just thought maybe this would help you accomplish your goal instead of the change-on-hover thing. ![]() It's a little time-consuming to set up but I think worth the trouble, and it always makes a good impression on others who might use the sheet. You need to be sure you though that you include the reformatting of each of the other buttons back to the drab color you started with so they'll appear to be turned off when you're on another button. I like to use "From center" on the Gradiants tab in the Fill Effects so it looks like the active botton is being lit in the center. I'll then have the macros reformat the colors as I click on each one so that the one I last clicked on will be different from all the rest. How Do I Transpose Columns and Rows in Google Sheets Type TRANSPOSE( into the top left most cell you wish to transpose the data to Highlight the cells to. With a half dozen of them all lined up side by side, I'll usually format them with some drab color. I like to use the auto-shape that looks like a rectangular button a lot and add a little shadow to it for depth. I found that recording a color change into each macro when I click on it spares me any confusion. financial sector and thsi sector heavily relies on reporting in excel. On a somewhat related topic: If I have several macro buttons set up across the screen, I can sometimes get distracted and forget which macro I last clicked. It would be nice to have a TRANSPOSE button in reports that could flip the. To use the forms controls in Excel 2007, you must enable the. Select the Developer check box under Main Tabs on the right, and then click OK. To do this, follow these steps: Click File, and then click Options. I don't know about changing on hover either but that would be cool. To use the form controls in Excel 2010 and later versions, you have to enable the Developer tab. Just frame the current button with your cursor and choose a different shape. If you select "Draw" from the Drawing toolbar on the View menu you'll see there is an option to Change Auto Shape (I think it's down at the bottom left-hand corner of the screen).
0 Comments
Leave a Reply. |