- Search for the “XLStart” folder in machine. It can also be at multiple locations.
- Delete the file – “~$Book.xltx”. or other corrupted file as displayed in the message.
- Open excel again to verify that the error message is not displayed now.
C:Users
Amita
C:Users
Below are the steps to take to recover your unsaved new document in Microsoft Office Excel, Work, or PowerPoint 2010 if you inadvertently close it before saving it:
Another alternative!!! Depending on the operating system, files may also be browsed at following locations:
I read somewhere, Ctr+S is still your best friend…:D
Now, we want to change it into columns, like:-
MS-Excel
Excel – Transpose Data
Moving the data manually, one item at a time, would be a tedious process when we have large volume of data. To save time, we can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa.
We need to follow the following steps:-
3. In the Paste Special dialog box, select Transpose, and then click OK.
We’ll find the Transpose check box in the lower-right corner of the dialog box:
4. Starting with our first cell, Excel pastes the data into a row or column.