Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Maurice
You talk about columns, but say your sheet has a large number of Empty rows. Which is it that you want? Columns can be hidden Rows can be Hidden. If your data goes down from row 1 to row 30, for example, and you wanted to hide all rows below this, then Place cursor in A31Control+Shift+Arrow down will highlight rows 31 through 65536 (XL2003 and earlier)right clickHide Similarly, if you wanted to hide all columns to the right of column M, place cursor in N1Control+Shift+Arrow right to select columns N to IV -- Regards Roger Govier "Maurice" wrote in message ... Working with Excel 2003. I have a spreadsheet with a large numbe of empty rows. Have tried to delete them but more appear. I have also tried the hide command with no success. Seeking guidance on how to display just the columns that have data. Advice sought |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing spaces from columns | Excel Worksheet Functions | |||
Removing Duplicate Pairs(2 Columns) | Excel Discussion (Misc queries) | |||
Removing columns (not hide or white-out). | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) |