ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Working with a speadsheet of 15,000 rows (https://www.excelbanter.com/excel-discussion-misc-queries/51426-working-speadsheet-15-000-rows.html)

Sarah Arzo

Working with a speadsheet of 15,000 rows
 

After sorting the last name in ascending order and deleting several
columns from a spreadsheet of 15, 000 rows, my new speadsheet has
switched the first name and last name column, but has kept the Zipcode,
state, city, ant all the addres fields intact. Can you help me out in
what did I do wrong in this process that I've been doing for so long.
Thanks...Sarah


--
Sarah Arzo
------------------------------------------------------------------------
Sarah Arzo's Profile: http://www.excelforum.com/member.php...o&userid=28243
View this thread: http://www.excelforum.com/showthread...hreadid=477973


Dave O

Working with a speadsheet of 15,000 rows
 
So your spreadsheet should say
First Name / Last Name / Address / zip

but instead it says
Last Name / First Name / Address / zip

If yes, right click on the column letter that holds First Name, and
select Cut. Right click on the column letter that holds Last Name and
select Insert Cut Cells.



All times are GMT +1. The time now is 10:52 PM.

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