Office Solutions

How to Quickly Insert and Delete Line Breaks in Batch in Excel Cells

Now you can quickly insert line breaks in batch by using the shortcut keys and the find and replace feature. In our previous article 2 Quick Tips to Wrap Long Texts in Excel Cells so that All Contents are Visible, we have introduced two methods to wrap long text in Excel cells. Actually, if you use the “Ctrl + Enter”, you are also adding line breaks into cells. But you can only add for a cell each time. Here we will talk about insert and delete line breaks in batch. Insert Line...

Read more »

Sparkline – Mini Chart to Show Data Trends in Your Excel Worksheet

Chart in Excel will occupy a large area in Excel interface. Hence, you can use a tiny chart called sparkline to reflect the tendency of data instead. You can create a sparkline in a cell, and this graphic will not take up a large area in the interface. For example, now you need to display the tendency of the sales volume, you can use the sparkline in this worksheet. Add a Sparkline Click a cell where you want to put the sparkline. Next click the tab “Insert” in the ribbon. ...

Read more »

2 Methods to Insert Outlook Contact Info into a Word Document

When you’re writing a letter in Word and need to insert some contact info, how can you achieve it? Typing the information manually is too troublesome. This article will offer 2 handy methods. Actually, to insert Outlook contact information into a word document, there are several workarounds. If you only would like to insert the name and address of the contacts, making use of “Insert Address” feature directly in MS Word must be the best choice. But if you wish to insert more details,...

Read more »