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

True Detective: Season 4 is official, HBO announces development

There Season 4 Of True Detective it will be done, as announced by HBO, which would be working on its development. Production will be entrusted to Berry

Sky and NOW: the main news from 20 to 26 March

March is about to come to an end, but despite this there will be news brought by Sky and NOW. Between TV series and films, the schedule will expand

Testament returns in Guilty Gear attempt with a second season of characters to come

The Arc System Works tournament Arc Revo America has ended, and with it brings a lot of announcements for the future of Guilty Gear Strive and more.

Tiktok was ‘just a dancing app’. Then the Ukraine war began

Many have called the invasion of Ukraine the world's first "TikTok war", and experts say it is high time for the short video platform - known primarily for

I’m leaving Apple to Android if the iPhone 14 doesn’t have this feature

As a longtime Android user I can go through a lifetime of bliss regardless of what type of charger I carry with me; If I have a USB-C charger or cable, I'm