Category Archives: Excel

How to enable macros in Excel

  1. Introduction
  2. Enabling macros
  3. Tl;dr
  4. Warning

Introduction

You might be using macros for work or something personal but regardless they can be immensely helpful. In this post I will show you how to enable them so that you can use them.

Enabling macros

Firstly open up Excel and navigate to and click on ‘File‘.

To show where file is on excel.
Click on ‘File‘.

Down the bottom of the list you want to click on ‘Options‘.

To show where options is on excel.
Click ‘Options‘.

Next you need to click ‘Trust Center‘ and then click on ‘Trust Center Settings‘.

To show where trust center and trust center settings are.
Click ‘Trust Center‘ and then ‘Trust Center Settings‘.

Now you need to click ‘Macro Settings‘ on the left and this is where you can choose which macro settings you would like, be careful here, as it says macros can contain potentially dangerous code to run so enable all macros at your own risk.

I personally would recommend against enabling all macros but if you’re sure the macro is safe e.g. you’ve made it yourself then enable it.

To show where macro settings are and the 2 options to enable them.
Choose which setting you would like/require.

Tl;dr

Go to File > Options > Trust Center > Trust Center Settings > Choose your macro settings.

Warning

Follow this guide at your own risk, we take no responsibility as macros can be used negatively by hackers to run dangerous code.

How to use cells from another sheet in your formula in Excel

  1. Introduction
  2. Example
  3. Tl;dr

Introduction

In todays post I will show you how to use a cell from another sheet in your spreadsheet, in your formula.

Example

In this example, I want to get the answer of cell A1 on page 1 added to the cell A1 on page 2 and display the answer in D10 on page 1, to do this I simply want to click the formula for D10 and type in ‘=A1+Sheet2!A1‘ as shown (A1 doesn’t need the ‘sheet‘ part as it’s on the same sheet as D10 but it can still be used).

As you can see above both of the A1 cells have 100 in them therefore D10 has returned the correct answer of ‘200‘, it’s as easy as that!

You can just follow the syntax of ‘Sheet1!‘ 1 being the required sheet number followed by the cell number e.g. Sheet2!B6, Sheet4!Y8 etc. You can string them together too and have as many as you want. Need to add 8 cells from 5 different sheets? Go for it.

Here is the result of a 4 page one, note the formula at the top.

To show the sum of the second example
The multiplication was 100+100*4-11 so it’s returned the correct result

And that’s all there is to it, you can also instead of typing the formula simply type ‘=‘ and then click the sheet you need followed by clicking the cell and it will put it in for you automatically.

Tl;dr

To sum up cells on different sheets simply follow the formula ‘Sheet1!A1+Sheet2!A1‘ and change the sheet, cell numbers and formula as necessary.