How to Center Across Selection in Excel With Just One Click

Especially for headlines or table headings in Excel, merging cells is a great and fast way to center text across several cells. But merging cells comes with a few disadvantages. So, many professionals recommend using “Center Across Selection” instead. Unfortunately, the option is a little bit hidden. Here is how to apply it and how… Continue reading How to Center Across Selection in Excel With Just One Click

How to Trim Values Without Formula in Excel: Just One Click!

Your lookup (for example VLOOKUP) does not work? It cannot find results although it should? In such case, your values might have too many space characters: Leading space characters might still be visible, as well as double space characters in the middle of a text. But trailing spaces at the end of a text are… Continue reading How to Trim Values Without Formula in Excel: Just One Click!

How to Return the Column Letter (Not Number) With Excel Function

There are a few cases in Excel when you need to return the column letter from an Excel cell. For example, when you use the INDIRECT function. Retrieving the number of a cell is quite simple using the =COLUMN() function. But the letter? Here is how to do that! Summary In a hurry? Copy and… Continue reading How to Return the Column Letter (Not Number) With Excel Function

How to Change Proofing Language in the Whole PPT Presentation

Often, after working with Excel, you want to present your results in PowerPoint. The problem, especially when working internationally with different language settings involved: The proofing language often seems to have its own life. It’s often troublesome to continuously tell PowerPoint which language to use. Here are three simple (and two of them very fast)… Continue reading How to Change Proofing Language in the Whole PPT Presentation

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more