Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default shortcut key required...

hi can u give me a shortcut key for

1) To moving a worksheet from one book to another or in the same book
2) To increasing or decreasing fnt size in the cell.

thank you....
--
Anil showreddy
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default shortcut key required...

Enter the following macros:

Sub grow()
For Each r In Selection
r.Font.Size = r.Font.Size + 1
Next
End Sub


Sub shrink()
For Each r In Selection
r.Font.Size = r.Font.Size - 1
Next
End Sub

The assign CNTRL-e to one and CNTRL-f to the other.


CNTRL-e and CNTRL-f will increase/decrease the font size of the selected
cells.
--
Gary''s Student - gsnu200770


"Anil showreddy" wrote:

hi can u give me a shortcut key for

1) To moving a worksheet from one book to another or in the same book
2) To increasing or decreasing fnt size in the cell.

thank you....
--
Anil showreddy

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default shortcut key required...

Mr. gary,

its excellent.... thankyou ...

can you give me for another one also....?
--
Anil showreddy


"Gary''s Student" wrote:

Enter the following macros:

Sub grow()
For Each r In Selection
r.Font.Size = r.Font.Size + 1
Next
End Sub


Sub shrink()
For Each r In Selection
r.Font.Size = r.Font.Size - 1
Next
End Sub

The assign CNTRL-e to one and CNTRL-f to the other.


CNTRL-e and CNTRL-f will increase/decrease the font size of the selected
cells.
--
Gary''s Student - gsnu200770


"Anil showreddy" wrote:

hi can u give me a shortcut key for

1) To moving a worksheet from one book to another or in the same book
2) To increasing or decreasing fnt size in the cell.

thank you....
--
Anil showreddy

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Required Safi. Excel Worksheet Functions 2 December 31st 07 11:29 PM
Help required kiran New Users to Excel 1 September 1st 05 02:27 PM
Help required Sanjeev Excel Discussion (Misc queries) 1 August 25th 05 07:59 AM
VB Required?? Ket Excel Worksheet Functions 3 July 4th 05 07:32 PM
Help required...... Duncan Excel Discussion (Misc queries) 2 February 17th 05 10:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"