Forum home » Delegate support and help forum » Microsoft Excel Training and help » Versions

Versions

ResolvedVersion 2007

Wed 29 Jul 2009, 16:57 Delegate Emma said...

Emma has attended:
Excel Advanced course

Versions

how to send new version of Excel to people with old version?

Fri 31 Jul 2009, 10:27 Trainer Anthony said...

RE: versions

Hi Emma, thanks for your query. First, to clarify, are you trying to send an Excel 2007 spreadsheet to someone running Excel 2003 or earlier? You can ensure your spreadsheet is backwards compatible by clicking the Office button and then Save As and choose the Excel 97-2003 Spreadsheet option. Then users running earlier versions of Excel will be able to open your spreadsheet.

There is also a compatibility pack which users running earlier versions of Excel can download from Microsoft, which will allow them to open .xlsx spreadsheets.

Hope this helps,

Anthony

Thu 6 Aug 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Versions

Versions

RE: versions

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet