Microsoft Excel Functions: Paste Special and Cell Comments (Part 2)
Explore “Paste Special and Cell Comments” in this Microsoft Excel Functions lesson. Part 2 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Dialog Boxes
- Activate any cell in the table.
- Pasting in Special Ways
- Paste Special Dialog Box
- Adding Comments to Cells
Contents
- Read the original document
- Dialog Boxes
- Activate any cell in the table.
- Pasting in Special Ways
- Paste Special Dialog Box
- Adding Comments to Cells
- Number-Formatting Keyboard Shortcuts
- Understanding Cells and Ranges
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Dialog Boxes
Dialog Boxes.
Activate any cell in the table.
Activate any cell in the table. Choose Insert ➪ Charts ➪ Column and then select one of the 2-D column chart types. Excel inserts the chart in the center of your screen. Creating a Chart
Pasting in Special Ways
Pasting in Special Ways Pasting Formats | Description Past (P) | Pastes the cell’s contents, formats, and data validation from the Windows Clipboard Formulas (F) | Pastes formulas, but not formatting. Formulas & Number Formatting (O) | Pastes formulas and number formatting only Keep Source Formatting (K) | Pastes formulas, and all formatting.
No Borders (B) | Pastes everything except borders that appear in the source range. Keep Source Column Width (W) | Pastes formulas, and also duplicates the column width of the copied cells
Paste Special Dialog Box
Paste Special Dialog Box
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Adding Comments to Cells
Adding Comments to Cells Choose Review ➪ Comments ➪ New Comment. Right-click the cell and choose Insert Comment from the shortcut menu. Press Shift+F2.
Number-Formatting Keyboard Shortcuts
Number-Formatting Keyboard Shortcuts Key Combination | Formatting Applied Ctrl+Shift+~ | General number format (that is, unformatted values) Ctrl+Shift+$ | Currency format with two decimal places (negative numbers appear in parentheses) Ctrl+Shift+% | Percentage format, with no decimal places Ctrl+Shift+^ | Scientific notation number format, with two decimal places
Ctrl+Shift+# | Date format with the day, month, and year Ctrl+Shift+@ | Time format with the hour, minute, and AM or PM Ctrl+Shift+! | Two decimal places, thousands separator, and a hyphen for negative values
Understanding Cells and Ranges
Understanding Cells and Ranges Address | Description C24 | A range that consists of a single cell. A1:B1 | Two cells that occupy one row and two columns A1:D4 | 16 cells (four rows by four columns). A6:XFD6 | An entire row of cells; this range also can be expressed as 6:6. A1:XFD1048576 | All cells in a worksheet. This range also can be expressed as either A:XFD or 1:1048576.
Review questions and answers
What are the key points about Activate any cell in the table.?
Activate any cell in the table. Choose Insert ➪ Charts ➪ Column and then select one of the 2-D column chart types. Excel inserts the chart in the center of your screen. Creating a Chart
What are the key points about Pasting in Special Ways?
Pasting in Special Ways Pasting Formats | Description Past (P) | Pastes the cell’s contents, formats, and data validation from the Windows Clipboard Formulas (F) | Pastes formulas, but not formatting. Formulas & Number Formatting (O) | Pastes formulas and number formatting only Keep Source Formatting (K) | Pastes formulas, and all formatting. No Borders (B)…
What are the key points about Adding Comments to Cells?
Adding Comments to Cells Choose Review ➪ Comments ➪ New Comment. Right-click the cell and choose Insert Comment from the shortcut menu. Press Shift+F2.
What are the key points about Number-Formatting Keyboard Shortcuts?
Number-Formatting Keyboard Shortcuts Key Combination | Formatting Applied Ctrl+Shift+~ | General number format (that is, unformatted values) Ctrl+Shift+$ | Currency format with two decimal places (negative numbers appear in parentheses) Ctrl+Shift+% | Percentage format, with no decimal places Ctrl+Shift+^ | Scientific notation number format, with two…
What are the key points about Understanding Cells and Ranges?
Understanding Cells and Ranges Address | Description C24 | A range that consists of a single cell. A1:B1 | Two cells that occupy one row and two columns A1:D4 | 16 cells (four rows by four columns). A6:XFD6 | An entire row of cells; this range also can be expressed as 6:6. A1:XFD1048576 | All cells in a worksheet. This range also can be expressed as either…
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Activate any cell in the table. should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.