If the column of data is short, press PageUp if the column is long, it probably would be easier to press Ctrl+Home (with the Shift key still down) and then click on the top cell of the control column with your mouse. 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. The line automatically comes up blue but while the draw tool was open I clicked and changed mine to black. Regards, Bob J.When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Then, go to the 'Insert' tab & select 'Shapes' & 'Line.' Choose the 1st line (straight line) and draw a line under your text (hold down the shift key while drawing to make a straight line). PS: Depending on how large the range to be deleted is it might help to Filter the list on a common criteria, then select & delete the found set of records.ĪI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. Hold Shift while you click the ending cell. If you aren't sure of the starting & ending cell references, another option is. Use the Name Box the left end of the Formula Bar. Two of the most efficient ways I know of, though, are to. Selecting cells, columns, or rows in Excel Help on: When you type at least three dashes, underscores, or equal signs in a paragraph by themselves and press Enter, the characters are automatically converted to a single, thick single, or double horizontal line, respectively. There are quite a few techniques for easily selecting ranges of cells in the subtopic: Word automatically formats items like quotes, bulleted and numbered lists, and horizontal lines. #How to delete a continuous row underline in excel how to#
It isn't that difficult to do once you learn how to use the features of the program. Select what is to be affected when you give the delete command. Well, you can't delete anything unless you tell the program what you want to delete, and the way you do that is to
0 kommentar(er)
