How to Make a Worksheet in Excel
(Ultimate Guide)

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

You might think that if you know a lot of useful functions, you know everything there is to know about Excel.

But there are some cool things you can do to the spreadsheets themselves, too!

We’ll take a look at some of the basics, like creating and deleting worksheets.

Then we’ll get into some of the more useful things you can do, like renaming and even coloring your worksheet tabs.

Enjoy the ultimate guide to making spreadsheets (+much more) in Excel 🙂

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

What is a worksheet?

Before we start doing things with worksheets, let’s make sure we’re all talking about the same thing.

workbook is an Excel file, while a worksheet is one of the spreadsheets in that file. A workbook can contain multiple worksheets.

If you want to see your worksheets, just look at the bottom of your Excel window:

worksheet-tabs

In this workbook, we have three worksheets: “Classes,” “Sales,” and “Thank you.”

To view any worksheet, click on the tab that contains the worksheet’s name:

change-worksheets

Creating a new worksheet

You probably know about the easiest way to add a new worksheet in your workbook: clicking the add worksheet button near the worksheet tabs:

new-worksheet-button

Click that button, and you’ll get a new worksheet with a name like “Sheet2” or “Sheet5.”

It will always be the right-most sheet in your workbook.

Kasper Langmann, Co-founder of Spreadsheeto
sheet2

If you want to insert a new sheet into the middle of your list of worksheets, click Insert in the Home tab of the Ribbon, and select Insert Sheet:

insert-sheet

This will create a new worksheet to the left of the sheet that you’re currently viewing.

You can also insert a new worksheet by right-clicking on any worksheet tab and selecting Insert…

insert-sheet-click

Then select Worksheet and click OK.

insert-menu

Renaming and deleting worksheets

“Sheet2” isn’t a very useful name, especially if you have a lot of sheets and can’t remember what’s on each of them.

Fortunately, you can rename a worksheet by right-clicking on the worksheet tab and selecting Rename.

rename-tab

To delete a worksheet, right-click on the name of the sheet and select Delete:

delete-sheet

Moving and copying worksheets

To move a worksheet to a different position within a workbook, click and drag the tab at the bottom of the screen:

move-sheet

You can also right-click the worksheet tab and select Move or Copy…

move-copy-sheet

Then select the sheet that you’d like it to appear before:

move-copy-menu

To copy the worksheet, check the Create a copy box.

You can also move a sheet between workbooks using the same method.

Here’s how to do that.

Kasper Langmann, Co-founder of Spreadsheeto

In the Move or Copy menu, you’ll notice that there’s a dropdown menu called To book:

move-copy-book

That menu defaults to the workbook that you currently have open.

However, you can choose another open workbook to move or copy your sheet from one book to another.

This is especially useful if you have forms or cover sheets saved—you can open them and insert them into another workbook in a flash!

Coloring worksheet tabs

Very large workbooks might have dozens of worksheets, and it’s difficult to keep track of that many.

One thing that can help is color coding your worksheet tabs.

Right-click on any tab, mouse over Tab Color, and choose a color.

tab-color

Now, when you click to another tab, you’ll see that the previous one has been colored:

colored-tab

Make your worksheets work for you

You might not give individual worksheets very much thought, but if you know how to work with them, there are some handy options.

By renaming, moving and copying, and coloring your worksheets, you’ll never have to spend tons of time searching for a lost worksheet tab again!