Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
Is there a hotkey to changing fontsize in Excel 2003/2007?
/Connor |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
Hi,
That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
I learned this way from this group:
TOOLSCUSTOMIZEFORMAT In the right side you will see a big "A" and small "A"( scroll if not seen), you can drag those two( one at the time) to any toolbar you desire, then later on when you need to bigsize or minimize a cell: just click on any of those A bottoms. "Shane Devenshire" wrote: Hi, That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
In Excel 2007 these buttons are there by default on Home ribbon in Font group.
You can also add the following macros, add shortcut keys (I use ctrl-m and ctrl-l) you want and use the keyboard to increase/decrease the font size Sub increaseFontSize() Selection.Font.Size = Selection.Font.Size + 2 End Sub Sub decreaseFontSize() If Selection.Font.Size 6 Then Selection.Font.Size = Selection.Font.Size - 2 Else MsgBox "Can not go below font size 6" End If End Sub "Lerner" wrote: I learned this way from this group: TOOLSCUSTOMIZEFORMAT In the right side you will see a big "A" and small "A"( scroll if not seen), you can drag those two( one at the time) to any toolbar you desire, then later on when you need to bigsize or minimize a cell: just click on any of those A bottoms. "Shane Devenshire" wrote: Hi, That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
Hi,
Regarding assigning Ctrl+L or is it Ctrl+i? In either case both are already Excel shortcut keys Ctrl+L is the create Table (List) command and Ctrl+i is the Italic shortcut key. If you want to assign a shortcut key Ctrl+Shift+I for increase and Ctrl+Shift+D for decrease are easy to remember and don't interfere with Excel's built-in shortcut keys. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: In Excel 2007 these buttons are there by default on Home ribbon in Font group. You can also add the following macros, add shortcut keys (I use ctrl-m and ctrl-l) you want and use the keyboard to increase/decrease the font size Sub increaseFontSize() Selection.Font.Size = Selection.Font.Size + 2 End Sub Sub decreaseFontSize() If Selection.Font.Size 6 Then Selection.Font.Size = Selection.Font.Size - 2 Else MsgBox "Can not go below font size 6" End If End Sub "Lerner" wrote: I learned this way from this group: TOOLSCUSTOMIZEFORMAT In the right side you will see a big "A" and small "A"( scroll if not seen), you can drag those two( one at the time) to any toolbar you desire, then later on when you need to bigsize or minimize a cell: just click on any of those A bottoms. "Shane Devenshire" wrote: Hi, That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
I use those keys because I never use them for the default purpose...
"Shane Devenshire" wrote: Hi, Regarding assigning Ctrl+L or is it Ctrl+i? In either case both are already Excel shortcut keys Ctrl+L is the create Table (List) command and Ctrl+i is the Italic shortcut key. If you want to assign a shortcut key Ctrl+Shift+I for increase and Ctrl+Shift+D for decrease are easy to remember and don't interfere with Excel's built-in shortcut keys. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: In Excel 2007 these buttons are there by default on Home ribbon in Font group. You can also add the following macros, add shortcut keys (I use ctrl-m and ctrl-l) you want and use the keyboard to increase/decrease the font size Sub increaseFontSize() Selection.Font.Size = Selection.Font.Size + 2 End Sub Sub decreaseFontSize() If Selection.Font.Size 6 Then Selection.Font.Size = Selection.Font.Size - 2 Else MsgBox "Can not go below font size 6" End If End Sub "Lerner" wrote: I learned this way from this group: TOOLSCUSTOMIZEFORMAT In the right side you will see a big "A" and small "A"( scroll if not seen), you can drag those two( one at the time) to any toolbar you desire, then later on when you need to bigsize or minimize a cell: just click on any of those A bottoms. "Shane Devenshire" wrote: Hi, That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hotkeys...
Thanks Shane!
Connor "Shane Devenshire" skrev: Hi, Regarding assigning Ctrl+L or is it Ctrl+i? In either case both are already Excel shortcut keys Ctrl+L is the create Table (List) command and Ctrl+i is the Italic shortcut key. If you want to assign a shortcut key Ctrl+Shift+I for increase and Ctrl+Shift+D for decrease are easy to remember and don't interfere with Excel's built-in shortcut keys. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: In Excel 2007 these buttons are there by default on Home ribbon in Font group. You can also add the following macros, add shortcut keys (I use ctrl-m and ctrl-l) you want and use the keyboard to increase/decrease the font size Sub increaseFontSize() Selection.Font.Size = Selection.Font.Size + 2 End Sub Sub decreaseFontSize() If Selection.Font.Size 6 Then Selection.Font.Size = Selection.Font.Size - 2 Else MsgBox "Can not go below font size 6" End If End Sub "Lerner" wrote: I learned this way from this group: TOOLSCUSTOMIZEFORMAT In the right side you will see a big "A" and small "A"( scroll if not seen), you can drag those two( one at the time) to any toolbar you desire, then later on when you need to bigsize or minimize a cell: just click on any of those A bottoms. "Shane Devenshire" wrote: Hi, That's a Word or PowerPoint thing. The best you can do in Excel 2003 is press Ctrl+Shift+P which puts you in the point size drop down on the toolbar, then you can either type the value you want and press enter or press the down or up arrows, or press F4 to open the whole list. Unfortunately it's slightly more complicated in 2007. You can use Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or you can use Alt+H+FS to reach the Font Size drop down on the ribbon. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Connor" wrote: Is there a hotkey to changing fontsize in Excel 2003/2007? /Connor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extend formula hotkeys? | Excel Discussion (Misc queries) | |||
assigning hotkeys | Excel Discussion (Misc queries) | |||
Disable Hotkeys | Excel Discussion (Misc queries) | |||
Add the Superscript and subscript hotkeys to excel that currently. | Setting up and Configuration of Excel | |||
Do macro shortcuts interfere with excel hotkeys? | Excel Discussion (Misc queries) |