Indenting Shortcut
Indenting Shortcut
(OP)
Can anybody tell me the "Keyboard" shortcut for indenting text in a cell. i.e., I do not want to touch my mouse.
Thanks
Thanks
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Indenting Shortcut
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!
RE: Indenting Shortcut
TTFN
RE: Indenting Shortcut
Thanks
RE: Indenting Shortcut
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
RE: Indenting Shortcut
Good Luck
johnwm
RE: Indenting Shortcut
Alt Gr + Tab