And now you get the exact same look that you get with the Merge Cells, but you don't get the evilness. Horizontal, Center Ccross Selection like that, click OK.Īlright. Now you won't find that anywhere here on the Alignment tab, you have to go to either CTRL+1, or the Dialogue Launcher here. But instead, the good thing to do, is to use Center Across Selection. There are just all kinds of reasons why you don't want to use Merge Cells. And the reason why, we're selecting cells, we're selecting cells, we're selecting sales, BAM, we just selected 4 columns. Now first, let's Review alright, Merge Cells are completely evil, so if you use anything in this drop-down, any of these 4, well Unmerge Cells not, any of these 3, it is just bad bad bad bad bad, you never ever want to use any of those. Today's question came in from Twitter gdh316: how do you create a shortcut for Center Across Selection? Because if you did it macro, it would clear the undo stack, that would be bad. Hey, welcome back to the MrExcel netcast, I'm Bill Jelen. ![]() ![]() ![]() Learn Excel from MrExcel podcast, episode 1763 - Keyboard Shortcut for Center Across Selection! MrExcel podcast is sponsored by "Easy-XL"!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |