Four ways to improve your data presentation in Excel

Excel 2016 2013
Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an interactive application that will help you to represent the data more appealingly and conveniently.

   1.   Add a watermark text or a picture to the workbook with your company branding:

Watermark in Excel 365

See Adding watermarks to workbook for more details.

   2.   Add a background picture by choosing a graphics file to serve as a wallpaper for a spreadsheet like the wallpaper that you usually see on your Windows desktop:

background in Excel 365 spreadsheet

See Adding a background image to the spreadsheet for more details.

   3.   Use conditional formatting to highlight cells in the worksheet:

Example of Conditional Formatting Rule in Word 365

See Applying Conditional Formatting for more details.

   4.   Use the drop-down list to simplify entering a value from the predefined set like countries, states, types, etc.

Drop-down list in Excel 365

See Creating a Drop-Down List in a Cell for more details.

See also this tip in French: Quatre façons d'améliorer votre présentation de données dans Excel.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more