working multiple worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Working with multiple worksheets

Working with multiple worksheets

resolvedResolved · Low Priority · Version 2007

Laura has attended:
Excel Intermediate course

Working with multiple worksheets

Only query raised was about sheet names not being available when con solidating data, document name only.

RE: Working with multiple worksheets

Hi Laura

Thanks for your question - yes it is true that Excel only shows the Workbook name rather than the sheet name alongside consolidated data. It becomes more helpful when the data being consolidated comes from more that one workbook.

I hope this helps and do let us know if you have any other questions.

Kind regards,
Andrew

Thu 3 Apr 2014: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.08 secs.