Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training excel vba - mark up sheets excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - Mark up sheets in excel with duplicate data

training excel vba - Mark up sheets in excel with duplicate data

ResolvedVersion Standard

Peter has attended:
Excel Introduction course

Mark up sheets in excel with duplicate data

How do you save the base layout to further sheets without copying the whole sheet onto a blank sheet. Say if you have 12 sheets and need to transfer the basics information for future input of data.

Thanks

RE: Mark up sheets in excel with duplicate data

You can save a template.

FILE > SAVE AS

Give the file a name, as you would a normal file,
Select the file type TEMPLATE (*.xlt)
Click OK


This saves the file as a template in a TEMPLATE directory, which is available from FILE > NEW, Templates on my computer. This templatye can be edited and then resaved if you have any fundamental changes.

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.