Tutorials, videos, useful tips for Excel, Outlook and Google Sheets, page 21

How to remove all blank rows in Excel

In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading

How to create / update a table of contents in Microsoft Word

If you are a document writer, this article will be very useful for you. You will learn how to insert a table of contents into your document, modify and update it just in a few clicks. Also, I’ll show you how to make your document look good using Word’s built-in heading styles and the multilevel list option. Continue reading

How to avoid automatic data formatting in Excel

Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading

Enter multiple lines in a single Excel cell

When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is. Here is how you can insert more than one line into one cell on your worksheet... Continue reading

Get rid of "The file is corrupt and cannot be opened" in Excel

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your xls. file. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading