Excel keyboard shortcuts 2010 windows#

If you are familiar with windows operating system, you should be aware of most of them. You can find more Excel 2010 hotkeysР’В on this Web page.MS Excel offers many keyboard short-cuts. Those are some of the handy Excel 2010 keyboard shortcuts. There you should click New, enter a title and then select a cell to add the title to. That opens the window below where you can add titles to Excel spreadsheet cells. Add Cell TitlesР”Р„dd more specific cell title references with the CtrlР’В + F3Р’В shortcut key. For percentage numbers, press the CtrlР’В + Shift + % shortcut key. The CtrlР’В + Shift + ! adds a number format with two decimal places to the cells. Switch the spreadsheetРІР‚в„ўs number format to currency by pressing CtrlР’В + Shift + $.

To apply a general number format to selected cell, you should press CtrlР’В + Shift + ~. You can also edit the spreadsheet number formats with shortcut keys. For example, if you format one cell with bold text the next selected cell also has bold formatting when you press F4. Pressing F4Р’В repeats the previous cell formatting to an alternative selected cell. When you format one cell you can then apply exactly the same formatting to another cell with a hotkey. From that window you can also click Format to open the cell formatting options. That opens the window below which provides details on selected cell style formatting. You can open the spreadsheet style dialog box by pressing Alt + РІР‚В hotkey. Press CtrlР’В + Shift + _ to remove the outline borders from cell selections. For example, pressing CtrlР’В + Shift + & applies an outline border for selected cells as below. Spreadsheet Formatting OptionsР”В®xcel has plenty of formatting options which you can accessР’В more directly with hotkeys. However, you can press CtrlР’В + ` to show all the cell formulas in the spreadsheet. To input a Sum formula, you should select a cell and press Alt + =.Р”В«y default Excel shows cellР’В formula values in cells and not cell formulas. That opens the Insert Function window below where you can choose from a variety of alternative formulas for the selected cell.

To insert a formula into a selected cell, press the Shift + F3Р’В hotkey. That adds the standard D/M/Y date format to the cell. Press CtrlР’В + to insert the current date in a selected cell. There is also a shortcut for adding current dates into Excel 2010 spreadsheets. That opens the paste dialog box below where you should select Text to add unformatted text to the spreadsheet. To paste content to Excel spreadsheets without text formatting, pressР’В CtrlР’В + Alt + V. However, that pasted content retains its formatting.

Insert and Edit DataР”В¬trlР’В + V is the standard keyboard shortcut for pasting clipboard content into other software. These are a few of the more notable hotkeysР’В for Excel 2010 spreadsheets. There are Excel hotkeysР’В for formulas, spreadsheet formatting, inserting and editing data and more besides. Excel 2010, like other MS Office applications, has plenty of keyboard shortcuts.

Excel keyboard shortcuts 2010