In this post, we will show you, two easy methods on how to paste as transpose and keep formula/value references. But if there are formulas in the cells, the reference will change and mess up our desired values. I just thought maybe this would help you accomplish your goal instead of the change-on-hover thing.In Excel, the paste as transpose is extremely useful for transposing a column to a row or vice versa. 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. 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. 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. I don't know about changing on hover either but that would be cool. 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).

Where is transpose button in excel