I am using Excel 2013 (32bit)
The shortcut of CTRL+SHIFT+> OR CTRL+SHIFT+< are not working. These now give me the effect of copy down or copy right.
Does anyone know of anyother shortcut, apart from the ribbon shortcuts?
I am using Excel 2013 (32bit)
The shortcut of CTRL+SHIFT+> OR CTRL+SHIFT+< are not working. These now give me the effect of copy down or copy right.
Does anyone know of anyother shortcut, apart from the ribbon shortcuts?
I've searched and experimented and it looks like this feature is not available in 2013 (see comments below)
I'm still hoping that there's an actual answer to this, but in the meantime I've put together a very rough macro to emulate the effect you're after (whether it's of use to you or to future readers).
At the moment this makes any selected range of cells bigger or smaller by one pt, but only if all cells are currently the same size.
You'll need to paste this into a module
--If you or anyone else doesn't know how to do this:
Sub MakeBigger()
'
'Makes selected cells' fonts bigger by one pt,
' only works if all selected cells have the same font size
'
' Keyboard Shortcut: Ctrl+w
'
Selection.Font.Size = Selection.Font.Size + 1
End Sub
Sub MakeSmaller()
'
'Makes selected cells' fonts smaller by one pt,
' only works if all selected cells have the same font size
'
' Keyboard Shortcut: Ctrl+w
'
Selection.Font.Size = Selection.Font.Size - 1
End Sub
Then go to Developer>Macros and Select each macro, pressing Options and adding the keyboard shortcuts there
Type Alt H FK on the cell for which you want to decrease the font size & Alt H FG to increase the font size