| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| Adding a Blank Line with Change in Name | Excel Discussion (Misc queries) | |||
| Adding a value to blank cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
