Tools

How to Use the TabStrip or Multipage Controls in Excel – Step by Step

You can also calculate or take the general average in Excel with formula , including addition, subtraction, multiplication and division, generate calendars, create a professional invoice from scratch with templates and even payroll. Besides all this you can also perform more complex operations.

This application is part of the office suite, and by 2016, more than 1.2 billion people were said to be using these applications. Therefore, 1 in 7 people in the world use some of these applications.

It is clear then that Excel is a well-known and recommended application in the field of spreadsheets. However, it is true that for someone who is starting to use it, it may not be so easy.

In this article you will learn some Excel tricks, including how to use the TaStrip or MultiPage controls, step by step.

Microsoft Excel tricks

Microsoft Excel settings green background

Excel has many different functions and shortcuts that some people do not know, therefore, in this post you will learn some of them.

For example, using the “Ctrl + T” buttons converts a selection of cells into a table. If you use “Ctrl + A” all cells in a document are selected.

With “Alt + F1” you can create a chart with a group of selected data. You can also enable or disable the autofilter using “Ctrl + Shift + L”.

If you want to calculate all the operations of all the worksheets, you just have to press the “F9” button. And to calculate only one operation, you must press “F9 + select part of a formula”.

If you press “Shift + F9” you can calculate the operations only of the current worksheet. And with “Alt + =” you can make a sum of all the selected cells.

These are just a few of the most basic Excel tricks. If you want to know how to easily encrypt or password an Excel file, this article may interest you.

How to use TaStrip or MultiPage controls in Excel step by step?

TaStrip or MultiPage controls in Excel

First of all, you need to know what these controls are. The TaStrip control can be compared to the tabs in a notebook or the labels in a group of file folders. This is used to define multiple pages for the same area of ​​a window or dialog box in your application.

A MultiPage element is a control that contains a collection of one or more pages. Each object in this control is a form that also contains its own controls and therefore can have a unique design.

Knowing what these controls are, now we will answer how to use them. Here we explain you step by step.

Step 1

First you need to have a UserForm or Excel form. This can be created by entering the “Developer tab” or “Developer” and selecting the “Visual Basic” option. Then you must right click on the “Project” tab and then select “UserForm”.

Step 2

After that, a blank form will appear from which you can add the elements that are considered necessary. Once there, press the option “View”, then “Toolbox” and then you must click on the icons of “Tab bar” and “Multiple page.” Once this is done, you will be able to see both controls in the UserForm tabs .

Step 3

To run it on your Excel page, you just have to click on the green arrow icon in the toolbar. The difference between the two controls is that in the TaStrip all the controls are interrelated, that is, when a Tab is selected, the entire set of controls is actually controlled.

But in MultiPage, each page is independent and each of the pages and controls can be edited . Therefore depending on what you want to do, you will have to choose one of those options. To know more about Excel you can go to the official website.

Leave a Reply

Your email address will not be published.

Back to top button