MS Excel 2010 shortcut keys

Shortcut Keys  Description
F2 ------Edit the selected cell.
F5-------Go to a specific cell.
F7-------Spell check selected text and/or document.
F11----------Create chart.
Ctrl + Shift + ; ----- Enter the current time.
Ctrl + ; ------------- Enter the current date.
Alt + Shift + F1 ----------------Insert New Worksheet.
Shift + F3 ---------- Open the Excel formula window.
Shift + F5--------------------Bring up search box.
Ctrl + A ------------- Select all contents of the worksheet.
Ctrl + B ------------ Bold highlighted selection.
Ctrl + I --------------Italic highlighted selection.
Ctrl + K ------------- Insert link.
Ctrl + U ---------------- Underline highlighted selection.
Ctrl + 5 ------------- Strikethrough highlighted selection.
Ctrl + P ------------ Bring up the print dialog box to begin printing.
Ctrl + Z------------ Undo last action.
Ctrl + F9-------------- Minimize current window.
Ctrl + F10 ------------ Maximize currently selected window.
Ctrl + F6 ------------- Switch between open workbooks / windows.
Ctrl + Page up --------- Move between Excel work sheets in the same Excel document.
Ctrl + Page down ------------Move between Excel work sheets in the same Excel document.
Ctrl + Tab ----------------- Move between Two or more open Excel files.
Alt + = -------------------  Create a formula to sum all of the above cells
Ctrl + ‘ --------------- Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! ------------- Format number in comma format.
Ctrl + Shift + $ ------------ Format number in currency format.
Ctrl + Shift + # ---------- Format number in date format.
Ctrl + Shift + % ---------- Format number in percentage format.
Ctrl + Shift + ^  ------------- Format number in scientific format.
Ctrl + Shift + @ ------------ Format number in time format.
Ctrl + Arrow key ---------- Move to next section of text.
Ctrl + Space ------------ Select entire column.
Shift + Space ------------- Select entire Row.

Comments

Post a Comment

Popular posts from this blog

The famous Vanilla story --

This is a weird but true  story ...  A complaint was received by the Pontiac Division of General Motors:  This is the second time I have written you, and I don't blame you for not answering me, because I kind of sounded crazy, but it is a fact that we have a tradition in our family of ice cream for dessert after dinner each night. But the kind of ice cream varies so, every night, after we've eaten, the whole family votes on which kind of ice cream we should have and I drive down to the store to get it.  It's also a fact that I recently purchased a new Pontiac and since then my trips to the store have created a problem. You see, every time I buy  vanilla ice cream, when I start back from the store my car won't start. If I get any other kind of ice cream, the car starts just fine.  I want you to know I'm serious about this question, no matter how silly it sounds: 'What is there about a Pontiac that makes it not start when I get vanilla ice cream, an
Read more

Convert fetchXML to SQL Query in MSCRM 4.0

If for some sane reasons if fetchxml needs to be converted to a SQL Query in MSCRM 4.0, it is possible. It actually requires the below DLL's which are avilable in the folder Server\setup Microsoft.Crm.dll, Microsoft.Crm.Platform.Server.dll and Microsoft.Crm.Reporting.dll The code looks as below : Microsoft.Crm.BusinessEntities.ExecutionContext myContext = new Microsoft.Crm.BusinessEntities. ExecutionContext (OrganizationId from the context); myContext.OnBeginRequest(UserId, false); Microsoft.Crm.Reporting.ReportQueryBuilder myreportQueryBuilderObj = new ReportQueryBuilder(); string Query = myreportQueryBuilderObj.BuildReportQuery(fetchXml, myContext); The query will be returned as string. The Query is not readable but it works, -:)
Read more

Grid Refresh Failed.

When user clicks on the columns which are of type "picklist" in an assocaited view, an error message will be thrown "Grid Refresh failed". The reason for this issues is the data corruption. All the values in picklist should have corresponding values in the stringmap table. If there are records with picklist values for which there is no corresponding values in the string map table, then the generic error will be shown. The grid will show "Grid Refresh failed.". In our case we have cleaned up the data to correct this problem. The way to find out all these records is,,, 1. Go to Advanced find. 2. Select the entity for which this error occurs. (For Ex: Account). 3. Select the column which is of type "picklist". 4. Select the operator as "Does not Equal". 5. In the pop up for selecting the picklist values choose all the values. 6. Click on Find. This query gives all the records which does not have valid picklist values in them. Updat
Read more