Soluții

How to Record a Macro in Excel

A macro is a code written in VBA (Visual Basic for Applications) that allows you to run a chunk of code whenever it is executed. When you record a macro, Excel closely watches the steps you’re taking and notes it down in a language that it understands – which is VBA.

And since Excel is a really good note taker, it creates a very detailed code (as we will see later in this tutorial). Now, when you stop the recording, save the macro, and run it, Excel simply goes back to the VBA code it generated and follows the exact same steps.

[mai mult...]

How to Lock Formulas in Excel

You can easily edit a formula through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. By default, all the cells are locked in Excel. Only when you protect the locked cells can you truly restrict the user from making changes. This also means that if a cell is not locked and you protect it, the user would be able to make changes.

[mai mult...]

Getting High CPU usage in Excel – How to Fix?

Excel is the most popular spreadsheet software available in the Microsoft Office package. It is easy to use and it provides many useful features. But recently, Windows users have been complaining that Excel is using too much CPU.

Here’s a list of possible reasons that can provoke Excel to use too much CPU.

  • Outdated Microsoft Office application
  • Corrupted Excel file
  • Interference by third-party applications
  • Problematic Add-ins

Now that you have become familiar with the issues behind high CPU usage of Excel, let’s move forward to the solutions to these issues.

[mai mult...]