Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have imported data into excel and in the resulting worksheet column A
contains zip codes. The zip codes are one cell above the coordinating row of data that I need to work with. How do I move the zip codes down one cell to line up with the rest of the row. My worksheet is over 100 rows of data. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Right-click on A1, then do Insert ShiftCellsDown ok....
Vaya con Dios, Chuck, CABGx3 "Bonnie, OH" wrote: I have imported data into excel and in the resulting worksheet column A contains zip codes. The zip codes are one cell above the coordinating row of data that I need to work with. How do I move the zip codes down one cell to line up with the rest of the row. My worksheet is over 100 rows of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to index the first blank cell in a column of data | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |