Shortcut keys - Ctrl + A to Z & Formatting Cell

Control Plus Shortcut Keys : From A to Z. 

Ctrl+A : Select all text

Ctrl+B  : Bold text.

Ctrl+C : Copy text

Ctrl+D : Open font formatting window

Ctrl+E  : Center text

Ctrl+F  : Find a phrase

Ctrl+G : Go to a specific page

Ctrl+H : Replace text with another text

Ctrl+I  : Italicize text

Ctrl+J : Justify text

Ctrl+K : Open insert hyperlink window

Ctrl+L : Left align text

Ctrl+M : Indent a paragraph from the left

Ctrl+N : Open new document or file

Ctrl+O : Open an existing document or file

Ctrl+P : Print a document

Ctrl+Q : Remove paragraph formatting

Ctrl+R : Right align text

Ctrl+S  : Save the document or file

Ctrl+T : Create a hanging indent

Ctrl+U : Underline selected text

Ctrl+V  : Paste any text or object that has been copied.

Ctrl+W : Close open tab in a browser or a document in Word.

Ctrl+X  : Cut text or object.

Ctrl+Y :  Redo any undo action.

Ctrl+Z : Undo any action.

Some common Ctrl + A to Ctrl + Z shortcuts in Microsoft Excel 2007

1.      Ctrl + A:

·        Syntax: Press and hold the "Ctrl" key, then press "A."

·        Usage: Selects all the data in the current worksheet or selected range.

2.      Ctrl + B:

·        Syntax: Press and hold the "Ctrl" key, then press "B."

·        Usage: Applies or removes bold formatting to selected text or cells.

3.      Ctrl + C:

·        Syntax: Press and hold the "Ctrl" key, then press "C."

·        Usage: Copies the selected cells or text to the clipboard.

4.      Ctrl + D:

·        Syntax: Press and hold the "Ctrl" key, then press "D."

·        Usage: Fills down the contents of the selected cell into the cells below.

5.      Ctrl + E:

·        Syntax: Press and hold the "Ctrl" key, then press "E."

·        Usage: Opens the Find and Replace dialog box.

6.      Ctrl + F:

·        Syntax: Press and hold the "Ctrl" key, then press "F."

·        Usage: Opens the Format Cells dialog box.

7.      Ctrl + G:

·        Syntax: Press and hold the "Ctrl" key, then press "G."

·        Usage: Opens the Go To dialog, which allows you to navigate to specific cells in your worksheet.

8.      Ctrl + H:

·        Syntax: Press and hold the "Ctrl" key, then press "H."

·        Usage: Opens the Replace dialog, enabling you to find and replace text within your worksheet.

9.      Ctrl + I:

·        Syntax: Press and hold the "Ctrl" key, then press "I."

·        Usage: Applies or removes italic formatting to selected text or cells.

10.   Ctrl + J:

·        Syntax: Press and hold the "Ctrl" key, then press "J."

·        Usage: Justifies the content of selected cells, adjusting the text alignment.

11. trl + K:

• Syntax: Press and hold the "Ctrl" key, then press "K."
• Usage: Opens the Insert Hyperlink dialog, allowing you to insert hyperlinks into cells or objects.

12. Ctrl + L:

• Syntax: Press and hold the "Ctrl" key, then press "L."
• Usage: Opens the Create List dialog for creating drop-down lists in Excel.

13. Ctrl + M:

• Syntax: Press and hold the "Ctrl" key, then press "M."
• Usage: Opens a new worksheet within the current Excel workbook.

14. Ctrl + N:

• Syntax: Press and hold the "Ctrl" key, then press "N."
• Usage: Opens a new Excel workbook.

15. Ctrl + O:

• Syntax: Press and hold the "Ctrl" key, then press "O."
• Usage: Opens an existing Excel workbook.

16. Ctrl + P:

• Syntax: Press and hold the "Ctrl" key, then press "P."
• Usage: Opens the Print dialog, allowing you to print the current worksheet.

17. Ctrl + Q:

• Syntax: Press and hold the "Ctrl" key, then press "Q."
• Usage: Closes Excel.

18. Ctrl + R:

• Syntax: Press and hold the "Ctrl" key, then press "R."
• Usage: Fills right the contents of the selected cell into the cells to the right.

19. Ctrl + S:

• Syntax: Press and hold the "Ctrl" key, then press "S."
• Usage: Saves the current Excel workbook.

20. Ctrl + T:

• Syntax: Press and hold the "Ctrl" key, then press "T."
• Usage: Converts a selected range into an Excel table.

21. Ctrl + U:

• Syntax: Press and hold the "Ctrl" key, then press "U."
• Usage: Applies or removes underline formatting to selected text or cells.

22. Ctrl + V:

• Syntax: Press and hold the "Ctrl" key, then press "V."
• Usage: Pastes the content from the clipboard into the selected location.

23. Ctrl + W:

• Syntax: Press and hold the "Ctrl" key, then press "W."
• Usage: Closes the active Excel workbook.

24. Ctrl + X:

• Syntax: Press and hold the "Ctrl" key, then press "X."
• Usage: Cuts the selected cells or text to the clipboard.

25. Ctrl + Y:

• Syntax: Press and hold the "Ctrl" key, then press "Y."
• Usage: Redo the last action (works in combination with Ctrl + Z for undo).

26. Ctrl + Z:

• Syntax: Press and hold the "Ctrl" key, then press "Z."
• Usage: Undoes the last action.

In Microsoft Excel 2007, you have several options for formatting cells. Here are some of the common formatting options:

1.      Font: You can change the font type, size, style (bold, italic, underline), and color of the text in a cell.

2.      Number Format: You can format numbers as currency, percentages, dates, and more.

3.      Alignment: You can align the text within a cell horizontally (left, center, right) and vertically (top, middle, bottom).

4.      Borders: You can add or remove cell borders and choose the style of borders (e.g., solid, dashed, dotted).

5.      Fill Color: You can change the background color of a cell.

6.      Cell Styles: Excel provides pre-defined cell styles that combine various formatting options for a consistent look and feel.

7.      Conditional Formatting: You can set up rules to automatically format cells based on their values or content.

8.      Protection: You can protect cells or worksheets to prevent them from being edited or to require a password for access.

9.      Number Styles: You can apply different number styles, like accounting or scientific notation.

10.  Text Formatting: You can control the text format, such as superscript or subscript.

11.  Cell Size: You can adjust the width and height of cells to control their size.

12.  Merge & Center: You can merge cells to create a single, centered cell for headings or labels.

These are some of the formatting options available in Excel 2007, and they can be accessed through the "Format Cells" dialog box or by using the options in the ribbon toolbar. The exact steps to access these options may vary slightly depending on the specific version of Excel 2007 and the user interface setup.