Entering And Editing Data In The Formula Bar

Enter data into any cell.

Select the cell where you want to enter your data and start typing.

As you type the data notice the data also appear in the Formula Bar.

To accept the data either click the Check Mark or press Enter. To discard the data either click the X or press Esc.

 

The process for entering a formula is the same except all formulas need to start with “=” (without the quotation marks). To edit any data and formula in any cell, select the cell and either click into the Formula Bar or press F2 to enter editing mode.

Question:-
How to use Zoom control?

Answer:-
In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.

Option 1:-
1. To quickly zoom the document, use the minus a plus symbols in the status bar.

Option 2:-
Zoom in percentage:-

To zoom to a specific percentage, execute the following steps.

1. On the View tab, in the Zoom group, click Zoom.

2. Enter a number (between 10 and 400) and click OK.

Option 3:-
Zoom to Selection:-

To zoom to a selection, execute the following steps.

1. First, select a range of cells.

2. On the View tab, in the Zoom group, click Zoom to Selection.

Dear Friends,
Please read the above details and ask your doubts in comments to get the benefit.

Thanks and regards

Please share your valuable suggestions for this chennal and share this chennal with your friends.
Thank you

Question: -
How to add the shapes in Excel?
Answer: -
You can add shapes, such as boxes, circles, and arrows, to your spreadsheets. To add a shape, click Insert, click Shapes, select a shape, and then click and drag to draw the shape.
After you add one or more shapes, you can add text, bullets, and numbering to them, and you can change their fill, outline, and other effects on the Format tab.

Add shapes

Question: -
Shortcut key to add Shapes in Excel.
Answer: -
Alt + N + SH