Blog

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

KEY DESCRIPTION
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.

How do I enable shortcut keys in Excel 2010?

Open Excel. Click on file, Options. Go to the Advanced tab….

  1. Open Excel.
  2. ALT+F11.
  3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window.
  4. Type “? application.StartupPath” without quotes and press enter.
  5. You will have your path below.

What is the shortcut key of Excel sheet?

Microsoft Excel Shortcut Keys

Shortcut Action
Shift+F11 Shift F11 New worksheet
Shift+F12 Shift F12 Save
Ctrl+F3 Ctrl F3 Define name
Ctrl+F4 Ctrl F4 Close

What is the shortcut key for Save As in Excel 2010?

Use the shortcut F12 to display the Save As dialog box in Excel. Press CTRL + s to save an existing workbook.

What is L Ctrl?

In Microsoft Word, Ctrl+L is used to left align a paragraph. Also referred to as Control L and C-l, Ctrl+L is a shortcut key that varies depending on the program being used. In Microsoft Word, Ctrl+L is used to left align a paragraph.

Why is Ctrl P not working?

If it is not assigned to that command, put the selection in the Press new shortcut key control and then press CTRL+P to assign it to that command. If CTRL+P is already assigned to that command, I think that the problem is probably something to do with your keyboard.

What is the function of Ctrl A to Z in Excel?

Ctrl + A → Select all content. Ctrl + Z → Undo an action. Ctrl + Y → Redo an action.

What is Ctrl H used for?

Excel shortcuts

Shortcut key Action Menu equivalent comments
Ctrl + H Replace Edit, Replace
Ctrl + I Italic Format, Cells, Font, Font Style, Italic
Ctrl + K Insert Hyperlink Insert, Hyperlink
Ctrl + N New Workbook File, New