How to create dynamic main menu in Excel?

Maybe you didn't know it yet, but you can combine text and functions in 1 cell.

This technique is used a little less, but it can sometimes be very useful for certain applications.

In this example we are going to combine a total sum with the header text.

​

Chapters index :

00:00 Introduction

00:58 Start of composition

02:00 What is the & for?

02:45 Add function

03:06 What could be a problem with merging?

04:25 Align the text and function nicely

05:52 Repeat in another column

06:50 Testing and final decision

​

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.