Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merge spreedsheet

Merge spreedsheet

ResolvedVersion 2003

Tue 7 Jul 2009, 16:21 Delegate Lisa said...

Lisa has attended:
Excel Advanced course

Merge spreedsheet

How do you merge spreedsheets that have not got identical data?

Tue 7 Jul 2009, 17:16 Trainer Amanda said...

RE: merge spreedsheet

Hello Lisa

Thank you for your question and welcome to the forum.

Are you wanting to just combine spreadsheets together onto one sheet; or do you want to create some kind of summary sheet of all your sheets which will give you say, for example, totals of the combined data?

Kind regards
Amanda

Training courses

98.4 % recommend us

More live stats...

Training information:

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips