Make Office Better Personalise your spreadsheets

Excel’s cells are white with black borders, but there are other cell styles you can choose to breathe life into your spreadsheet.

To see these styles, highlight any data in your spreadsheet, click the ‘Cell styles’ dropdown menu in the Styles section of the Home tab, then move your cursor to one of the options to see how your data looks. If you don’t like any of these styles, it’s easy to create your own.

Click the New Cell Style button at the bottom of the Cell Styles dropdown menu, name your new style, then click the Format button in the Style window that opens. You’ll see six tabs in this window. The Alignment tab has options to align your cell’s text centrally or to the left (it’s to the right by default).

The Font tab lets you choose from several font types, styles, sizes and colours (see screenshot). The Border tab lets you add various border styles and colours, and the Fill tab lets you add colour within the cells. Click OK twice to confirm any changes you make.

To apply this style, select the relevant data, click the Cell Styles dropdown menu, then select your style’s name at the top.

Convert from one format to another

Peazip support lots of different archive file types and includes the useful ability to convert from one to another without you having to extract the contents first. For example, if you have a RAR or 7z file that you want to share with a friend but you’re not sure whether they’ll have a tool to extract its contents, you could convert it to a ZIP file (which Windows can extract without any extra tools). Locate your file in File Explorer, right-click it and select Peazip, then Convert. In the bottom pane of the window that opens, select the format you want to convert to – ZIP, for example – from the top dropdown menu, then click OK.