How do you centre worksheet titles across a range of cells?

Answer 1

Select the cell (or cells) where you want to centre (uk english) the title, right click and select format>alignment and select centre under horizontal (or you can use the menu at the top by selecting format>cells to access the same options). If you have a group of cells (eg with a number of columns below them) and you want a word centred above all of them, type the word you want in the first cell on the left, then repeat the above process and make sure you tick the checkbox where it says "merge cells"

Answer 2

Type the text into the first cell you want the titles in. Then select it and the other cells you want to centre across. Then click on the Merge and Center button, or do it through the Alignment options under Format Cells, which can be accessed by pressing Ctrl - 1.