Hello, I was recently looking for a list of menu key tips in excel for a few friends of mine and also for myself. I could not find these tips. So I have tried to compile a list myself. I have pasted those tips below my signature. These may be helpful for beginners.
With best regards, Amiyo Biswas Cell: 6290527506 / 9433464329 Key Tips for Menus in Excel I have tried to compile here a list of key tips for menus and submenus of Microsoft Excel. It should work in Microsoft Excel 2007 and later versions. It will be especially useful for NVDA users and for those who do not or cannot use Jaws virtual ribbon menu. Please note that I could not find out key tips for many menu options. Obviously, it is not a comprehensive list. Please remember, 1. Heading styles have been applied to indicate the hierarchy structure of menus and submenus and to help navigation. 2. Key combinations interspersedwith plus (+) sign are to be pressed together. 3. Key combinations interspersed with comma (,) sign are to be pressed sequentially. Home Home: Alt, H Home / Clipboard Cut: Ctrl+X; Alt, H, X Copy: Ctrl+C; Alt, H, C Format Painter: Alt, H, F, P Home / Clipboard / Paste Paste (group): Alt, H, V Paste: Ctrl+V; Alt, H, V, P Formulas: Alt, H, V, F Paste Values: Alt, H, V, V No Borders: Alt, H, V, B Transpose: Alt, H, V, T Paste Link: Alt, H, V, N Paste Special...: Alt+Ctrl+V; Alt, H, V, S Paste as Hyperlink: Alt, H, V, H Office Clipboard...: Alt, H, F, O Home / Clipboard / Paste / Add Picture As Picture : Alt, H, V, A Copy as Picture...: Alt, H, V, A, C Paste as Picture: Alt, H, V, A, U Paste Picture Link: Alt, H, V, A, I Home / Styles / Conditional Formatting Highlight Cells Rules: Alt, H, L, H Greater Than...: Alt, H, L, H, G Less Than...: Alt, H, L, H, L Between...: Alt, H, L, H, B Equal To...: Alt, H, L, H, E Text that Contains...: Alt, H, L, H, T A Date Occurring...: Alt, H, L, H, A Duplicate Values...: Alt, H, L, H, D More Rules...: Alt, H, L, H, M Top/Bottom Rules : Alt, H, L, T Top 10 Items...: Alt, H, L, T, T Top 10 %...: Alt, H, L, T, P Bottom 10 Items...: Alt, H, L, T, B Bottom 10 %...: Alt, H, L, T, O Above Average...: Alt, H, L, T, A Below Average...: Alt, H, L, T, V More Rules...: Alt, H, L, T, M Data Bars : Alt, H, L, D Colour Scales : Alt, H, L, S Icon Sets : Alt, H, L, I More Rules...: Alt, H, L, I, M Clear Rules : Alt, H, L, C Manage Rules...: Alt, H, L, R Home / Styles / Format as Table Table Style Light / Medium / Dark (Grid) Alt, H, T New Table Style...: Alt, H, T, N New PivotTable Style...: Alt, H, T, P Home / Styles / Cell Styles Styles group: Alt, H, Z, S New Cell Style...: Alt, H, J, N Merge Styles...: Alt, H, J, M Home / Cells / Insert Insert Cells: Ctrl+Shift+=; Alt, H, I, I Insert Sheet Rows: Alt, H, I, R Insert Sheet Columns: Alt, H, I, C Insert Sheet: Shift+F11; Alt, H, I, S Home / Cells / Delete Delete Cells... (Delete rows, columns, or cells): Ctrl+-; Alt, H, D, D Delete Sheet Rows: Alt, H, D, R Delete Sheet Columns: Alt, H, D, C Delete Sheet: Alt, H, D, S Home / Cells / Format Row Height...: Alt, H, O, H AutoFit Row Height: Alt, H, O, A Column Width...: Alt, H, O, W AutoFit Column Width: Alt, H, O, I Default Width...: Alt, H, O, D Hide & Unhide: Alt, H, O, U Rename Sheet: Alt, H, O, R Move or Copy Sheet...: Alt, H, O, M Tab Color: Alt, H, O, T Protect Sheet...: Alt, H, O, P Lock Cell: Alt, H, O, L Format Cells...: Ctrl+1; Alt, H, O, E Home / Editing / Sum Sum: Alt+=; Alt, H, U, S Average: Alt, H, U, A Count Numbers: Alt, H, U, C Max: Alt, H, U, M Min: Alt, H, U, I More Functions...: Alt, H, U, F Home / Editing / Fill Down: Ctrl+D; Alt, H, F, I, D Right: Ctrl+R; Alt, H, F, I, R Up: Alt, H, F, I, U Left: Alt, H, F, I, L Across Worksheets...: Alt, H, F, I, A Series...: Alt, H, F, I, S Justify: Alt, H, F, I, J Home / Editing / Clear Clear All: Alt, H, E, A Clear Formats: Alt, H, E, F Clear Contents: Del; Alt, H, E, C Clear Comments: Alt, H, E, M Home / Editing / Sort & Filter Sort A to Z: Alt, H, S, S Sort Z to A: Alt, H, S, O Custom Sort...: Alt, H, S, U Filter: Ctrl+Shift+L; Alt, H, S, F Clear: Alt, H, S, C Reapply: Ctrl+Alt+L; Alt, H, S, Y Home / Editing / Find & Select Find...: Ctrl+F; Alt, H, F, D, F Replace...: Ctrl+H; Alt, H, F, D, R Go To...: Ctrl+G; Alt, H, F, D, G Go To Special...: Alt, H, F, D, S Formulas: Alt, H, F, D, U Comments: Alt, H, F, D, M Conditional Formatting: Alt, H, F, D, C Constants: Alt, H, F, D, N Data Validation: Alt, H, F, D, V Select Objects: Alt, H, F, D, O Selection Pane...: Alt, H, F, D, P Insert Insert: Alt, N Insert / Table / PivotTable PivotTable: Alt, N, V, T PivotChart: Alt, N, V, C Insert / / Illustrations Shapes: Alt, N, S, H Insert / Charts Column: Alt, N, C Line: Alt, N, N Pie: Alt, N, E Bar: Alt, N, B Area: Alt, N, A Scatter: Alt, N, D Other Charts: Alt, N, O Insert / Text WordArt: Alt, N, W Add Signature Services...: Alt, N, G, A Page Layout Page Layout: Alt, P Page Layout / Themes Themes: Alt, P, T, H Colours: Alt, P, T, C Fonts: Alt, P, T, F Effects: Alt, P, T, E Page Layout / Page Setup Margins: Alt, P, M Orientation: Alt, P, O Size: Alt, P, S, Z Page Layout / Page Setup / Print Area Print Area: Alt, P, R, S Clear Print Area: Alt, P, R, C Set Print Area: Alt, P, R, S Page Layout / Page Setup / Breaks Insert Page Break: Alt, P, B, I Remove Page Break: Alt, P, B, R Reset All Page Breaks: Alt, P, B, A Background...: Alt, P, G Print Titles: Alt, P, I Page Setup...: Alt, P, S, P Page Layout / Scale to Fit Width: Alt, P, W Height: Alt, P, H Scale: Alt, P, X Formulas Formulas: Alt, M Formulas / Function Library Insert Function...: Shift+F3; Alt, M, F AutoSum: Alt+= Sum: Alt, M, U, S Average: Alt, M, U, A Count Numbers: Alt, M, U, C Max: Alt, M, U, M Min: Alt, M, U, I More Functions...: Alt, M, U, F Recently Used: Alt, M, R Financial: Alt, M, I Logical: Alt, M, L Text: Alt, M, T Date & Time: Alt, M, E Lookup & Reference: Alt, M, O Math & Trig: Alt, M, G Formulas / Defined Names Name Manager: Ctrl+F3; Alt, M, N Define Name...: Alt, M, M, D Apply Names...: Alt, M, M, A Use in Formula: Alt, M, S Trace Dependents: Alt, M, D Paste Names...: F3; Alt, M, S, P Formulas / Formula Auditing Show Formulas: Ctrl+`; Alt, M, H Remove Arrows: Alt, M, A, A Remove Precedent Arrows: Alt, M, A, P Remove Dependent Arrows: Alt, M, A, D Create from Selection...: Ctrl+Shift+F3; Alt, M, C Evaluate Formula: Alt, M, V Watch Window: Alt, M, W Error Checking...: Alt, M, K, K Trace Error: Alt, M, K, E Circular References: Alt, M, K, C Formulas / Calculation Calculation Options: Alt, M, X Calculation Options / Automatic: Alt, M, X, A Calculation Options / Automatic Except for Data Tables: Alt, M, X, E Calculation Options / Manual: Alt, M, X, M Calculate Now: F9; Alt, M, B Calculate Sheet: Shift+F9; Alt, M, J Data Data: Alt, A Data / Get External Data >From Access: Alt, A, F, A >From Web: Alt, A, F, W >From Text: Alt, A, F, T >From Other Sources: Alt, A, F, O Data / Connections Connections: Alt, A, O Existing Connections: Alt, A, X Get External Data / Connections / Refresh All: Ctrl+Alt+F5 Properties: Alt, A, P Data / Sort & Filter Sort Smallest to Largest: Alt, A, A Sort Largest to Smallest: Alt, A, D Sort...: Alt, A, S Filter: Ctrl+Shift+L; Alt, A, T Reapply: Ctrl+Alt+L; Alt, A, Y Data / Data Tools Text to Columns...: Alt, A, E Remove Duplicates: Alt, A, M Data / Data Tools / Data Validation Data Validation... (split button): Alt, A, V Data Validation... (dialogue box): Alt, A, V, V Circle Invalid Data: Alt, A, V, I Clear Validation Circles: Alt, A, V, R Data / Data Tools / Data Validation / What-If Analysis What-If Analysis: Alt, A, W Scenario Manager...: Alt, A, W, S Goal Seek...: Alt, A, W, G Data Table...: Alt, A, W, T Consolidate...: Alt, A, N Data / Outline Group...: Shift+Alt+Right; Alt, A, G, G Auto Outline: Alt, A, G, A Ungroup...: Shift+Alt+Left; Alt, A, U, U Clear Outline: Alt, A, U, C Subtotal: Alt, A, B Hide Detail: Alt, A, H Group and Outline Settings: Alt, A, L Review Review: Alt, R Review / Proofing Spelling...: F7; Alt, R, S Research...: Alt+Click; Alt, R, R Thesaurus...: Alt, R, E Translate...: Alt, R, L Review / Comments New Comment: Shift+F2; Alt, R, C Edit Comment: Shift+F2; Alt, R, T Delete Comment: Alt, R, D Previous Comment: Alt, R, V Next Comment: Alt, R, N Show / Hide Comment: Alt, R, H Show All Comments: Alt, R, A Review / Changes Protect / Unprotect Sheet...: Alt, R, P, S Review / Changes / Protect Workbook Protect Workbook: Alt, R, P, W Protect Structure and Windows: Alt, R, P, W, W Unrestricted Access: Alt, R, P, W, U Restricted Access: Alt, R, P, W, R Manage Credentials: Alt, R, P, W, M Share Workbook...: Alt, R, W Protect and Share Workbook...: Alt, R, O Track Changes: Alt, R, G Allow Users to Edit Ranges...: Alt, R, U Allow Users to Edit Ranges...: Alt, R, U View View: Alt, W View / Workbook Views Normal: Alt, W, L Page Layout: Alt, W, P Page Break Preview: Alt, W, I Custom Views...: Alt, W, C Full Screen: Alt, W, E View / Show / Hide Ruler: Alt, W, R Gridlines: Alt, W, V, G Message Bar: Alt, W, D Formula Bar: Alt, W, V, F Headings: Alt, W, V, H View / Zoom Zoom...: Alt, W, Q 100%: Alt, W, J Zoom to Selection: Alt, W, G View / Window New Window: Alt, W, N Arrange All: Alt, W, A View / Window / Freeze Panes Freeze Panes (sub menu): Alt, W, F Freeze Panes: Alt, W, F, F Freeze Top Row: Alt, W, F, R Freeze First Column: Alt, W, F, C Hide: Alt, W, H Unhide...: Alt, W, U View Side by Side: Alt, W, B Synchronous Scrolling: Alt, W, V S Split: Alt, W, S Switch Windows: Alt, W, W Reset Window Position: Alt, W, T Save Workspace...: Alt, W, K View / Macros View Macros: Alt+F8; Alt, W, M, V Record Macro...: Alt, W, M, R Stop Recording: Alt, W, M, R Use Relative References: Alt, W, M, U Design Design: Alt, Y Design / Properties table Name: Alt, J, T, A Resize Table: Alt, J, T, I Design / Tools Summarise with PivotTable: Alt, J, T, V Remove Duplicates (from Table): Alt, J, T, M Convert (Table) to Range: Alt, J, T, G Design / External Table Data Design / External Table Data / Export Export (group): Alt, J, T, X Export Table to SharePoint List...: Alt, J, T, X, E Export Table to Visio PivotDiagram...: Alt, J T, X, X Design / External Table Data / Refresh Refresh: Alt+F5 Refresh (split button): F5; Alt, J, T, F, R Refresh All: Ctrl+Alt+F5; Alt, J, T, F, A Refresh Status: Alt, J, T, F, S Cancel Refresh: Alt, J, T, F, C Properties: Alt, J, T, P Connection Properties...: Alt, J, T, F, O Open in Browser: Alt, J, T, W Unlink: Alt, J, T, K Design / Table Style Options Header Row: Alt, J, T, O Total Row: Ctrl+Shift+T; Alt, J, T, T Banded Rows: Alt, J, T, R First Column: Alt, J, T, C Last Column: Alt, J, T, N Banded Columns: Alt, J, T, U Design / Table Styles Quick Styles: Alt, J, T, S Office Button New: Alt, F, N Open: Ctrl+O; Alt, F, O Save: Ctrl+S; Alt, F, S Office Button / Save As (split button)- Save As...: Alt, F, A Excel Workbook: Alt, F, F, X Excel Macro-Enabled Workbook: Alt, F, F, M Excel Binary Workbook: Alt, F, F, B Excel 97-2003 Workbook: Alt, F, F, 9 Open Document Spreadsheet: Alt, F, F, D PDF or XPS: Alt, F, F, P Other Formats: Alt, F, F, O Office Button / Print Print: Alt, F, W, P Quick Print: Alt, F, W, Q Print Preview: Alt, F, W, V Office Button / Prepare Prepare: Alt, F, E Properties: Alt, F, E, P Inspect Document: Alt, F, E, I Encrypt Document: Alt, F, E, E Office Button / Prepare / Restrict Permission Restrict Permission: Alt, F, E, R Unrestricted Access: Alt, F, E, R, U Restricted Access: Alt, F, E, R, R Manage Credentials: Alt, F, E, R, M Add a Digital Signature: Alt, F, E, S Mark as Final: Alt, F, E, F Run Compatibility Checker: Alt, F, E, C Office Button / Send Send: Alt, F, D E-mail: Alt, F, D, E E-mail as PDF Attachment: Alt, F, D, P E-mail as XPS Attachment: Alt, F, D, S Internet Fax: Alt, F, D, X Ofice button / Publish Publish: Alt, F, U Excel Services: Alt, F, U, S Document Management Server: Alt, F, U, D Create Document Workspace: Alt, F, U, C Close: Alt, F, C Excel Options: Alt, F, I Exit Excel: Alt, F, X -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/003601d9ea9b%24bd37c700%243fd3a8c0%40DESKTOPB4J2HVH.
