An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert whose answer got voted for 20 times.
An expert who has written 20 answers of more than 400 characters.
Re: copy the picture without mouse in excel file
Well the best info i can give you is to use the directional keys or the tab button to select the image. (or you can cheat by using ctrl-a..that is the keystroke for select all)
After you have selected the image (you can tell it has been selected when there are little boxes that appear at the corners of the image) You can then hit ctrl-c to copy. Open or switch to the file you want to copy the image to then hit ctrl-v which is the keystroke for paste.
Good luck let me know if this helps by rating my response!!!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.
1. Open a blank Excel workbook by selecting "New" from the "File" menu.
2. Drag and drop the .shs file on to the new workbook by highlighting the scrap file icon on the desktop and dragging it onto the worksheet. Alternatively, you can copy and paste. To do this, click the scrap file icon, and then right-click and select "Copy" from the pop-up menu. Left-click on the Excel workbook, and then right-click and select "Paste" from the pop-up menu. The information stored in the scrap file should now appear within the worksheet.
3. Save the file. Select "Save As" from the "File" menu, and then enter a file name in the box at the top of the window that opens. By default, Excel saves files in the workbook format native to the version. For versions prior to Microsoft Office 2007, this is the .xls format. If you have Excel 2007 or later and want to save the file as .xls, select this format from the "Format" drop-down menu below the box where you entered the file name.
Hi, what is the exact error code you receive? If you can provide the exact error code or message, will narrow down troubleshoot. To get around the problem, try starting Excel in safe mode. The command is "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE /s".
To run the command:
1. Copy the above command without inverted commas.
2. Click Start and paste by pressing "Ctrl + V" and press the Enter key.
See if this open Excel. Thereafter, exit Excel and try opening Excel again in normal mode without the "/s" switch at the end.
If still having issue, suspect some of the system files may be corrupted. Run Office setup and hit Repair when prompted.
If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.
Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.
Then finally, export/save as that external sheet to any filename of your choice.
Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.
What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.