Excel Tip of the Day
Quickly apply or remove the merged cell format in Excel 2002
As in previous versions of Excel, the Formatting toolbar contains a Merge And Center button that enables you to quickly merge worksheet cells. Just select the cells you want to merge and click the button. Any text in the merged cells is centered within that range. What you might not know is that this button is now a toggle in Excel 2002. The same button can be used to remove the merged cell format, saving you from opening the Format Cells dialog box. To remove the merged cell format, click in any merged cell range then click the Merge And Center button. The centered format is removed in addition to the merged format.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.