In addition to being a complete program, Microsoft Corporation performs annual updates to implement new useful tools and make improvements to existing ones.
Excel, despite being on the market for many years, it is not as recognized, as it is difficult for users to manage. However, you will find that it is quite simple once you try it and only requires the use of a few key and letter combinations. And it allows you to easily use all Excel formulas in one spreadsheet
How to transpose or modify rows and columns using formulas in an Excel sheet
How to transpose or modify rows and columns using formulas in an Excel sheet" src="/images/posts/68e05d133c69f02774e142be6e7632cc-0.jpg">
One of the most difficult tasks when using Excel spreadsheets is to modify or transpose rows or columns. It's not that hard, you just have to perform these steps:
- The first thing to do is to select the entire dataset, including the rows or columns.
- Once the data has been selected, press the key Ctrl (ctrl) more + the button "C".
- When you have already selected the data, you need to choose the new location for it, making sure there is enough space for it.
- This new table you created automatically overwrites any data that was already there.
- Right-click in the upper left corner of where you want to place the data.
- When you click, you will notice that a list of options is displayed, including the one to transpose, you can identify this option, as a sheet or spreadsheet appears that has two squares inside, one upright and one that rotates horizontally.
- After rotating the data in the form of a column or row, that is, in a vertical position. You can delete the previous row where the data was.
- The data you have identified will remain intact.
Some things you should know about Excel
How to transpose or modify rows and columns using formulas in an Excel sheet" src="/images/posts/68e05d133c69f02774e142be6e7632cc-1.jpg">
Before the release of Excel, there was a predecessor called Multiplan. Which was made up of spreadsheets. This prototype was very popular. But it wasn't as complete as another program called Lotus 1-2-3 created by a competing company. Microsoft will later develop this clever and most widely used program today.
Excel has the option of create a pivot table, this table allows you to rotate the data in a contrasting way to observe them from different angles and choose the best position. Basically it allows you to move data from the row option to the column option or vice versa.
In case your data contains formulas, Excel will automatically update them in the new location to match. Of course, you must first check that the formulas have absolute references. If not, you can choose to switch to relative, mixed, or absolute references.
You should know that Excel has organized an infinite number of combinations to facilitate the tasks when creating the tables, here we will show you some of them:
- Ctrl + A, selects all cells in a document.
- Alt + F1, creates a chart with a group of selected data.
- Ctrl + T, converts a selection of cells to a table.
- F9, Calculate the operations of all worksheets.
Gradually you will find that managing worksheets in Excel it's not that complicated a task. If not quite fun, simple and fun. You will discover the balances, the percentages in your sales and negotiations and you will be able to develop new techniques to grow even more as a company.
Remember that if you accidentally installed Excel in a language other than Spanish, you can change the language very easily.
Finally, we hope you enjoyed this article, however, we'd love to hear from you Were you able to use the formulas easily? Is there an easier way to change rows in Excel ?, Leave us your opinion in the comments.
