Swap rows into columns
Posted: Tue Jan 21, 2025 3:47 am
10 basic Excel functions and tricks for your everyday life
1. Fix columns or rows
The first of the Excel tricks is very simple and at the same time very useful. It involves fixing a column or a row so as not to lose sight of the header. This way, it is much easier to read the data contained in a very large table.
To do this, simply select a column or row and click “View” and then “Freeze” .
You can choose from several options, depending on brazil telegram data your needs. You can use “Freeze Panes” to freeze the entire selected table or “Freeze Top Row/Column” to keep the row/column always visible when you scroll through the document.
2.
It may be the case that you have a table created, but you need to reorient it so that the data in columns is rearranged into rows and vice versa.
To do this, all you have to do is select the table and use Ctrl + C to copy it. Then, in a blank cell, right-click and choose the “Paste special” option and, finally, “Transpose” .
3. Advanced search with wildcard characters
With a simple keyboard shortcut, Ctrl + B , you can quickly perform a search within the document. But there may be cases where you don't know exactly what you're looking for, and this trick will be of great help to you in these cases.
1. Fix columns or rows
The first of the Excel tricks is very simple and at the same time very useful. It involves fixing a column or a row so as not to lose sight of the header. This way, it is much easier to read the data contained in a very large table.
To do this, simply select a column or row and click “View” and then “Freeze” .
You can choose from several options, depending on brazil telegram data your needs. You can use “Freeze Panes” to freeze the entire selected table or “Freeze Top Row/Column” to keep the row/column always visible when you scroll through the document.
2.
It may be the case that you have a table created, but you need to reorient it so that the data in columns is rearranged into rows and vice versa.
To do this, all you have to do is select the table and use Ctrl + C to copy it. Then, in a blank cell, right-click and choose the “Paste special” option and, finally, “Transpose” .
3. Advanced search with wildcard characters
With a simple keyboard shortcut, Ctrl + B , you can quickly perform a search within the document. But there may be cases where you don't know exactly what you're looking for, and this trick will be of great help to you in these cases.