Double-clicking on a sheet tab allows you to give it a descriptive name. You can change the order of the worksheets by dragging their tabs.
To copy worksheets press the Ctrl ke
English
Created by Last updated Thu, 16-Sep-2021
+ View more
Course overview
Double-clicking on a sheet tab allows you to give it a descriptive name. You can change the order of the worksheets by dragging their tabs.
To copy worksheets press the Ctrl key as you drag the tab. To select the same cells in consecutive worksheets, select the cells on the first worksheet, then press the Shift key and click on the tab of the last worksheet you require.
To select the same cells in worksheets that are not consecutive, press the Ctrl key as you select the tabs. When using formulas from different worksheets you need to specify which worksheet the data is in, as well as the cell address.
When the sheet name has a space, the whole name is enclosed in single quotes.
What will i learn?
Rearrange worksheets
Copy between worksheets
Select 3-D ranges
Group worksheets
Use multi-worksheet formulas
Requirements
Curriculum for this course
1 Lessons
40 mins
Office 2010 - Excel Intermediate - 3D Workbooks
1 Lessons
00:40:00 Hours
Office 2010 - Excel Intermediate - 3D Workbooks
Preview
00:40:00
+ View more
Other related courses
About instructor
Includes:
40 mins On demand videos
1 Lessons
Access on mobile and tv
Full lifetime access
Course preview:Office 2010 - Excel Intermediate - 3D Workbooks
