ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcuts for increase and decrease indents (https://www.excelbanter.com/excel-discussion-misc-queries/3892-shortcuts-increase-decrease-indents.html)

Vaughan

Shortcuts for increase and decrease indents
 
Hi,

I currently increase and decrease indents by clicking the appropriate
buttons on the Formatting toolbar. I'd like to use a shortcut key instead.
I don't see one listed in the shortcuts help document. Am I missing
something, or am I asking too much?

Vaughan

Earl Kiosterud

Vaughan,

You're asking too much. Put the following macros in a module. Probably
best in Personal.xls. You can copy them from here and paste them into the
module.

Sub IndentIncrease()
On Error Resume Next
Selection.InsertIndent 1
End Sub

Sub IndentDecrease()
On Error Resume Next
Selection.InsertIndent -1
End Sub

Now assign your desired keyboard shortcuts to the macros with Tools -
Macro - Macros - Options.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Vaughan" wrote in message
...
Hi,

I currently increase and decrease indents by clicking the appropriate
buttons on the Formatting toolbar. I'd like to use a shortcut key
instead.
I don't see one listed in the shortcuts help document. Am I missing
something, or am I asking too much?

Vaughan




HISNA

Shortcuts for increase and decrease indents
 
To increase indents : Ctrl + Alt + Tab
To decrease indents : Ctrl +Alt + Shift + Tab
Thanks.

"Vaughan" wrote:

Hi,

I currently increase and decrease indents by clicking the appropriate
buttons on the Formatting toolbar. I'd like to use a shortcut key instead.
I don't see one listed in the shortcuts help document. Am I missing
something, or am I asking too much?

Vaughan


jckimball

How do I keep the Ctrl+Alt+Tab from activating the Alt+Tab switching of windows in Windows 7?
I just want to activate the Increase Indent function, not switch to another application!

Quote:

To increase indents : Ctrl + Alt + Tab
To decrease indents : Ctrl +Alt + Shift + Tab
Thanks.


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com