In our previous article, we learned about Excel User Interface for Mac. In this article, we are going to learn about How to enter Data and Navigate Around the cells. For this article, we are going to create a new blank Excel workbook. Following image shows the newly created Excel workbook.
A1 is our Active cell. If you are going to type anything, it is going to enter in the active cells. We are going to start with “Hello, vLemonn !” text. For saving text we can use the right icon. If you want to discard the changes use the cross icon. Following image shows more detail.
I always prefer shortcuts to do anything. It is easy and fast. For saving our “Hello, vLemonn !” text we are going to press enter. On “enter” your active cell is changed to just below the currently active cell. Enter key is not the only way to save the data in the cell. You can use “Tab”, in case of “Tab” your active cell is changed to just right of the currently active cell. You can use “Shift-Tab”,“Shift-Tab” is just reverse of “Tab”, when you use “Shift-Tab” your active cell is changed to just left of the currently active cell. Ok so “Shift-Tab” is the opposite of “Tab”. Can we use “Shift-Enter” the same way? Yes. You can use arrow key also to perform the same actions. We can also use formula bar.
Once you have a value in the cell then you can mouse to create a copy of your cell’s value. Hover over the currently active cell, If mouse pointer changed to black plus sign, move your mouse either horizontally or vertically by pressing left click to create a copy the currently active cell values.
Cut, Copy and Paste
You can also use cut, copy, and paste operations to create a copy or moving cell contents.
For cut select any cell press command+x or (from menu Edit → Cut), then select another cell where you want to move the cell content and command+v or (from menu Edit→ Paste). You can select multiple cells for cut and paste operation.
For creating the copy of cell value press command+c or (from menu Edit → Copy), select the cell where you want to move the cell content and command+v or (from menu Edit → Paste).
In our Excel WorkBook, we can save any number of the worksheet. Each worksheet can contain 1048576*16384 = 17179869184 cells. In cells, we can save a numeric value or a text value. We can also use the formula to modify cell content.
We can also add shapes, charts, diagrams, pictures, buttons and other objects. But all these objects are not cell's specific. We are going to cover more about other objects in our upcoming articles.
A cell can contain a maximum of about 32000 characters. If we are trying to add a large text to our cell, formula bar may not able to show all contents. In such scenarios, you can change the height of formula bar.
For number largest allow positive number 9.99999999999999E+307 and largest allow negative number -9.99999999999999E+307.
Above figures all large enough for day to day work. We are not going to reach above limitations in our tutorial series.
Before completing this chapter, we are going to learn about how to modify cell content.
Edit cell contents
For editing cell content, select the cell and start typing for new value. This method replaces cell values.
If you don’t want to replace content and want to edit existing content, double-click on the cell. You can also select the cell and then click on the formula bar.
Last method to edit cell content, select cell content and then press F2.
Delete Cell Contents
Deleting cell content is simple. Select cell and then press delete.
During above of any operation, if you want to undo or redo, you can use command + z for undoing or command + y for redoing your last operation.
In this chapter, we didn’t discuss the cell formatting. We are going to discuss it in our upcoming articles.
Please login to post your valuable comments.