Macro List Ver 18

Goutam Sharma Macro List 18-May-06 Short Cut Ctrl+A Ctrl+B Ctrl+C Ctrl+D Ctrl+E Ctrl+F Ctrl+G Ctrl+H Ctrl+I Ctrl+J Ctrl+K Ctrl+L Ctrl+M Ctrl+N Ctrl+O Ctrl+P Ctrl+Q Ctrl+R Ctrl+S Ctrl+T Ctrl+U Ctrl+V Ctrl+W Ctrl+X Ctrl+Y Ctrl+Z

Name Select All Bold Copy Fill as Above GSBluTxt Find Go To Find and Replace Italics GSRdTxtBld Insert Hyper Link Create List GSPstLnk New Open Print GSBrdBlak Fill as Right Save Blank Underline Past Save and Close Cut Redo Undo

Type Excel Default Excel Default Excel Default Excel Default Macro Excel Default Excel Default Excel Default Excel Default Macro Excel Default Excel Default

Purpose

Blue Text

Red Text

Paste Link Excel Default Excel Default Excel Default Macro Excel Default Excel Default Excel Excel Excel Excel Excel Excel

Default Default Default Default Default Default

Grid Black

Format Thin

Short Cut Ctrl+1 Ctrl+2 Ctrl+3 Ctrl+4 Ctrl+5 Ctrl+6 Ctrl+7 Ctrl+8 Ctrl+9 Ctrl+0 Ctrl+. Ctrl+, Ctrl+' Ctrl+/ Ctrl+` Ctrl+Ctrl+; Ctrl+= Ctrl+[ Ctrl+] Ctrl+\

Name Short Cut to Format Cells Bold Italics Underline Strikethrough Display Place Holders for Objects Show /Hide Standard Tool Bar Show Outline Symbols Hide Row Hide Coloum

Deletes the contents of the cell and prepares the same for Editing Select the array containing the active cell. Show Formula Delete Cell/Row Similar to Edit>Delete Insert Date Go to Precedents Go to Dependents In a selected row, select the cells that don't match the value in the active cell.

Type Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel

Purpose Default Default Default Default Default Default Default Default Default Default

Do a Grouping and then hide the group totally

Excel Default Excel Default Excel Default Excel Default Excel Default Excel Default Excel Default

5/18/2006 2343 2343

2343

Short Cut Ctrl+Shift+A Ctrl+Shift+B Ctrl+Shift+C Ctrl+Shift+D Ctrl+Shift+E Ctrl+Shift+F Ctrl+Shift+G Ctrl+Shift+H Ctrl+Shift+I Ctrl+Shift+J Ctrl+Shift+K Ctrl+Shift+L Ctrl+Shift+M Ctrl+Shift+N Ctrl+Shift+O Ctrl+Shift+P Ctrl+Shift+Q Ctrl+Shift+R Ctrl+Shift+S Ctrl+Shift+T Ctrl+Shift+U Ctrl+Shift+V Ctrl+Shift+W Ctrl+Shift+X Ctrl+Shift+Y Ctrl+Shift+Z

Name GSBrd3 GSBdr GSBrdr2 GSHdr2 GSEAlign GSPstFor GSHdr GSNrmTxt GSClr3 GSLAlign GSDiv GSNbr GSPstFor GSWPHdr GSRmvBrd GSRAlign GSEAlign GSCenterAcrossSelction GSWrp GSPstSpl GSGrnTxt GSRmvGrd GSPercnt GSClr2

Type Macro Macro Macro Macro Macro Excel Default Macro Macro Blank Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro Macro

Purpose Cloumn Grid Row

Border Border Border Hedder Format with Center Across Selection Center Align Short Cut to Fonts Clour Green Hedder Format Change font to "Trebuchet MS 10" Colour Light Yellow Left Align Division - use to divide one number with another Number Format Paste Formula Page Headder; Need to edit the macro to get the required fields. Removes border formats for the selected area Right Align Center Across Selection Tan Colour Wrap Text Paste Values Greeen Text Remove Grid view Percent Format Pale Colour

Short Cut Ctrl+Shift+` Ctrl+Shift+1 Ctrl+Shift+2 Ctrl+Shift+3 Ctrl+Shift+4 Ctrl+Shift+5 Ctrl+Shift+6 Ctrl+Shift+7 Ctrl+Shift+8 Ctrl+Shift+9 Ctrl+Shift+0 Ctrl+Shift+[ Ctrl+Shift+] Ctrl+Shift+\ Ctrl+Shift+. Ctrl+Shift+, Ctrl+Shift+' Ctrl+Shift+/ Ctrl+Shift+` Ctrl+Shift+Ctrl+Shift+ Ctrl+Shift+=

Name Type General Numbr Format Excel Number Format Excel Time Format Excel Date Format Excel Default Currency Format Excel Percentage Format Excel Power Format Excel Border Format Excel Select Box Excel Unhide Hidden Rows Excel Unhide Hidden Columns Excel Go to All the Precedents Excel Go to All the Dependents Excel In a selected column, select the cells that don't match the Excel value in the active cell. Copies the cell to theleft (similar to Ctrl+D) Excel Fill as Above Excel Fill as Above and let it edit Excel

Fills in Time Insert Cee/Row Funcion- Similar to Insert>Cell Menu

Default Default Default Default Default Default Default Default Default Default Default Default Default

Purpose 23423 123,123,123.00 12:00 AM 22-Apr-41 Rs.4,234 4.35E+04 3.53E+04 Border Format

Default Default Default Default

Excel Default Excel Default

7:01 PM

Goutam Sharma Revision History 10-Nov-06

Version No. Particulars 1 Border and Number Formats 1.1 GSBdr 1.2 GSNbr

Date 27-Dec-03

2 Colours and Alignment 2.1 GSClr Revision 03/07/2006 2.2 GSClr2 Revision 03/07/2006 2.3 GSClr3 Revision 03/07/2006 2.4 GSClrW - Removed 03/07/2006 2.5 GSRmvBrd 2.6 GSLAlign 2.7 GSRAlign 2.8 GSEAlign Updated Alignement macros 03/07/2006

28-Dec-03

3 Header Format 3.1 GSHdr

28-Dec-03

4 Wrap Unwrap 4.1 GSWrp - updated 03/07/2006 GSUnWrp - Removed - updated the function 4.2 in the GSWrp

30-Dec-03

5 Percent Wrap 5.1 GSPercnt

6-Jan-04

6 Text Format 6.1 GSWndg Removed since 6.2 GSNrmTxt

1-Dec-04

7 New Head and Border Formats 7.1 GSBrdr2 7.2 GSHdr2 7.3 GSCenterAcrossSelction

1-Dec-04

8 Removes Border 8.1 GSRmvGrd

1-Dec-04

9 Past Special Values 9.1 GSPstSpl

1-Dec-04

10 Want to devide by some amount?? well 10.1 GSDiv

1-Dec-04

11 Some New Borders 11.1 GSBrd3

1-Jan-05

12 To paset formulas 12.1 GSPstFor

1-Jan-05

13 Work Paper Header 13.1 GSWPHdr

14-Feb-05

14 Border Format 14.1 GSBrdBlak

18-May-06

15 Text Colurs/Fence 15.1 GSBluTxt 15.2 GSRdTxtBld 15.3 GSFence - deleted 12/06/2006 16 Paste Link 16.1 GSPstLnk

15-Feb-05

15-Feb-05 23-Feb-05

17 New Color Texts 17.1 GSGrnTxt

3-Jul-06

18 New Work Paper Header 18.1 GSWPHdr2

5-Jul-06

Sub GSFence() ' ' GSFence Macro ' Macro recorded 15-02-2005 by Gautam ' ' Keyboard Shortcut: Ctrl+t '' ActiveCell.Select Range(Selection, Selection.End(xlToLeft)).Select Selection.RowHeight = 10 With Selection.Interior .ColorIndex = 5 .Pattern = xlSolid End With Range("I22").Select ActiveCell.SpecialCells(xlLastCell).Select Range(Selection, Selection.End(xlUp)).Select Selection.ColumnWidth = 1 With Selection.Interior .ColorIndex = 5 .Pattern = xlSolid Range("B1").Select End With End Sub