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….

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…

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…

How To Quickly Insert Blank Rows Between Existing Rows In Excel

Sometimes, you may need to dynamically insert blank rows between each of the existing rows into your Worksheet. Although blank rows are generally bothersome, in some situations, the final formatted version of your report requires them to separate data. This tip will help you quickly insert blank rows between multiple…

How to Quickly Extract Pictures From An Excel File

If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. There’s no build-in function to do this in Excel. Here are two simple ways to quickly extract pictures from an Excel file. 1. Open your Excel file, click…