Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear friends,
I am using Seagate Infordesktop Software to run reports in Excel 2002 format. My report was designed with an empty row between each data line from top to bottom. I need to eliminate those empty row spacing without altering the sequence of the data lines. May I know is there any shortcut or keyboard command for doing this ? Currently I am sorting block by block of the data to eliminate the rows. I cannot do it in one go for the entire worksheet asonly the first column of the line of each block of data has a reference number. I would be glad if some one who is knowledgable in MS Excel 2002 Spreadsheet could advise me on this. Thanks Low Seng Kuang Malaysia -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
rows 1-2 missing from excel worksheet | Excel Worksheet Functions | |||
Unable to group rows or columns on an excel worksheet | Excel Discussion (Misc queries) | |||
program excel worksheet to automatically not print blank rows | Excel Worksheet Functions | |||
empty rows at bottom of worksheet | Excel Discussion (Misc queries) |