| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I make cell data automatically shift up when deleting
EXAMPLE:
A B C 1) Dog Bone Leash 2) Cat Catnip Litter 3) Bird Seed Newspaper 4) Cow Grass Manuer 5) Duck Fish Filter 6) Mouse Cheese Hanta Virus If I were to delete the information in row 1, I want everything in row two to shift up automatically. Or... If I were to delete "dog," I would want everything in Column A, and only Column A, to shift up, therefore removing any blank cells in the table. How would I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
| Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
