When you select a column header in Excel, all the cells in that column are selected. This means 65536 cells (the maximum number of rows in Excel). Similarly, if you select a row header, this will...
The text must be in the left hand cell. Select the range then 'merge and centre'.This can be achieved using the merge and centre tool from the toolbar/ribbon or from the format cells menu.Al