Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

spreadsheet.... microsoft excel?

i was just wondering how you type vertically on a spreadsheet using microsoft excel ?

thankyouu.

6 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Type in Alt+Enter

    something Alt+Enter

    like this Enter

    ...will look like this in a cell

    Type in

    something

    like this.

  • 5 years ago

    There really isn't any need to convert the *.wks files to *.xls files as Microsoft Excel has the ability to open those types of files without having to do anything. What you need to do is go to File and Open and in the drop down menu for Files of Type: scroll down until you find Microsoft Works files. If you want all *.wks files to be associated with Microsoft Excel so they open automatically in Excel try double-clicking on one of the files and it will prompt with what program you would like to open that file with. Select to select a program from a list. Chose to open the file with Excel but check the box at the bottom of the screen that says Always use the selected program to open this kind of file. More info: If just trying to open the file with Excel I would say that you need to specifically choose to open a Microsoft Works file or *.wks since Excel will need to know what format the file is in and open it accordingly. Excel can also open Quatro Pro files but if you don't specify that the file is Quatro Pro then it may not work properly. I have a machine that has Office 2000 on it. If this approach still does not work please let me know and I can try it on that machine. Email me if this is the case and try attaching one of the files I can look at. Additional Info(9-20): I have been doing some research and I have found that you cannnot directly open Microsoft Works 3.0 or 4.0 files directly into Excel. Excel will only open Microsoft Works 2.0 or earlier format. Below is a Microsoft knowledgebase article describing the problem and how they have decided to address it. It would appear that you are going to need Microsoft Works installed to change the file format to something Excel will recognize before you make the move to Office.

  • Anonymous
    1 decade ago

    Highlight the relevant cells, then right button of mouse down to format cells, click on alignment tab and then either type in the degrees of orientation or easier to swing the slider in the 'clockface'.

    Someone has suggested using Alt Enter but this is merely a shortcut for wrapping text within the same cell, not changing orientation.

  • 1 decade ago

    With cursor on the cell(s) Format > Cell and move the indicator on the right of the dialog box.

  • How do you think about the answers? You can sign in to vote the answer.
  • Anonymous
    1 decade ago

    Right click on the cell, select "Format Cells", choose "Alignment" then change the "Orientation".

  • 1 decade ago

    right click on the cell and in the cell alignment u can change the orientation of the text.

    specify the angle and u have it

Still have questions? Get your answers by asking now.