Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 24th 14, 07:50 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 27
Default Column misalignment

I have unknowingly done something to a spreadsheet which has resulted in the numbers entered in column A no longer being aligned to the information in column B and the other columns- they are one row out of place. e.g. The info in B3, C3, D3 etc relates to A2. This misalignment must have occurred during my previous session because I am unable to correct it using the "undo" arrow.
How can I correct this problem, can I somehow lock the cell entries so as to prevent it happening again and what do you think I may have done wrongly to cause this problem?

  #2   Report Post  
Old July 19th 14, 02:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2014
Posts: 4
Default Column misalignment

Select cell A2 and hit CTRL and + at the same time. Choose Shift cells down
from the list of options.

Your data should now be realigned.

Regards
Ken.........................



"Quilp" wrote in message ...


I have unknowingly done something to a spreadsheet which has resulted in
the numbers entered in column A no longer being aligned to the
information in column B and the other columns- they are one row out of
place. e.g. The info in B3, C3, D3 etc relates to A2. This misalignment
must have occurred during my previous session because I am unable to
correct it using the "undo" arrow.
How can I correct this problem, can I somehow lock the cell entries so
as to prevent it happening again and what do you think I may have done
wrongly to cause this problem?




--
Quilp



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
synonym for misalignment maria Excel Discussion (Misc queries) 4 November 20th 09 06:53 PM
Search for a column based on the column header and then past data from it to another column in another workbook minkokiss Excel Programming 2 April 5th 07 01:12 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look [email protected] Excel Programming 2 December 30th 06 07:23 PM
excel to powerpoint- misalignment of ranges k2sarah Charts and Charting in Excel 0 February 20th 06 02:20 PM
paste charts into powerpoint-misalignment k2sarah Charts and Charting in Excel 0 February 18th 06 03:51 AM


All times are GMT +1. The time now is 11:07 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017