note: in the example the entire title is typed into cell A1
| 1. Type the spreadsheet
title into a cell note: in the example the entire title is typed into cell A1 |
|
| 2. Format
the title note: even formated the entire title is still in cell A1 |
 |
| 3.
Select the range of cells
for centering your title note: in the example cells A1 through J1 are the selected range |
 |
| 4. Click the merge and center tool |  |
| 5. To undo
a centered merged title select the title
cell and click the merge and center tool note: your title will return to cell A1 |
 |