About This Shortcut Redo – the last action- Ctrl +Y is useful for redoing an undone action. Keybord shortcut key: Window: Ctrl + Y Mac: cmd + Y Example: If you use the undo command (Ctrl + Z) and discover that you didn’t make a mistake, you can use the redo command (Ctrl + Y).
Excel Shortcut: Redo Read Post »
About This Shortcut Undo – Ctrl + Z undoes the previous activity. A multi-step process can be undone. Keybord shortcut key: Window: Ctrl + Z Mac: cmd + Z Example: Suppose you have made any mistake in Excel; you can undo the action by tapping Ctrl + Z. Lets’ say the last record you entered
Excel Shortcut: Undo Read Post »
About This Shortcut Open help – Pressing F1 will bring up the Excel Help window. The F1 key is frequently set as the program’s default help button. It is one of the function keys that work better. Keybord shortcut key: Window: F1 Mac: cmd + / Note: The shortcut key will work with function key
Excel Shortcut: Open help Read Post »
Microsoft Excel stores and analyses data worldwide. Excel is still the go-to data analytics tool despite newer tools. Its many features simplify data organization. Moreover, Excel shortcuts speed up data manipulation. Excel uses shortcuts, and Excel shortcut keys speed up our work and boost productivity. These shortcut keys work with most Windows versions of Excel.
Excel Shortcut Keys Read Post »
VBA code is generally error-prone because even the most careful programmer can commit syntax or logic mistakes. Errors and mistakes are common because code can never be perfect. The Error Handling Standard is a formalised approach to coding that allows us to track and fix software defects. It’s a method for anticipating mistake conditions and
VBA Error Handling Read Post »