What are the shortcut keys in Excel 2010?

What are the shortcut keys in Excel 2010?

A list of CTRL shortcut keys for Excel 2010

CTRL+SHIFT+” Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.

What is the Alt shortcut in Excel?

Once you start moving around a selection of data, make sure you hold the ALT key. This will enable you to switch between Excel WorkSheets while still holding the mouse key and moving data. Afterward, just point your cursor to a new location in a new worksheet where you want to paste the data.

What does Alt Hvv do in Excel?

Excel 2007 and later: Alt-H-V-V to Paste as Values. Excel 2010 and later: Alt-H-V-A to paste as Values and Number Formatting.

How do you Alt Hoa in Excel?

Use Alt-A-G-G to group, then Alt-A-H to collapse.

What is F4 in Excel?

F4 is a predefined keyboard shortcut in Excel that repeats your last command or action.

What are the keyboard shortcuts in Excel?

Workbook Shortcut Keys

  • To create a new workbook. Ctrl + N.
  • To open an existing workbook. Ctrl + O.
  • To save a workbook/spreadsheet. Ctrl + S.
  • To close the current workbook. Ctrl + W.
  • To close Excel. Ctrl + F4.
  • To move to the next sheet. Ctrl + PageDown.
  • To move to the previous sheet. Ctrl + PageUp.
  • To go to the Data tab. Alt + A.

What does Control Alt B do?

In Microsoft Word, pressing Alt + B opens the Acrobat tab in the Ribbon if Adobe Acrobat is installed. After pressing the shortcut, you’ll also have the option to press an additional key to select an option in the Animations tab. For example, after pressing Alt + B , you could press C to create a PDF.

What is the function of Alt D?

Alt+D is a keyboard shortcut most often used to select the URL in the address bar in Internet browsers.

What does Alt G do?

Alt+G is a keyboard shortcut most often used to access the Design tab in the Microsoft PowerPoint Ribbon.

What does Alt 9 do in Excel?

Frequently used shortcuts

To do this Press
Add borders. Alt+H, B
Delete column. Alt+H, D, C
Go to the Formula tab. Alt+M
Hide the selected rows. Ctrl+9

What is Alt OCA in Excel?

They are interchangeable. OCA is the old shortcut from XL 2003 and earlier’s Menu design, HOI is the new shortcut with Ribbon layout developed in 2007+. For compatibility, and so old timers didn’t have to relearn all the keyboard shortcuts, Microsoft allows the 2003 shortcuts to still work.

What is F12 in Excel?

F12 Key. “F12” key opens the “Save As” dialog box to save your current open excel workbook. You can also use “Alt + F2” for same output.