From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Managing worksheets

Managing worksheets - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Managing worksheets

Excel files are known as workbooks for a very good reason I think. I like to think of a workbook as like a three ring looseleaf binder because when you think of a looseleaf binder, you have all these sheets and you can rearrange the order of the sheets, you can add sheets, remove sheets, rename them, copy them. Well, you could do all that here in Excel. Down here on bottom is where we have our sheets and by default Excel gives you three sheets in a new workbook. But you're not limited to that. You can have as many sheets as you want. It's limited only by memory and there's no way you are ever going to run out of memory for worksheets. You have to have at least one sheet in the workbook, which kind of makes sense. So in this movie I want to show you a little bit about managing those worksheets. Right now, we have is Sheet1 and if you look at Sheet2 and Sheet3, they are empty. We haven't put anything in there yet. Well, let's say we want to change this to different regions. Maybe this…

Contents