Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Excel form where data is listed for each individual client
horizontally.... Date Name Phone ect... I have the form all formatted with borders, bold text in certain cells, etc. Adding entries is no problem, but once the client has been contacted and their needs taken care of I want to be able to delete them and have everyone else move up to fill in the gap(s). That way if I need to print the sheet off, it doesn't have gaps in it. I will only keep 25 entries on the sheet at a time. I can highlight and delete an entire row, but then I don't have the cell borders and formatting for the cells below to keep 25 formatted slots on the page. Is there a way to set up this electronic sheet so the sheet format stays intact but you can delete an entry and everyone else schooches up to fill in the blank row and leave the empty formatted form rows below the filled in data rows? Thanks for your help! Kass |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel form not functioning correctly | Excel Discussion (Misc queries) | |||
Open Form Automatically in Excel File | New Users to Excel | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Deleting duplicate entries in an Excel list | Excel Worksheet Functions |