![]() ![]() ![]() This will allow the CSV file to separate the data by commas, instead of by lines.Ĭlick on the "File" tab at the top of the screen and choose "Save As" from the list of options that appear. Once you click this option, your data will be pasted to the new worksheet, but it will be orientated horizontally instead of vertically. The "Transpose" icon will look like a set of vertical and horizontal cells with an arrow running between them. Right-click on cell "A1" and move your mouse over "Paste Special." Choose "Transpose" from the paste options that appear. Press "Ctrl" and "C" to copy this information to your clipboard.Ĭlick on "Sheet2," located at the very bottom of your spreadsheet, to bring up a blank worksheet. Drag the mouse button down until you reach the last cell in the list. Click on the top cell in your list of Excel data and hold down the mouse button. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |