ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Adding Blank Cells ? (https://www.excelbanter.com/new-users-excel/168850-adding-blank-cells.html)

Robert11

Adding Blank Cells ?
 
Hello,

Lets say I have a page of data pretty well filled up.

I am in column, e.g., D, and would just like to add a few blank cells
between some existing data in this column only.

I can't do a Insert a line as that would mess all the other columns also.

How can I easily add just a few blank cells, And have Everything below these
new blank cells
move down accordingly and safely ?

Thanks,
Bob



David Biddulph[_2_]

Adding Blank Cells ?
 
Select the range of cells where you want the insertion.
Either right click and choose Insert, or go to the Insert menu and choose
Cells.
Select "move cells down"
--
David Biddulph

"Robert11" wrote in message
. ..
Hello,

Lets say I have a page of data pretty well filled up.

I am in column, e.g., D, and would just like to add a few blank cells
between some existing data in this column only.

I can't do a Insert a line as that would mess all the other columns also.

How can I easily add just a few blank cells, And have Everything below
these new blank cells
move down accordingly and safely ?

Thanks,
Bob




Robert11

From OP For David: Adding Blank Cells ?
 
Hi,

Much thanks.

Happy holidays.

Bob

------------------------
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Select the range of cells where you want the insertion.
Either right click and choose Insert, or go to the Insert menu and choose
Cells.
Select "move cells down"
--
David Biddulph

"Robert11" wrote in message
. ..
Hello,

Lets say I have a page of data pretty well filled up.

I am in column, e.g., D, and would just like to add a few blank cells
between some existing data in this column only.

I can't do a Insert a line as that would mess all the other columns also.

How can I easily add just a few blank cells, And have Everything below
these new blank cells
move down accordingly and safely ?

Thanks,
Bob







All times are GMT +1. The time now is 05:06 AM.

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