Excel Shortcut Keys Cheat Sheet: An Overview. In the next chapter you will learn about relative and absolute references. Are you tired of clicking through menus to find the command you need Learn how to save time and work faster by using Excel shortcut keys With this ultimate cheat sheet, you can quickly access all of the frequently used commands. Excel has pre-built functions, such as SUM. The fill function can be used to continue your formulas upwards, downwards and sidewards.

The formula updates the result if you change the value of cells, which is used in the formula. Values used in formulas can be typed directly and by using cells. It allows us to change values that are used by the formulas, and the calculations remain. Insert a New Worksheet: Click the Insert Worksheet button next to the sheet tabs below the active sheet. Notice that the formulas are doing calculations when we change the value in the cells, and the SUM is updated from 33 to 38. The value in cell B2 was changed from 2 to 7. Let's change a value to see what happens. Iva, Liam and Adora have 33 Pokeballs in total.

Great job! You have successfully calculated the SUM using the SUM function. Remember to delete the values that you currently have in E5. Note: You can navigate to the cells with your keyboard arrows instead of left clicking them. You will learn more about functions in a later chapter. The SUMįunction is one of the most used ones. Let's see how many Pokeballs Iva, Liam and Adora have in total.Įxcel has many pre-made functions available for you to use. Now we have counted the Pokeballs for all three Iva( 6), Liam( 12) and Adora( 15). That is cool, right? The fill function continued the calculation that you used for Iva and was able to understand that you wanted to count the cells in the next rows as well. Lets use the fill function to continue the formula, step by step: Now, let's help Liam and Adora with counting theirs.ĭo you remember the fill function that we learned about earlier? It can be used to continue calculations sidewards, downwards and upwards.

The values in row 2 B2(2), C2(3), D2(1) belong to her.ĭid you get the value E2(6)? Good job! You have helped Iva to count her Pokeballs.

Cheat sheet excel shortcuts