LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
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?
 
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 05: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 06:23 PM
excel to powerpoint- misalignment of ranges k2sarah Charts and Charting in Excel 0 February 20th 06 01:20 PM
paste charts into powerpoint-misalignment k2sarah Charts and Charting in Excel 0 February 18th 06 02:51 AM


All times are GMT +1. The time now is 03:34 PM.

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

About Us

"It's about Microsoft Excel"