Excel Environment – setting it up in Excel to personalise the experience you have

This week’s hint and tip is about setting up the ‘Excel Environment’. This is on our Basic Excel course and covers severalExcel environment: Excel icon​ options you can use to set it up. We are going to go through a few here that you can use on your computer.

 

QAT (Quick Access Toolbar) & creating your own Tab

First is the QAT (Quick Access Toolbar) within Excel. This little toolbar is found in the top left hand side of your screen within Excel. It is a feature that has been around for many years. Quite a few people use this toolbar but many don’t know they can customise it to their needs. You can add commands within Excel to this toolbar for quick and easy access to save you time flicking through multiple tabs.

Although the QAT is very useful, there is only so much space up there in the top left hand corner. So the next option we go through is creating your own Tab! This gives you a ‘much bigger QAT’ and allows you to create your own Tab with groups to add commands under. This is found by right hand clicking on a blank part of the ribbon and select ‘customise the ribbon’.

 

Splitting Your Screen

Finally we look at splitting your computer screen. This isn’t Excel specific and so can be used in any package or program on your computer. This is a keyboard shortcut that allows you to split the screen with the window you have open with another open window. This allows you to have the 2 windows open but evenly split in half.

The video below shows you how to set up the ‘Excel Environment’ on your computer. These options can enable you to save time in your day to day use of it.

Take a look below at the video to find out more and then try it out on your own computer!

We hope you have enjoyed this hint and tip, why not take a look at our previous one on Conditional Formatting?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy