From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Managing worksheets - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Finding and replacing data3m 12s
-
Freezing panes3m
-
(Locked)
Repeating row and column titles3m 34s
-
(Locked)
Creating multiple custom worksheet views5m 18s
-
(Locked)
Hiding or grouping rows and columns5m 31s
-
(Locked)
Managing worksheets7m 23s
-
(Locked)
Calculating formulas across worksheets6m 5s
-
(Locked)
-
-
-
-
-
-
-
-