How to change the orientation of my Excel table? – From landscape to portrait



The Excel platform contains various services for each type of user and the teams in which they work. Some of these tools are the change of orientation within a table. These can be executed by different means such as the mobile app or from the website. Join us to discover how to change the orientation of a table in excel quickly following a step by step.

What command can you use to change the orientation of your table in Excel?

The commands of advanced features that can be run admin style or otherwise to perform actions within a Worksheet. Each user develops a different command sequence and varying the amount of size that a calculation area or Drive has, they are carried out with the components of the CRTL keys.

These features work together to streamline the process, Making everything much easier and more practical when using any device with Excel. Within this platform you will also be able to combine with other applications to make changes, an example of this is Translate to use with Google and other files within the local tools of the bar in Excel.

From your Windows PC

These options are normally executed before starting a redaction or filling in the blanks, all this so that you do not have to select from one cell to another for several clicks. Through the rows or columns by clicking on one of them to then change in its configuration the new orientation that you want to assign to it.



Within Windows you enter the Excel Sheet. You create a new sheet inside the existing one and you press on CRTL + the start sign in Windows to open the panel of alternatives to choose from. You click on a cell and choose change values, then orientation and determine the change in the table. It can be from the last place to the first and prioritize it so as not to change it again.

With the mobile app

This app allows you to create both orientation changes and other shortcuts within a spreadsheet or any other worksheet. With different executable options with the CRTL keys followed by an action of selecting, shading, highlighting, deleting, saving and others. With the changes of orientations, it is easy to he could line up boards, as well as cross or throw back.

excel emblem

To do so, what you will have to do is enter an existing file or create a new one by clicking on new document. Once this is done, you go to the options section located on the main page in the upper right corner. As the change that is required to be made in this case is in a table; what you will have to do is drag one of the selected ones to this option.

Then in the new window that is displayed choose in the Alignment Group box and then Orientation. You select between the change to be made or the orientation to change from the established values ​​and proceed to Rotate.

On iOS devices

Like any Word work system, Excel is an easily accessible and useful installation add-in on any device; regardless of version. And in the cases of iOS it is not the exemption, you will only have to make sure that it is updated to carry out the execution of orientation change within tables without presenting inconveniences.

To do so, just like with the official Excel website, you will enter a new document and select from among the cells regardless of the order of rows and columns that you want to modify. Because on mobile devices not all options are displayed the same as on PC; the orientation change will be displayed among the first alternatives to choose.

You click on the Groups in the alignment session to then select the orientation option and mark the change you want. All this quickly without having to perform many steps. Included within the mobiles, it also performs PC actions such as separating the numbers with spaces with actions to personalize.

working at the office

What is the way you can go from rows to columns in your spreadsheets?

This option, as in the information mentioned above, is simple and quick to put into practice. And it is not difficult to carry out, since it has only one option to carry out, as it is selection by box or cells in blank spaces as already written previously.

Within a work document you will have to check the style, row or column box of your choice. Press for a few seconds and click Move, add the name of the address to pass and then in the box where it will be pasted, select receive. Once this is done, the change will be made quickly.

You must press on the first cell in which you want to insert the data. place in the login session and locate session to mark in transpose. Within the same spreadsheet, fill in one with sufficient storage capacity and add the change by rows or columns.

making graphs in excel

What to do to go from columns to rows?

This option is executed without any problems with the mouse or by clicking several times on the boxes where you want to go from row to column. All this pressing on a few seconds until the cell turns Bold-style black; then click on the other to move. After this action you can continue writing the information of your document.

Excel is a complete system which allows not only these functions of the change of orientation for greater accessibility within the tables in the spreadsheet. Now you can create new consecutive style codes to edit numbers and letters; as well as the size and many more options.



Related News

Why we can call 112 without a SIM card and other curiosities of the emergency telephone number

Within the so-called numbers of social interest, the best known is, without a doubt, 112, which in Spain is served by the Autonomous Communities. These three

Give an original touch to your Telegram group with these names

When you create a group on Telegram, one of the most important things is the name to place, but creativity does not always help us, and if you want an

WhatsApp msgstore file: what does it contain and how to open it?

The WhatsApp and backups is quite a drama. The messaging app is very restrictive with this topic, because Android users are only allowed to save a backup of