a) If you want to add the sheets from one workbook to another workbook, you
should have both files open and then right click on the sheet name and
choose "Move or copy". Altenatively you could use the Alt-E-M and then
follow the dialog.
For more excel keyboard shortcuts see:
http://www.shortcutworld.com/en/win/Excel_2007.html
http://www.wallstreetprep.com/extrafiles/finmodeling/downloads/newxlshortcuts.pdf
http://office.microsoft.com/en-in/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx
b) If you are looking to merge data from one sheet into another sheet in
another workbook, you could use the "track changes" feature. This is a bit
more involved - so if you are not able to figure out what to do, please let
me know.
Cheers.
Date: Sun, 22 Sep 2013 16:14:09 +0530
From: "Ashik"
To: "Access India"
Cc: KeyBoard Users
Subject: [AI] How to merge two Excel files in Office 2007?
Message-ID: <006401ceb780$afd14ef0$1bd7e875@ashikhir87ff6f>
Content-Type: text/plain; charset="iso-8859-1"
Dear Friends,
I would like to know how we can merge two Excel files in Office 2007. I
tried to find the it from the menus, but could not.
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..
