Indenting Shortcut 1

[Verner]

Can anybody tell me the "Keyboard" shortcut for indenting text in a cell. i.e., I do not want to touch my mouse.

Thanks

 

[onlyadrafter]

Hello,

I don't beleive there is one, as seen from the help file

To Press
Display the Style command (Format menu) ALT+' (APOSTROPHE)
Display the Cells command (Format menu) CTRL+1
Apply the General number format CTRL+SHIFT+~
Apply the Currency format with two decimal places (negative numbers appear in parentheses) CTRL+SHIFT+$
Apply the Percentage format with no decimal places CTRL+SHIFT+%
Apply the Exponential number format with two decimal places CTRL+SHIFT+^
Apply the Date format with the day, month, and year CTRL+SHIFT+#
Apply the Time format with the hour and minute, and indicate A.M. or P.M. CTRL+SHIFT+@
Apply the Number format with two decimal places, 1000 separator, and – for negative values CTRL+SHIFT+!
Apply the outline border CTRL+SHIFT+&
Remove all borders CTRL+SHIFT+_
Apply or remove bold formatting CTRL+B
Apply or remove italic formatting CTRL+I
Apply or remove an underline CTRL+U
Apply or remove strikethrough formatting CTRL+5
Hide rows CTRL+9
Unhide rows CTRL+SHIFT+(
Hide columns CTRL+0 (ZERO)
Unhide columns CTRL+SHIFT+)


Why not create your own macro and store it in the personal file, you can create a shortcut key yourself.



----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

 

[IRstuff]

It used to be much more straightforward, but you should still be able to record the indent and outdent commands as macros and then assign a keyboard shortcut to them

TTFN

 

[Verner]

Done - a 20second job via the wonderful world of Macros. Didn't know if there was already a predefined way.

Thanks

 

[johnwm]

Open VB editor (Under Tools|Macro)

Paste into the code window for This Workbook:

Sub Macro1()
Selection.InsertIndent 1
End Sub

Go back to the spreadsheet, Tools|macros, select Macro 1 and click on Options. This allows you to set the control key to fire the macro.

Good Luck
johnwm

 

[johnwm]

Sorry I'm a bit late!

Good Luck
johnwm

 

[ab123456]

Alt Gr + Tab