Do one of the following: To move rows or columns, point to the border of the selection. When the pointer becomes a move pointer, drag the rows or columns to another location. To copy rows or columns, hold down CTRL while you point to the border of the selection. When the pointer becomes a copy. Nov 06, 2003 Moving column contents down one row? Is there an easy way to have Excel move the contents on an entire column down one row? I have a spreadsheet that has data in column B that I need to line up with the data on the next row down in column C (accross the entire worksheet).
![Excel move rows down by 1 Excel move rows down by 1](https://i.ytimg.com/vi/lFfwB2DzUMY/maxresdefault.jpg)
Is there an easy way to have Excel move the contents on an entire column down one row? I have a spreadsheet that has data in column B that I need to line up with the data on the next row down in column C (accross the entire worksheet). Just moving the contents of column B down one cell would save a lot of time, but if there is an easy way to add another function, that would completely automate the procedure, here is the rest of it. After the cell contents are moved down one row, take a look at the cell that is now the next row down and one column to the right to see if there is anything entered in that cell. If there is anything entered, copy itself to the next cell down. Example: move B1 to B2, then look at C3.
If there is an entry in C3, copy B2 into B3. If there is no entry in C3, leave B3 blank. Go all the way down column B doing this same thing.is it possible? Again, just having Excel move the contents of column B down one row would be great, I could then go through and manually copy the column B entries that need to be duplicated to line up with column C.
Problem: I need to rearrange some rows or columns. Do you have anything faster than the other methods you've described? Strategy: You might find this method faster than the others: • Select an entire row by pressing Shift+Spacebar or select an entire column by pressing Ctrl+Spacebar. • Grab the thick border around the row or column. Hold down the Shift key and drag the row/column to a new location.
When you use Shift+drag, Excel will basically cut the cells and then insert them where you release the mouse. Gotcha: The Shift+drag is critical.
If you simply drag, you will do a cut and paste. If you Ctrl+drag, you will do a copy and paste. Snipping tool in mac os x. Both of these will overwrite the destination cells. Only Shift+drag will insert the cells. • Shift-drag the border. • You've selected the entire row. Grab the top border while holding down Shift.
As you drag, an insertion cursor shows where the row would be moved to. • Release the mouse.
Excel will insert the row and shift the other rows down. MrExcel.com & related websites debuted on November 21, 1998. ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided 'as is' and we do not guarantee that they can be used in all situations.
This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com and ExcelArticles.com running. You can earn a commission for sales leads that you send to us by.| Excel® is registered trademark of the Microsoft Corporation. MrExcel® is a registered trademark of Tickling Keys, Inc.
© 1998 - 2019 by MrExcel Publishing. All rights reserved.