If you press F8 when selecting cells, the Status Bar will show Extend Selection and allow you to use the arrow keys to change the current selection. This shows your selection mode when using the keyboard to select a range. Accessibility CheckerĪnother 365 feature, this will show your workbook’s status according to Microsoft’s Accessibility Checker (also available on the Review tab), which will review for things like hard-to-read fonts, images with no alternative text for screen readers, and so on. Macro Recordingĭisplays the icon (visible in the screenshots above) indicating whether a macro is currently being recorded you can also click the icon to start/stop macro recording. This will note if you have pressed the End key if you have done so then the next arrow key you press will send the selected cell in that direction until it reaches the next filled/empty cell (depending on what you started with). This will show if the Insert / Overtype keyboard setting is used when editing a cell – which makes your typing replace current text rather than inserting it. Note that the option on the Status Bar right-click menu just controls whether an indicator of this setting is shown – to actually enabled Fixed Decimal entry, use File => Excel Options => Advanced => Automatically insert a decimal place. This is sometimes used for data entry of monetary amounts. you can set it to 2 and then if you type 12345, the value entered will be 123.45. This is a setting that you can enable that will make any numbers you type forcibly include a given number of decimal places – e.g. Shows an indicator if one or more of these keyboard settings has been enabled.Īccidentally enabling Scroll Lock in particular can make your Excel act very oddly – it will make arrow keys scroll the screen instead of changing the active cell – so watch out for that one! Fixed Decimal Similarly to the Sensitivity setting, this shows if the workbook is subject to Information Rights Management protection. Notes if the active workbook has been digitally signed. SensitivityĪnother newer feature, this will display if the workbook has been set with a custom sensitive level such as “secret” or “internal use only”. Workbook StatisticsĪdded in Excel for Microsoft 365, this option allows you to pop up a short summary of your workbook’s key stats – such as the number of populated cells, formula, number of worksheets, and so on. These show you how many cells were affected or left blank by Flash Fill (see TOTW #124 for more on that). Ready is the default state Enter mode is when you are typing text or a formula Edit is when you are amending a previously-written cell and Point is the mode for selecting a cell outside the current formula to use in the formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |