hostsb.blogg.se - How to delete certain rows in excel vba

Once you select the bottom cell of the column, hold down the Shift key and then move to the top cell with data in your control column. You might need to press Home to move all the way to the left, or press Alt+PageUp to page to the left until you get to the bottom cell of your control column.

So, to go to the bottom-right cell of your data, press Ctrl+End.

Ctrl+Period - Move clockwise to the next corner of a multi-cell selection.

Ctrl+Backspace - Display the active cell.

If you hold down the Shift key with any of these combinations, you’ll extend the selection.Īlso, for getting around a multi-cell selection:

Alt+PageUp - Move one page to the left.

Alt+PageDown - Move one page to the right.

Ctrl+Arrow Key - Move the active cell in the direction of the arrow key to the next cell that contains data and that borders an empty cell.

End, Enter - Select the right-most cell in the used range in the current row of your spreadsheet.

Home - Select the left-most cell in your spreadsheet in the active row.

Ctrl+Home - Select the top-top left cell in your spreadsheet.

Ctrl+End - Select the bottom-right cell in your spreadsheet.

Here are some keyboard shortcuts that will help you to do this easily: If the column is long and your spreadsheet has other data in it, it’s often easier to select the bottom of your column first, and then extend your selection to select the top of your column.

The first step is to select the entire control column. To begin, chose a column of data that has empty cells in the same rows where the other columns of data also have empty cells. The first method works when you want to remove empty rows from your data. I frequently use two quick and easy methods that solve this problem nearly every time.įor both methods, you’ll rely on one column in your data, a column with characteristics that apply to the other columns. At other times, you’ll want to delete rows with irrelevant data. When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete.