Tag Archives: MS Office

How to Center Excel Headings without the Headache of Merged Cells

How to Center Excel Headings without the Headache of Merged Cells

By Marie McCooey

Merged cells in Excel worksheets can cause all kinds of problems when selecting columns, filtering, using PivotTables, etc.

Do you struggle with merged cells in your Excel worksheets?

If so, this post is for you.

When you need to center a report heading, it’s so tempting to select the cells and click the Merge & Center button directly above in the Alignment group of the Ribbon.

Merge and Center button

And this does result in the report title centered across the columns.

However, if you attempt to sort your data after applying Merge & Center alignment to the report title, the following message displays to remind you the report title is not just centered but merged and you will not be able to sort the merged data.

Merge Cell Sort Error

A Better Alternative to Centering an Excel Heading Across Multiple Columns

  1. First, type your heading in the left column of the row you want to center.Report Title
  2. Select the range of cells where the header should be centered across.
    Center Across Selection
  3. Press the Alignment drop-down arrow or press CTRL + 1 to open the Format Cells dialog box.
    The Format Cells Alignment tab displays.
  4. Click the Horizontal drop-down arrow, select the Center Across Selection option and click OK.
    ormat Cells Center Across Selection

    The Report title in the leftmost cell is centered across the selected columns.Center Across SelectionYou can now select each cell individually and sort the data without the aggravation of merged cells.

Notes:

  • For the Center Across Selection alignment to work, you can only enter data in the leftmost cell in the row.
  • To edit or format the report title, click in the leftmost cell of the row.

The next time you need to Center an Excel Report heading, remember Excel’s hidden Center Across Selection feature!

10 Word Selection Tips Everyone Should Know

10 Word Selection Shortcuts Everyone Should Know

By Marie McCooey

Let’s admit it.

Selecting text in Word can be tedious and slow.

Do you wish you knew a quicker way to select text to format, move, and delete?

In this post, you’ll learn 10 must-know Word mouse selection shortcuts to help you improve your selection speed. Continue reading

Discover hidden Word keyboard shortcuts

10 Word Keyboard Shortcuts to Help You Work Faster

By Marie McCooey

My Word class participants are always so eager and excited to learn keyboard shortcuts. They appreciate the time saved when they use keyboard shortcuts.

Discover these little-known Word keyboard shortcuts for yourself. Continue reading

Discover the Power of Excel’s Hidden Watch Window

By Marie McCooey

Do you find yourself endlessly scrolling through gigantic worksheets to check formula results?

Would you find it helpful if you could view the impact your changes have on the formula cells without the constant scrolling?

Excel’s little known tool, the Watch Window, allows you to monitor formulas or important cells in a separate window without continuously scrolling through enormous worksheets. Continue reading

Do You Struggle to Understand Complex Excel Formulas?

By Marie McCooey

You received an Excel file filled with long, complicated formulas that need updating by the end of the day.

You’re struggling to understand the difficult formulas. But you don’t want to ask for help and appear stupid.

Have you been in this predicament? Continue reading