Microsoft Excel Guide: Charts, Printing and Keyboard Shortcuts (Part 5)
Explore “Charts, Printing and Keyboard Shortcuts” in this Microsoft Excel Guide lesson. Part 5 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
- CREATING CHARTS
- FREEZING PANES
- When printing a worksheet you have a few options.
- You can select “Print Area,” which allows you to only print a highlighted area.
- KEYBOARD SHORTCUTS
Contents
- Read the original document
- Notice that the Chart toolbar appears when you insert a chart. You can edit the charts properties at any
- CREATING CHARTS
- FREEZING PANES
- When printing a worksheet you have a few options.
- You can select “Print Area,” which allows you to only print a highlighted area.
- KEYBOARD SHORTCUTS
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 02: original teaching slides for this study series.
Notice that the Chart toolbar appears when you insert a chart. You can edit the charts properties at any
Notice that the Chart toolbar appears when you insert a chart. You can edit the charts properties at any time.
CREATING CHARTS
CREATING CHARTS Step 3: Change chart options. Here you can name the chart and the axes, change the legend, label the data points, and many other options. Step 4: Choose a location for the chart.
FREEZING PANES
FREEZING PANES If you need the information in one column to freeze, while still being able to scroll through the rest of the data follow these instructions: Step 1: Highlight a specific column. Step 2: Go to the Window Menu and click “Freeze Panes.”
Step 3: The cells to the left of the highlighted column should be frozen while you are still able to scroll about the rest of the worksheet (Notice that column A remains while column H is next to it).
When printing a worksheet you have a few options.
When printing a worksheet you have a few options. You can go to “Page Setup” to change the features of your work (the margins, the paper size, the tabs, etc.) This will affect how your project will be printed.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
You can select “Print Area,” which allows you to only print a highlighted area.
You can select “Print Area,” which allows you to only print a highlighted area. You can preview your printing job by selecting “Print Preview.” Finally, you can print your job by going to the File Menu and selecting “Print,” or you can use the shortcut button.
KEYBOARD SHORTCUTS
KEYBOARD SHORTCUTS Here are some basic keyboard shortcuts: Shift + arrow key = highlight information CTLR + A = Select All CTRL + C = Copy Information CTRL + X = Cut Information CTRL + V = Paste Information CTRL + Z = Undo Information HOME = Move to the beginning of the worksheet
Review questions and answers
What are the key points about Notice that the Chart toolbar appears when you insert a chart. You can edit the charts properties at any ?
Notice that the Chart toolbar appears when you insert a chart. You can edit the charts properties at any time.
What are the key points about CREATING CHARTS?
CREATING CHARTS Step 3: Change chart options. Here you can name the chart and the axes, change the legend, label the data points, and many other options. Step 4: Choose a location for the chart.
What are the key points about FREEZING PANES?
FREEZING PANES If you need the information in one column to freeze, while still being able to scroll through the rest of the data follow these instructions: Step 1: Highlight a specific column. Step 2: Go to the Window Menu and click “Freeze Panes.” Step 3: The cells to the left of the highlighted column should be frozen while you are still able to scroll…
What are the key points about When printing a worksheet you have a few options.?
When printing a worksheet you have a few options. You can go to “Page Setup” to change the features of your work (the margins, the paper size, the tabs, etc.) This will affect how your project will be printed.
What are the key points about You can select “Print Area,” which allows you to only print a highlighted area.?
You can select “Print Area,” which allows you to only print a highlighted area. You can preview your printing job by selecting “Print Preview.” Finally, you can print your job by going to the File Menu and selecting “Print,” or you can use the shortcut button.
More lessons from this document
- Microsoft Excel – Presentation 02 — Part 1
- Microsoft Excel – Presentation 02 — Part 2
- Microsoft Excel – Presentation 02 — Part 3
- Microsoft Excel – Presentation 02 — Part 4
- Microsoft Excel – Presentation 02 — Part 5
Conclusion
The important points in When printing a worksheet you have a few options. 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.