Microsoft Office Tutorials and References
In Depth Information
Generating a new workbook from an existing one
Generating a new workbook from an existing one
You can generate a new workbook from one that already exists by using the New from
Existing option on the Available Templates page. This comes in handy if you need to base a
new workbook on the format of one you have already completed. When you use this feature,
Excel makes a copy of the i le you want to use as your template. When it creates the copy,
Excel appends the number 1 to the end of the i lename to avoid overwriting the original i le.
Let’s create a vacation itinerary from a document that was once a weekly meal planner. Using
the existing document format saves time, by eliminating the need to create everything from a
blank document.
1
Launch Excel.
2
Click File > New > New from existing.
The New tab displays many options to start a new workbook such as; blank
workbook, recent template, sample template, or New from existing.
3
In the New from existing dialogue box, navigate to Oi ceLessons > Excel03lessons >
excel0301, and then click Create New. Notice how Excel names the i le excel03011.
Selecting cells
When you select a cell, you can apply changes to it. If you want to apply changes to multiple
cells at once, you need to select them all i rst. You can select one or multiple cells by using of
the following cell combinations:
IF YOU WANT TO SELECT…
THEN
A range of cells
Click the first cell in the range. Drag across the cells and release
the mouse button.
All cells in a worksheet
Click the Select Worksheet button (
) located between the row
and column headers.
Non-consecutive cells
Press and hold Ctrl while clicking cells.
Non-consecutive columns and
rows
Press and hold Ctrl while clicking column or row headers.
Multiple columns
Click and drag across column or row headers.
Search JabSto ::




Custom Search