Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



Remove line breaks in excel

Remove line breaks in excel

When you receive data from other systems into Excel, the cells often contain line breaks that can cause problems in other calculations. Alternatively some users know how to use the ALT ENTER option which creates line breaks within a cell. Either way, line breaks are seen as characters in excel and as a result you cannot compare 2 cells if one has a line break and the other doesn’t.

To fix this you can try one of 2 things.

  • At a simple level you can just click in the cell and delete the break but this is not very useful when you have thousands of cells.
  • So a way to do this is the use the CLEAN function (see video clip) to remove the line break. You would normally combine this with a TRIM function which removes unnecessary spaces as well.