#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default Cell Deletion

Is it possible to delete a single cell in Column A to move the data down by
one cell to correctly align with data to the left.

Many thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Cell Deletion

Hi,
Yes you can but if you want to move the data down you have to insert a cell.
Anyway to insert or delete a cell position yourself in the cell which you
want to delete, right click in the mouse delete and it will open some
options, select move up and click OK.
If you want to insert, same procedure but when the options show up select
move data down

"SiH23" wrote:

Is it possible to delete a single cell in Column A to move the data down by
one cell to correctly align with data to the left.

Many thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default Cell Deletion

Hi,

Do one thing probably this migh help you, keep the cursor on the cell you
want to move data of and Crtl+(+) key this will open a small window (insert
window) giving options as 1. shift cells righ, 2. shift cells down, 3. entire
row, 4. entire column. Tick the radio button of shift cells down and Ok
by doing this the data in that particular cell will be shifted down and then
you can match that data as per the other column.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"SiH23" wrote:

Is it possible to delete a single cell in Column A to move the data down by
one cell to correctly align with data to the left.

Many thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional deletion of cell contents Colin Hayes Excel Worksheet Functions 2 August 9th 07 10:31 PM
Restrict cell deletion starguy Excel Discussion (Misc queries) 6 June 23rd 06 11:54 AM
Cell filter deletion Sergio Excel Discussion (Misc queries) 2 January 6th 06 06:54 PM
Prompt Before Cell Deletion Kryptonix New Users to Excel 3 October 17th 05 01:45 PM
#REF! after cell deletion Colin G Eastwood Excel Discussion (Misc queries) 1 December 2nd 04 01:22 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"