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

microsoft excel courses london - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Excel

microsoft excel courses london - Excel

ResolvedVersion Standard

MICHAEL has attended:
No courses

Excel

how do I make a spreadsheet a template which will saty the same/will not change wehn you add details.
cheers

RE: excel

Hi Michael,

Thanks for the question.

The first thing you must do is create a blank spreadsheet, or at least a spreadsheet in the form that is ready to receive data. When that is done you save it as a template. So Under the File option you go to Save As and use the drop down menu at the bottom and pick "Template" as file type.

Then come out of the template as that is your original.

Then to access a fresh copy go to the File menu, down to New and on your task pane you will see Templates>on my computer. There you can find a fresh copy of the template you just created.

Hope that helps

Tracy

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

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.11 secs.