Checkout my video series on How to Create a Personal Macro Workbook. Here are the macros that you can copy/paste to your Personal Macro Workbook. Move-Selection-Macros.zip Download Video: How to Add Code to Your Personal Macro Workbook ![]() You can download the file that contains the macros here. In this case we only want to move one row or column, so we will set the RowOffset or ColumnOffset parameter values accordingly. We can use the RowOffset and ColumnOffset parameters to tell Offset how many rows or columns to move. The Range.Offset property allows us to reference the range to above, below, left, or right of the current selected range (Selection). This technique uses a set of four very simple macros. That included using an Excel Table or a macro. In a previous post & video I explained 2 ways to select rows/columns with blanks. This is very useful when you want to select an adjacent row or column that contains blank cells. So, in this post I share a way to accomplish this same task with a single keyboard shortcut or button press. ![]() That only works if one row or column is selected, and is a lot of keystrokes. For example, we can move the selection one column to the right using the following shortcut sequence: Shift+Right Arrow, Tab, Shift+Right Arrow There are other ways to do this natively in Excel using a combination of shortcuts. Have you ever wanted to quickly select a row or column next to the current selection? The following screencast shows an example. This technique is great for selecting rows or columns that contain blank cells. Bottom line: Learn how to create custom shortcuts to move the selection to an adjacent range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |