Selected by default, this option displays Fixed Decimal to indicate that all numerical values that you enter on the worksheet will be displayed with fixed decimals. Selected by default, this option displays Scroll Lock to indicate that SCROLL LOCK is turned on to allow scrolling in the worksheet by using the arrow keys. When selected, this option displays Num Lock to indicate that NUM LOCK is turned on to allow using the keys on the numeric keypad to enter numbers in the worksheet. When selected, this option displays Caps Lock to indicate that CAPS LOCK is turned on to allow typing in uppercase characters. This icon displays only when access to the document has been restricted (Microsoft Office Button, Prepare, Restrict Permission, Restricted Access). Selected by default, this option displays an icon next to the Cell Mode indicator that you can click to view the current read and edit document permissions. Selected by default, this option indicates that Information Rig hts Management(IRM) has been used to restrict permission to content in the active workbook. Selected by default, this option indicates that the active workbook has been digitally signed. Shows the number of cells that were filled after a Flash Fill operation. Shows the number of cells that were skipped (left blank) after a Flash Fill operation. It is displayed when you start a formula and then click the cells that you want to include in the formula. Point to indicate formula cell selection mode.It is displayed when you double-click a cell, or when you press F2 so that you can enter or edit data in a cell. Edit to indicate in-cell editing mode.It is displayed when you select a cell and start typing, or when you press F2 twice. Selected by default, this option displays the current cell editing mode on the left side of the status bar. The commands that are available for us to activate or deactivate in Excel 13 are the following as shown in the table below: Cell Mode: In the image below we can see how we can customize the Status Bar. In order for us to customize the Status Bar, all we have to do is to do a right click on it and from the shortcut menu that appears we just click on the command that we want to activate or deactivate. In the image below, we can see the Excel Status Bar with the commands Average, Count and Sum activated. On the Status Bar many options are activated by default, but we also have the option to activate or deactivate commands in order for them to help us. In all Microsoft Office programs there is the Status Bar which is located at the bottom of the window.
0 Comments
Leave a Reply. |