Excel Tricks
1. Excel trick 2 Automatically insert serial number after filter in Excel =SUBTOTAL(103,B$20:B20) Without filter: After filter: 2. Auto adjust serial number sequence in excel =ROW(B36)-34 After delete the Row:
Excel
Excel Master Class- Basic to Advance
Excel Master Class- Basic to Advance 1. Interface Overview: Open excel file from window menu-> More templates Select any one templets. Quick Excess toolbar: Menu bar: Footer Bar: Cell, Rows, Column, Name box & formula bar: 2. Workbook & Worksheet: 3. Save File: 4. Movement Shortcut Key: 5. Data entry shortcut key: 6. Selection with … Read more
100+ Excel Keyboard Shortcut to save your time | Excel Keyboard Shortcut
Excel Keyboard Shortcuts: SHORTCUT KEY BASIC DESCRIPTION ADDITIONAL COMMENTS (Ctrl + Alt + V) + B Paste special, skipping blanks When skipping blanks, existing values in the destination are not replaced by blanks in the source data (Ctrl + Alt + V) + C Paste cell comments (Ctrl + Alt + V) + D … Read more