43 excel 2007 menu wise shortcut keys
Post on 04-Apr-2018
253 Views
Preview:
TRANSCRIPT
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
1/31
C
ww
http://www.gencommerce.blogspot.com/ -
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
2/31
edit Goes to Miss Sukanya
Downloaded from
.gencommerce.blogspot.com
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
3/31
Alt + H Home Alt + N
Shortcut Key Function Shortcut Key
Alt + H + V Paste Alt + N +V
Alt + H + X Cut Alt + N +T
Alt + H + C Copy Alt + N +P
Alt + H + FP Format Painter Alt + N + FAlt + H + FF Change font Alt + N + SH
Alt + H + FS Change font size Alt + N + M
Alt + H +FG Increase font size Alt + N + C
Alt + H +FK Reduce Font size Alt + N + N
Alt + H +1 Bold Alt + N +E
Alt + H +2 Italics Alt + N + B
Alt + H +3 Underline Alt + N + A
Alt + H + B Borders Alt + N +D
Alt + H + H Fill colour Alt + N +O
Alt + H + FC Font Colour Alt + N +K
Alt + H + AT Top Align Alt + N + I
Alt + H + AM Middle Align Alt + N + X
Alt + H + AB Bottom Align Alt + N + H
Alt + H + AL Align Text Left Alt + N + W
Alt + H + AC Align Text Center Alt + N + G
Alt + H + AR Align Text Right Alt + N + J
Alt + H + FQ Orientation Alt + N + U
Alt + H + 5 Decrease Indent
Alt + H + 6 Increase IndentAlt + H + W Wrap Text
Alt + H + M Merge & Center
Alt + H + N Number Format
Alt + H + P Percent Style
Alt + H + K Comma Style
Alt + H + 0 Increase Decimal
Alt + H + 9 Decrease Decimal
HOME
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
4/31
Alt + H + L Conditional Formatting
Alt + H + T Format as Table
Alt + H + J Cell Styles
Alt + H + I Insert
Alt + H + D Delete
Alt + H + O Format
Alt + H + U Auto Sum
Alt + H + FI Fill
Alt + H + E Clear
Alt + H + S Sort & Filter
Alt + H + FD Find & Select
Alt + H + FO Clipboard
Alt + R Review Alt + W
Shortcut Key Function Shortcut Key
Alt + R + S Spelling Check Alt + W + L
Alt + R + R
Research like
Encyclopaedia,Dictionaries Alt + W + P
Alt + R + E Thesaurus Alt + W + I
Alt + R + L Translate into other language Alt + W + C
Alt + R + C New Comment Alt + W + E
Alt + R + D Delet Comment Alt + W + R
Alt + R + V Previous Comment Alt + W + VG
Alt + R + N Next Comment Alt + W + D
Alt + R + H Show/Hide Comment Alt + W + VF
Alt + R + A Show All Comments Alt + W + VH
Alt + R + I Show Ink Alt + W + Q
Alt + R + PS Protect Sheet Alt + W + J
REVIEW
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
5/31
Alt + R + PW Protect WorkBook Alt + W + G
Alt + R + W Share WorkBook Alt + W + N
Alt + R + O Protect and Share Workbook Alt + W + A
Alt + R + U Allow Users to Edit Ranges Alt + W + F
Alt + R + G Track Changes Alt + W + S
Alt + W + H
Alt + W + U
Alt + W + B
Alt + W+ VS
Alt + W + T
Alt + W + K
Alt + W + W
Alt + W + M
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
6/31
Insert Alt + P Page Layout
Function Shortcut Key Function
Insert Pivot Table Alt + P + TH Themes
Insert Table Alt + P + TC Theme Colours
Insert Picture from File Alt + P + TF Theme Fonts
Insert Clip Art Alt + P + TE Theme EffectsInsert Shapes Alt + P + M Margins
Insert SmartArt Graphic Alt + P + O Page Orientation
Insert Column Chart Alt + P + SZ Page Size
Insert Line Chart Alt + P + R Print Area
Insert Pie Chart Alt + P + B Breaks
Insert Bar Chart Alt + P + G Background
Insert Area Chart Alt + P + I Print Titles
Insert Scatter Chart Alt + P + SP Open Page Setup
Insert Other Charts Alt + P +W Shrink the print Width
Insert the Chart Wizard Alt + P + H Shrink the print Height
Insert Hyperlinks Alt + P + X Print % of actual size
Insert Text Box Alt + P +VG Gridlines View
Insert Header & Footer Alt + P + PG Gridlines Print
WordArt Alt + P + VH Headings View
SignatureLine Alt + P + PH Headings Print
Insert Object Alt + P + AF Bring to Front
Insert Symbol Alt + P + AE Send to Back
Alt + P + AP Selection pane
Alt + P + AA AlignAlt + P + AG Group objects
Alt + P + AY Rotate objects
INSERT PAGE LAYOUT
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
7/31
View Alt + L Developer
Function Shortcut Key Function
Normal View Alt + L + V
Launch the Visual Basic
Editor
PageLayout View Alt + L + PM Show the list of Macros
PageBreak View Alt + L + R Record a Macro
Customs View Alt + L + U Use Relative References
Full Screen Alt + L + AS
Customize the Macro
Security
View/Hide Ruler Alt + L +I
Insert Form Control,
ActiveX Controls
View/Hide Gridlines Alt + L +DM Turn or off Design Mode.
Insert Message Bar Alt + L + L
View or modify properties
for the selected controls.
View/Hide Formula Bar Alt + L + C
Edit the VB Code for a
control.
View/Hide Headings Alt + L + N Run a custom dialog box.
Zoom at your Desired % Alt + L + X Open the XML Task pane
Zoom 100% Alt + L + O
View or modify XML Map
properties
VIEW DEVELOPER
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
8/31
Zoom that your currently
selected areas fills the
entire window Alt + L + S
Manage the XML
Expansion packs.
Opens a new window
containing view of the
current document Alt + L + F
Refresh the XML Data in
the workbook.
Arrange the doc's that are
open side by side Alt + L + T Import an XML Data File.
Freeze panes Alt + L + E Export an XML Data File.
Split the window Alt + L + DP
Specify the type of
document information
panel.
Hide the current window
Unhide the currentwindow
View the windows side by
side
Synchronous scrolling of
windows (Activate the
previous function)
Reset Window Position
(Activiate "View Side by
Side" function)
Save Workspace
Switch windows
Use Macros
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
9/31
Alt + M Formulas Alt + A
Shortcut Key Function Shortcut Key
Alt + M + F Insert Function Alt + A + FA
Alt + M + U AutoSum Alt + A + FW
Alt + M + R Recently Used Alt + A +FT
Alt + M + I Financial Alt + A +FOAlt + M + L Logical Alt + A + X
Alt + M + T Text Alt + A + R
Alt + M + E Date & Time Alt + A + O
Alt + M + O Lookup & Reference Alt + A + P
Alt + M + G Maths & Trignometry Alt + A + K
Alt + M + Q More functions Alt + A + A
Alt + M + N Name Manager Alt + A + D
Alt + M + M Define Name Alt + A +S
Alt + M + S Use in Formula Alt + A + T
Alt + M + C Create From Selection Alt + A + C
Alt + M + P Trace Precedents Alt + A + Y
Alt + M + D Trade Dependents Alt + A + Q
Alt + M + A Remove Arrows Alt + A + E
Alt + M + H Show Formulas Alt + A + M
Alt + M + K Error Checking Alt + A + V
Alt + M + V Evaluate Formula Alt + A + N
Alt + M + W Watch Window Alt + A + W
Alt + M + X Calculation options Alt + A + L
Alt + M + B Calculate Now Alt + A + GAlt + M + J Calculate Sheet Alt + A + U
Alt + A + B
Alt + A + J
Alt + A + H
FORMULAS
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
10/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
11/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
12/31
Data
Function
From Access
From Web
From Text
From Other SourcesExisting Connections
Refresh All
Connections
Properties
Edit Links
Sort A to Z
Sort Z to Z
Sort
Filter
Clear
Reapply
Advanced
Text to Columns
Remove Duplicates
Data Validation
Consolidate
What - If Analysis
Outline Box
GroupUngroup
Subtotal
Show Detail
Hide Detail
DATA
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
13/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
14/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
15/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
16/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
17/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
18/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
19/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
20/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
21/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
22/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
23/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
24/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
25/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
26/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
27/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
28/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
29/31
-
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
30/31
Credit Goes to Miss Sukanya
Downloaded from www.gencommerce.blogspot.com
Get Latest Commerce News and Stuff from www.gencommerce.blogspot.co
http://www.gencommerce.blogspot.com/http://www.gencommerce.blogspot.com/ -
7/30/2019 43 Excel 2007 Menu Wise Shortcut Keys
31/31
top related