ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   short cut key reqired (https://www.excelbanter.com/excel-worksheet-functions/176516-short-cut-key-reqired.html)

Anil showreddy

short cut key reqired
 
HI all,

Can you give me a shortcut key for
"move a selected sheet from one book to another book" and
"To increase or decrease the font size in cell"

Thankyou..
--
Anil showreddy

Gary''s Student

short cut key reqired
 
To increase the font size, insert the following sub:

Sub fontbump()
ActiveCell.Font.Size = ActiveCell.Font.Size + 1
End Sub

and assign CNTRL-e to it.


In general, if a shortcut key has not been assigned by default to some
action, you can create a macro to do the action and assign your own key to it.


--
Gary''s Student - gsnu200768


"Anil showreddy" wrote:

HI all,

Can you give me a shortcut key for
"move a selected sheet from one book to another book" and
"To increase or decrease the font size in cell"

Thankyou..
--
Anil showreddy



All times are GMT +1. The time now is 07:12 PM.

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