Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl + ' (apostrophe) Tip Quiz What is the shortcut key to select the entire worksheet or the data-containing area? In Excel worksheet, if you have filled some formulas into a cell. And if you want to use those formulas again, but for the cell which is beneath them. You just only the 2 keys as the shortcut to operate it as the instruction as follows: Shortcut for: To fill cell formulas down and edit. Windows shortcut Ctrl ' To let you see more in the clear picture, take a look the figures describe all steps below: 👉 In the cell B2, it contains the formula syntax " =1+1" (Take a look the figure no. 1) Figure no. 1 Show the formula = 1+1 in cell B2 👉 In this step, pay attention to the cell B3. For this step, just press the 2 keys Ctrl + ' into the cell B3 and move your fingers out of them. Figure no.2 S...
Discover simple tips, tricks, and shortcuts to help you manage Excel more easily and boost your productivity.