Did you know ... ?
You can view in Excel all existing formulas in the spreadsheet with a simple keyboard combination? It’s true!
There are times when you get a spreadsheet with calculations and formulas that do not seem to add up. Pressing Ctrl plus ` (the acute accent key found next to the number 1 on your keyboard) will show you all the formulas that exist in a spreadsheet. You can then make the corrections as needed then switch back to its normal view by using the same keyboard combination.
Now you know how to view all formulas in a spreadsheet with a keyboard combination. :)
Note: If pressing the keyboard combination does not show you any formulas, the calculations may have been manually entered so don’t be alarmed. It just means that spreadsheet doesn't have formulas
No comments:
Post a Comment