Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Indenting Shortcut 1
- Thread starter Verner
- Start date
onlyadrafter
Mechanical
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!
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!
- Thread starter
- #4
-
1
- #5
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
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
- Status
Similar threads
- Locked
- Question
