Microsoft Excel is one of the most widely used tools nowadays. Almost every company needs to create worksheets in this program to organize their data. However, facing Excel for the very first time; it could be scary when opening a new file and you don’t even understand any aid you have in front of you. Well, keep reading because this article will introduce you to how to use Excel.
Once you open the program, you will see a worksheet composed of cells duly organized in columns and rows. The columns are tagged to the left to right by the alphabet, starting from the letter A and so on. Numbers classify the rows top-down.
You can click on any cell in the worksheet and type the information you want to input, like texts, values, formulas, etc.
At the top of the worksheet, you will find a panel with options that will display some functions and subfunctions that will help you organize, visualize, type, and create the information you need.
Now, every tab has different group tools, which will help you locate the aid you need at every moment.
Once you open a new file in excel, you can use your mouse to select the tools and tabs from the ribbon. However, just like Microsoft Word, you can use your keyboard to scroll within the document: when using the Tab key, you can move to the right to the next cell in the following column. Or, when using the Enter key, you can move to the next row down.
Another way to navigate using the keyboard is by using the directional arrow keys, which correspond to Up, Right, Down and Left.
Well, the content you want to put into a cell will not always fit; it may span several columns, or on the contrary, the content of the next column will cut off the information. So, for that kind of situation, you can use two options to fix this.
The first one is going to the column or row where the cell you want to expand is placing the cursor at the right border. Notice that your cursor has changed, and now you have a black line with two tiny arrows on both sides. Click on the edge, grab and move it until you think the data fits.
To access the second option, you need to do the following steps:
And that’s it. Excel will adjust the text according to the column size!
Finally, there are some shortcuts you can hit on your keyboard that will make your life easier: