Q1Act4TipsandTricks_SantiagoNaranjo

Excel Tips and Tricks

A visual presentation created by Santiago Naranjo

How to merge cells

To merge cells in Excel, select the merge and center icon just below the wrap text icon. This will permit your text to occupy the number of cells you select before tapping on the icon. When you click on the arrow just beside the icon, you will see that more merge option will be displayed.

Fast way to open columns

In Excel, we can open up colums by double-clicking or dragging the division between two columns. This will permit us to obtain another size.

Fast way to open rows

Like with columns, the fast way of opening up rows in Excel is by selecting a division between two rows, leave it clicked and drag it yo your preffered size.

how to wrap text inside cells

To wrap text inside cells, you simply have to select the desired cell where you want the action to happen. Then, click on the wrap text icon located below the merge and center icon. You will see that when clicking on the little arrow beside the icon, more options will be displayed.

How to change color of the cells

To change the color of a cell, the first thing you need to do is select the cell you want to modify. After that, you need to locate the fill color icon and select the arrow beside it to see every color option. The color options are divided into categories, there are the standard colors, the theme colors, your recent colors, and the more colors options, which permits you to choose any color and shade you'd like to use.