Microsoft Excel Training Home

How to improve the readability of your Excel worksheet data

Improving the readabilty of your Excel worksheet data can go a long way in avoiding errors in calculations or data analysis. How can we achieve this? You can use conditional formatting in combination wth the modulus function to highlight alternate rows or columns or apply different formatting to make the data more readable. You can also use the in-built table format feature. In this case you can only use pre-formatted colours and themes and your data gets converted into a table. Watch the training video and decide the method you would like to use to make your data more legible.








Reference

How to improve the readability of your Excel worksheet data