Posts

Extremely Useful VBA Shortcuts Every Excel VBA User Should Know

20 Useful VBA Editor Keyboard Shortcuts These keyboard shortcuts help you write, edit, debug and manage VBA code faster in the Microsoft Visual Basic Editor. No. Shortcut Function 1 F5 Run the VBA macro or procedure 2 Ctrl + Break Interrupt or pause a running macro 3 F8 Execute code one line at a time (Step Into) 4 Shift + F8 Execute the next procedure without stepping into it (Step Over) 5 Ctrl + Shift + F8 Step out of the current procedure 6 Ctrl + F8 Run code up to the current cursor position 7 F9 Set or remove a breakpoint on the current line 8 Ctrl + Shift + F9 Clear all breakpoints 9 Ctrl + G Open the Immediate Window 10 Ctrl + R Open the Project Explorer 11 F4 Open the Properties Window 12 F2 Open the Object Browser 13 F7 Display the Code Window 14 Shift + F7 Display the Object or UserForm view when available 15 Ctrl + F Find text in the code 16 Ctrl + H Find and replace text in the code 17 Ctrl + S Save the current VBA project or workbook 18 Ctr...

Extremely Useful SAP Shortcuts Every SAP User Should Know

20 Extremely Useful SAP Shortcuts These useful SAP GUI keyboard shortcuts can help you navigate SAP screens, enter data, manage transactions and improve your daily productivity. No. Shortcut Function 1 Enter Confirm an entry or proceed to the next screen 2 F1 Display help for the selected field 3 F3 Go Back to the previous screen 4 F4 Open possible entries / value help 5 F8 Execute a report or transaction 6 F12 Cancel the current screen or operation 7 Ctrl + S Save the current document or changes 8 Ctrl + P Print the current screen or document 9 Ctrl + F Find text in supported SAP screens or lists 10 Ctrl + G Find the next occurrence in supported search screens 11 Ctrl + C Copy selected text or data in supported fields 12 Ctrl + V Paste copied text or data in supported fields 13 Ctrl + X Cut selected text in supported fields 14 Ctrl + A Select all text in a supported input field 15 Tab Move to the next input field 16 Shift + Tab Move to the previous input...

Extremely Useful Excel Shortcuts

20 Extremely Useful Excel Shortcuts These 20 useful Microsoft Excel keyboard shortcuts will help you save time, work faster and improve your daily productivity. No. Shortcut Function 1 Ctrl + T Create Excel Table 2 Ctrl + Shift + L Apply / Remove Filter 3 Ctrl + E Flash Fill 4 Ctrl + Shift + ↓ Select down to next data boundary 5 Ctrl + Space Select entire column 6 Shift + Space Select entire row 7 Ctrl + 1 Format Cells 8 Ctrl + F Find 9 Ctrl + H Find & Replace 10 Alt + = AutoSum 11 Ctrl + D Fill Down 12 Ctrl + R Fill Right 13 Ctrl + Shift + + Insert cells, rows or columns 14 Ctrl + - Delete cells, rows or columns 15 Ctrl + Z Undo 16 Ctrl + Y Redo 17 Ctrl + ; Insert Current Date 18 Ctrl + Shift + ; Insert Current Time 19 Ctrl + A Select current data region / entire worksheet 20 Ctrl + Page Up / Down Switch worksheets Conclusion Lear...