Once you have the macro, you can assign it to a shortcut key or the Quick Access Toolbar. HorizontalAlignment = xlCenterAcrossSelection Doing this frequently within a worksheet can be a pain, but you can create your own tool to center information across whatever cells you've selected: You can, however, display the Alignment tab of the Format Cells dialog box and use the Horizontal drop-down list to choose Center Across Selection. There is no native tool on any ribbon tab that can perform this task. (This tool is available on the Home tab of the ribbon, in the Alignment group.) The problem with this tool is that it merges prior to centering, and you might not want any merged cells in your worksheet.įortunately, Excel includes the capability of centering information across a range of cells, without merging them. You cant sort a column with merged cells. In addition, not all cell formats stick once you unmerge a cell. Excel includes a handy tool that you can use to merge cells and center whatever is within those merged cells. For instance, Excel wont apply column formats to a merged cell unless you select all the columns that comprise the merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |