ADDITIONAL EXCEL MATERIAL

ADDITIONAL EXCEL MATERIAL - ADDITIONAL EXCEL MATERIAL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ADDITIONAL EXCEL MATERIAL Copying worksheets within a workbook and to other workbooks: Select the sheet tab which you want to copy by clicking on it>while holding the left mouse button down, hold the ALT key and drag the sheet to the location where you want to have a copy>you will see a small icon of a piece of paper with a + inside it (indicating that you are copying rather than moving the sheet)>when you see the black triangle in the location where you want the new copy of the sheet, let go of the ALT key and the mouse button (you have arrived)! 3 D Cell References: When you create a formula by accessing cells located in various sheets, it is called a 3D cell references. First you must select the sheets to include in the formula (function or formatting). To select adjacent sheets (those all in a row) select the first, then hold the Shift key and select the last. You will see that all sheets in between are selected. To select non-adjacent sheets, you must select each sheet while holding the Control key and
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

ADDITIONAL EXCEL MATERIAL - ADDITIONAL EXCEL MATERIAL...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online