Microsoft Word 2013 - How to Underline with Spaces

In MS Word 2013, you cannot see any underlined spaces when type space bar on your keyboard with underlined font style. I didn't know that it was like this in Word 2007 or 2003 but it is in 2013 and makes users confusing because it doesn't work as it is expected.

It would be like this with just typing Space... So bothering!

We have to type Ctrl+Shift+Space (none-breaking space, what is that... why isn't the default space for underlining...) to see those underlines like the following.

It would be like this with typing Ctrl+Shift+Space.


Simple, but needed an extra effort to find out.

MS Office, very unkind.

MS Excel 2013 - How to apply a function to multiple cells & Excel shares its undo/redo history with all opened documents (workbooks, windows, worksheets whatever)

How to apply a function to multiple cells at once

You have one column (A) that have many cells filled with different values, and you want use a same function with that values and fill the results in the cells of a different column (B), probably next column.

Apply your function in B1 with using A1 as its parameter, got the result in B1? Then drag the right-bottom corner of B1 cell and drop it on BX which is the next cell of the A column's cell that has the last value you want to use as a parameter of your funciton.


How to add/subtract/multiply/divide in multiple cells at once
or
How to copy only Formulas/Values/Formats

The answer is ...

'Paste Special'

You have different values in A1:A20, and you want to do adding/subtracting/multiplying/dividing with a certain value but separately into/for all of A1:A20 values.

For example, you want to add '100' to A1:A20 independently, then type in 100 in any cell you wouldn't use in the future, and copy the cell, and then select A1:A20, right-click on the selection and expand the menu 'Paste Special' and click 'Paste Special' at the bottom again. (how poor this interface is ...)

Choose 'add' on the dialog and 'OK'. Done.

You can copy only functions, formats with this special paste without copying any values, or only values.


By the way, I found a terrible truth (in most case) that opened multiple Excel documents (or workbooks, or windows) share one undo/redo history, which is not convenient at all in many cases. Because the opened documents are managed by Excel application's one 'instance'; a computer term indicates one unit of processing, a.k.a 'process'. (One visible application may consist of one process or more processes. One process may have one thread or more threads.)

You can open a document as a new instance that has a independent undo/redo history by holding 'Alt' key before clicking the Excel icon on your Start menu or Taskbar (in Windows 7) and keep holding until you see a dialog asks about starting a new instance of Excel.

There should be a reason of that MS made Excel or other office applications like this, but as a light user, I couldn't find any benefit so far. Because of OneDrive cloud service?