Convert column values to row values in Excel 2010

0 Comments

Use the past special operation: "Transpose" in Microsoft Excel 2010 to convert column values to row values: Select column values and press CTRL + C:   Select a cell outside the range, in this example

Create Microsoft Excel documents with the Open Xml SDK with charts

0 Comments

See: http://blogs.msdn.com/brian_jones/archive/2008/11/04/document-assembly-solution-for-spreadsheetml.aspx You can now create Microsoft Office Excel documents which are compatible with the desktop client, with use of the Open Xml SDK. The created document can contain charts, formula’s etc. The data is

Shortcut for pasting unformatted text in Microsoft Excel

0 Comments

Alt+e+sWill open the paste special dialog en then you can choose “Text” (this will also work in other Microsoft Office applications like Microsoft Office Word) Or F2 and then CTRL+VWhen you are in a cell,