Creating a Chart using the F11 Key
You can create an Excel chart quickly by selecting the data in the spreadsheet and then pressing the F11 function key. Below are the steps to complete this task.
- Enter the data in your spreadsheet
- Highlight the desired data and then press the F11 function key
- The chart will generate in a separate tab and it will be named Chart1
Filling Non-contiguous cells with the same text
If you want to fill multiple cells with the same text, but the cells are not together, you can select the cells, type in the text, and then press CTRL Enter.