| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 43080 | 2004-03-02 20:15:00 | centre shortcut in excel | roofus (483) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 219708 | 2004-03-02 20:15:00 | Does anybody know a shortcut key for centering text in an excel worksheet. To be specific excel2000 thanks |
roofus (483) | ||
| 219709 | 2004-03-02 21:04:00 | The only way that I know of is to go into Excel's Tools>Options>Transition, put a tick in Transition Navigation Keys check box then use the Caret key ^ prior to typing in the text in the cell . Or, if your text is already typed hit F2>Home then type in the ^ . As you can see it is pretty long winded for formatting text already typed so I just use either the mouse and toolbar or the format painter to do the job in one fell swoop . Maybe the Excel gurus may have some better ideas . :-) |
Susan B (19) | ||
| 219710 | 2004-03-02 22:28:00 | I'm pretty sure that no direct shortcut key or key combination to centre text was included by the creators of Excel. I'm happy to be proved wrong tho'. To centre text I use one of the format toolbar options, or menu Format->Cells->Alignment. If I did it a lot I'd write a macro and assign a shortcut key to the macro. That's easy to do. You don't say if you want to centre the text horizontally or vertically or both. Which method would depend on which centreing you want to do. |
rugila (214) | ||
| 219711 | 2004-03-02 23:35:00 | I know of none for this function either but I have an idea Build a macro and asign a shortcut key to it |
beama (111) | ||
| 219712 | 2004-03-02 23:38:00 | thanks for the replys guys. Susan your hint was helpful and i will implement that technique, and as a backup i will have a macro that will do it, if i forget to put the caret at the front :-) |
roofus (483) | ||
| 219713 | 2004-03-03 00:26:00 | If you have the Formatting Toolbar displayed, a click on the grey box above row 1 and to the left of column A will select all cells, then click on the text centering icon on the Formatting toolbar will centre align all cells in the Worksheet. | Russell D (18) | ||
| 219714 | 2004-03-03 01:22:00 | > If you have the Formatting Toolbar displayed, > a click on the grey box above row 1 and to the left > of column A will select all cells, then click on the > text centering icon on the Formatting toolbar will > centre align all cells in the Worksheet. Thoe whole idea was though to not use the mouse and to centre only the selected cells. I have gone with the macro, i used susans idea to start off with, but i wasn't happy (or willing to learn) the new changes that transitional formatting option enabled. |
roofus (483) | ||
| 1 | |||||