Global Excel Summit的动态

Ask any seasoned Excel user about their pet peeves, and inevitably merged cells will pop up. ? A merged cell is two or more combined using one of Excel’s merge options, found on the Home tab. The default is Merge & Center, which merges and centrally aligns the top leftmost value (blank cells are ignored). ? They seem harmless at first. After all, who wants to widen a column to fit excess text when you have data above or below it that doesn’t require the extra space? ? Aesthetics aside, merged cells disrupt the natural structure of a worksheet grid. This affects tasks like selecting ranges, copying and pasting, filtering, and sorting data. ? If you want to ditch the drawbacks of merged cells but keep the benefits, consider the alternative. ? Select a range, go to Alignment Settings (Ctrl + 1), and pick Center Across Selection from the Horizontal dropdown. ? Unfortunately, centering text vertically isn’t possible with this method, so if you must, use merged cells or avoid it altogether. ? Have merged cells been a bane for you? ? #ExcelerationThursdays #excel #microsoftexcel #globalexcelsummit