Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Shortcut for centring whatever is in a cell?
Is there any keyboard shortcut for centring whatever is inside a
cell/selection of cells? For instance, in Word, "Ctrl E" will centre text on a line. Is there anything similar for Excel? |
#2
|
|||
|
|||
Shortcut for centring whatever is in a cell?
Don't think there's a built-in shortcut key,
but here's a play to set-up the centring for: CTRL+j (Try on a spare copy/new book) Press Alt+F11 (to go to VBE) Click Insert Module Copy and paste the sub CentreAcrossCells below into the whitespace on the right '--------- Sub CentreAcrossCells() If Selection.Cells.Rows.Count 1 Then GoTo Pop End If If Selection.Cells.Count = 1 Then Selection.Cells.HorizontalAlignment = xlCenter ElseIf Selection.Cells.Count 1 Then Selection.Cells.HorizontalAlignment = xlCenterAcrossSelection End If Pop: End Sub '--------- Press Alt+Q (get back to Excel) In Excel, press Alt+F8 Select "CentreAcrossCells" in the macro list Click "Options" Enter a "j" for the shortcut key OK Test it out. In any sheet: Select a single cell with text (say), press CTRL+j The text will be centred in the cell Select another cell with text and an empty cell just to the right of it, then press CTRL+j. The text will be centred across both cells Note that if you select more than one row, nothing will happen -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "SM" wrote in message ... Is there any keyboard shortcut for centring whatever is inside a cell/selection of cells? For instance, in Word, "Ctrl E" will centre text on a line. Is there anything similar for Excel? |
#3
|
|||
|
|||
Shortcut for centring whatever is in a cell?
Max wrote a great reply but the short answer is that there is no shortcut key
sequence. I just use the center button on my formatting toolbar. :) Good luck, Pamela :) "Max" wrote: Don't think there's a built-in shortcut key, but here's a play to set-up the centring for: CTRL+j (Try on a spare copy/new book) Press Alt+F11 (to go to VBE) Click Insert Module Copy and paste the sub CentreAcrossCells below into the whitespace on the right '--------- Sub CentreAcrossCells() If Selection.Cells.Rows.Count 1 Then GoTo Pop End If If Selection.Cells.Count = 1 Then Selection.Cells.HorizontalAlignment = xlCenter ElseIf Selection.Cells.Count 1 Then Selection.Cells.HorizontalAlignment = xlCenterAcrossSelection End If Pop: End Sub '--------- Press Alt+Q (get back to Excel) In Excel, press Alt+F8 Select "CentreAcrossCells" in the macro list Click "Options" Enter a "j" for the shortcut key OK Test it out. In any sheet: Select a single cell with text (say), press CTRL+j The text will be centred in the cell Select another cell with text and an empty cell just to the right of it, then press CTRL+j. The text will be centred across both cells Note that if you select more than one row, nothing will happen -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "SM" wrote in message ... Is there any keyboard shortcut for centring whatever is inside a cell/selection of cells? For instance, in Word, "Ctrl E" will centre text on a line. Is there anything similar for Excel? |
#4
|
|||
|
|||
Shortcut for centring whatever is in a cell?
"pameluh" wrote:
... I just use the center button on my formatting toolbar. :) Hey, clicking with the mouse doesn't count ! It must be only keystroke(s) <g -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Shortcut for wrap text or vertical center in cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |