Excel online training course

excel lesson 13, Worksheet tools

Selecting worksheets

When you open a workbook by default you have three worksheets.

To go from one worksheet to another we click on the tab of the worksheet you want to see.
When we added multiple worksheets, or when we gave worksheets a long name we are not able to see all of them anymore.
When this is happened we must use the firs, previous, next or last buttons to go from worksheet to another.
We can also rightclick on these buttons, a list will then appear with all our worksheets.

Selecting multiple worksheets

When we select multiple worksheets and make changes to one of the worksheets, these changes will be made in all selected worksheets.
We can select adjacent worksheets by clicking on the first, hold down the "Shift" key on your keyboard and click on the last worksheet you want to select.
We can select multiple non adjacent worksheets by clicking on the first, hold down the "Ctrl" key on your keyboard and selecting the next worksheet(s).

To de-select worksheets we click on a worksheet that was not selected.
When we would have selected all worksheets we can de-select them by clicking on the tab which is not in bold text.

Adding and removing worksheets

A time will come that we want to add or remove worksheets from a workbook.
To add worksheets, we first select worksheets (the amount you select will be the amount of worksheets that will be added) and then click "Insert" and "Worksheet" in the menubar.
For example if you wish to add two worksheets, then you select two worksheets.
The new worksheets will appear on the left of the worksheet which is written in bold text.

To remove worksheets simply click the right mousebutton on the worksheet(s) you wish to remove and choose "Delete" in the dropdown menu.

Changing worksheet names

By default worksheets will be named "Sheet1", "Sheet2", etc.
We can change these names by double clicking the name of the worksheet and then enter the name you want it to have.
Its allowed to use allmost all characters in the name, even spaces.
Once you entered the name of your worksheet we push the "Enter" key on our keyboard.

Give worksheet tabs color (only for Excel 2003 and XP)

In Excel 2003 and XP its possible to change the color of the worksheet tabs.
To do this we rightclick the tab of the worksheet and we choose "Tab Color" in the dropdown menu.
In the "Format Tab Color" window that will open we choose the color we want.
When we are done here we click on "Ok".
To remove a color we repeat the same process but choose "No Color" on the top of the dropdown menu.

Switch to fullscreen

When we have very large worksheets it can be usefull to fill our entire screen with the worksheet.
One way to do this is to switch to "Full Screen Mode".
This view removes (visually) all toolbars from our form.
To switch to "Full Screen Mode" we click on "View" and "Full Screen" in the menubar.
To switch back to "Normal" view we repeat the same steps.

Splitting the screen

Excel gives us a usefull tool to view information from wide and long worksheets.
Its the possibility to split the Excel window in different smaller windows.
Each window will have its own scrollbars, horizontally and vertically to view the information in our worksheet in different sections.
For example, we can split a long worksheet so the headers and titles will stay visible while we scroll down to see the rest of our data.

To split a worksheet in two, we select the entire colomn or row where the title is and then click "Window" and "Split" from the menubar.

We can remove the split by either clicking on "Window" and "Remove Split" in the menubar.
Or by simply double clicking on the split itself.

Freezing windows

Another way to split worksheets is by "Freezing" windows.
This is allmost the same as splitting with the only difference is that a frozen windows does not have scrollbars.
To "Freeze" a window we select a colomn or row, just below the row or on the rightside of the colomn you would like to freeze.
Then click on "Window" and "Freeze Panes" in the menubar.
The information in the "Frozen Window" will not change when you are scrolling.
This is usefull when you want to keep seeing the colomn and row headers.
We can also freeze both colomn and row headers by selecting a cell instead of a colomn or row.

We can also remove the split by clicking on "Window" and "Unfreeze Panes" in the menubar.

Copy and Paste entire worksheets

We have the possibility to copy an entire worksheet in our workbook.
To copy entire worksheets we hold down the "Ctrl" key of our keyboard and then click and drag the tab of the worksheet we want to copy to the left or right and release the mousebutton on the location we want to see our copied worksheet.
When we do this the mousecursor will change into a "Paper" icon with a "+" character.

We can also move our worksheets to the left or right to better organize our worksheets.
To do this we simply click and drag the worksheet(s) to the desired location.

Cut, Copy and Paste data to another worksheet

Its possible to cut, copy and paste data from one worksheet to another.
Just select the cell(s) you wish to copy or cut, click on the "Copy" button, or the "Cut" button in the standard toolbar.
Then select the cell where you would like to paste the data and click the "Paste" button.

Printing multiple worksheets

We can save time by printing multiple worksheets which are in the same workbook by selecting them all and then clicking on "File" and "Print" in the menubar.
This will open the "Print" window.

Make sure that the box next to "Active sheet(s)" is selected, you can also change some other options and when you are ready to print click on "Ok".

Hiding worksheets

We can hide worksheets by selecting the workshoot and click on "Format", "Sheet" and "Hide" in the menubar.
To make it visible again we repeat the process but then we choose for "Unhide".