You have a couple (or many) cells with text in it. Now, you want to insert more text to them. Either at the beginning, in the middle or at the end. Here is how to easily do that!
Author: Henrik Schiffner
Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.
Delta ∆: How to Easily Insert Difference Sign “∆” in Excel
The capital Greek letter Delta (∆) stands for difference or increment in Mathematics. In some cases, it would also help to use it in Excel: Instead of writing “Difference” or “Change”, you could simply insert the Delta sign. Here is how to do that in Windows and Mac!
Ʃ: How to Easily Insert Sum / Total Sign “Ʃ” in Excel
You have created a nice dashboard in Excel? Or a beautiful Profit and Loss calculation? Now, you want to bring it to the next level: Insert the sum or total sign, the Greek character sigma: Σ. In general mathematics, uppercase Σ is used as an operator for summation. Here is how to quickly do this in Excel!
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!
Clear All: How to Delete Complete Excel Cell – Including Formatting!
When you press Del on the keyboard in Excel, the cell contents will be removed. However, often you also want to delete the formatting. That is called “Clear All” in Excel. Here is where to find the function and how to speed it up with keyboard shortcuts.
Fun in Excel: 6 Ways of Fun with Spreadsheets
Let’s have some fun in Excel! You probably do your work with spreadsheets, but there are also ways of having fun in Excel. In this article, we introduce you to 6 fun applications for Microsoft Excel.
How to Quickly Insert Check Mark Symbols in Excel Cell
When it comes to presenting your Excel results beautifully, you might want to use check mark (or tick ) symbols or (as the opposite) “x” characters. Here is how to quickly do that – either inserting them directly into cell or returning them from an Excel formula.
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
