limit Scroll Area on an Excel Worksheet

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot be selected. Are there any quick tricks to limit the scroll area on an Excel worksheet? Limit Scroll Area by Entering the Range Address Manually Open the workbook….

Limit Scroll Area Use Excel VBA

The following VBA code can help you to limit the scroll area for a particular worksheet. VBA code Excel’s ScrollArea property allows you to set the scroll area for a particular worksheet. For instance, this statement sets the scroll area on Sheet1 so the user cannot activate any cells outside…

Complete List of Excel VBA Editor Keyboard Shortcuts

The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. See also: Complete List of Excel Keyboard Shortcuts for Windows and Mac. # Action Shortcut 1 Help F1 2 Object Browser F2 3 Find F3 4 Properies Window F4 5 Run…

Find and Select the First Blank Cell in a Column VBA

Sometimes, You may need to find and select the first blank cell or last blank cell in a column, these macros can help you. Find and Select the First Blank Cell in Column A Sub Macro1() Dim ws As Worksheet Set ws = ActiveSheet For Each cell In ws.Columns(1).Cells If…

How to Rebuild Data, Case Study

Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data, OK, let’s start the case. Source Data Rebuild Data INDEX formula You might think use INDEX() function, right! but how? The INDEX() function syntax: INDEX(array, row_num, [column_num]) After…