Difficulty: Moderately Easy
Step1
Create a new spreadsheet by using the Ctrl+N keys. Ctrl+O displays the Open dialogue box so that you can open an already existing file. Use Ctrl+S to save your current file.
Step2
Print the spreadsheet by using the Ctrl+P keys. This will bring up the Print dialogue box so that you can pick your desired options and then print.
Step3
Execute the “Fill” commands by using Ctrl+D to fill down and Ctrl+R to fill right. When pressing this, highlight the cell with the formula to be copied and all the cells below it or to the right of it that need the formula. This will copy the formula and the formats from the original cell.
Step4
Open the delete dialogue box by using Ctrl+-. This will give you the option to shift the cells up or left when the cell is deleted and will also give the option to delete the entire column or row.
Step5
Insert cells by using Ctrl and the plus sign key on the number keypad. If your laptop doesn't have a number keypad, use Ctrl+Shift and the "+" sign at the top of the keyboard that shares the key with the equal (=) sign. Either shortcut brings up the Insert dialogue box and gives you the option to shift cells right or down or to insert a whole row or column.
Step6
Highlight the entire worksheet by pressing Ctrl+A twice. This is useful if you need to make a change to the entire worksheet or if you need to copy the entire worksheet to another spreadsheet.
