Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by After shifting from one worksheet to another, click the Switch between last and current worksheet button in the Workbook & Sheet section will return to the last active sheet. Please do as follows.īefore applying Kutools for Excel, please download and install it firstly.Īfter installing Kutools for Excel, the Navigation Pane will display on the left side in Excel automatically.ġ. The Kutools for Excel’s Shift between last and current sheet utility can help you to quickly return to last active sheet with just one click in Excel. Return to last active sheet with Kutools for Excel Repeat pressing the F5 key, the windows will be toggled between these two worksheets. Then you will return to the last active sheet after pressing the F5 key. Then go back to the Microsoft Visual Basic Application window again. Go back to the workbook, shift between the worksheets. VBA code: Return to last active sheet Public LstSht As Worksheetģ. Then paste the below code into the window. Then click Insert > Module to open the Module window. VBA code: Return to last active sheet Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)ģ. In the Microsoft Visual Basic Application window, double click ThisWorkbook on the left pane, then copy and paste below code into the ThisWorkbook(Code) window. Press Alt + F11 to open the Microsoft Visual Basic Application window.Ģ.
You can run the below VBA codes to return to the last active sheet in Excel.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 kommentar(er)
