An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.
An expert whose answer got voted for 20 times.
Re: Microsoft excel cell formatting
YES! Select the cell you want to copy, "right click" then select copy from the list that appears when you "right click". Select the cells you want to copy the preferred cell to ----- by left clicking, the start cell (your courser will change to a large thick plus symbol) then hold and drag to the ending cell you want to place the copies to and let up and right click the area now highlighted and select "Print" from the list that appears.
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- 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.
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.
Its hard to know the issue, but I suspect its due to the cell formatting not being something that can be "summed". Make sure the column(s) you are having autosum are all of the same format (numerical?)
In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
On the Home tab, in the Clipboard group, click Copy .
Keyboard shortcut You can also press CTRL+C.
Click in the PowerPoint presentation where you want to paste the copied worksheet data.
On the Home tab, in the Clipboard group, click Paste.
Keyboard shortcut You can also press CTRL+V.
Click Paste Options next to the data, and then do one of the following:
To use the original format of the copied data, click Keep Source Formatting.
To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
To paste table data that you copied as text, click Keep Text Only.
If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button , and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
You can change this under the Excel, options menu. Select the advanced option and uncheck the option to "Show Formulas in cells instead of their calculated value", or you can jjst press Ctrl + `
This will either turn on or off the show formula option.
it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.
If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.
If you mean the whole Workbook - then I dunno.
In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.
If you must use unique passwords, then keep a record of them somewhere other than on your computer.
Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.