The merge and center formatting featured in Excel 2003 & 2007 is a handy option to quickly format titles and headings in Excel spreadsheets. It allows you to center titles evenly above your data by merging a number of cells into one and then centering the title/text in this one cell.
1. Highlight the cells you want to merge/center.
2. Right click your mouse, Format Cells
3. Click on Alignment.
4. Click on Horizontal, Center
5. Click the Merge Cells box
6. Click OK
You text is now centered over the data you requested. Using this Right Click format short-cut key, allows you to also, change the text type, size, style, format your numbers, add a border and fill in the cell with a color or pattern. Finding quick and easy ways to do things will always increase your productivity.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment