ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to move contents in column up one cell (https://www.excelbanter.com/excel-worksheet-functions/227898-how-move-contents-column-up-one-cell.html)

pmt

how to move contents in column up one cell
 
How to I move contents in a column up one cell/row within same column?

Gord Dibben

how to move contents in column up one cell
 
EditDeleteShift Cells Up


Gord Dibben MS Excel MVP

On Thu, 16 Apr 2009 07:37:03 -0700, pmt
wrote:

How to I move contents in a column up one cell/row within same column?



klswvu[_2_]

how to move contents in column up one cell
 
A B C D
1 XXXXX XXXXX XXXXX
2 XXXXX XXXXX XXXXX XXXXX
3 XXXXX XXXXX XXXXX XXXXX
4 XXXXX

If you want all the rows in C to shift up...
Right Click - Delete - Shift Cells Up

How to I move contents in a column up one cell/row within same column?



All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com