LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Removing Columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing spaces from columns Joni Hook Excel Worksheet Functions 2 May 26th 06 09:59 PM
Removing Duplicate Pairs(2 Columns) deathswan Excel Discussion (Misc queries) 3 April 1st 06 05:01 AM
Removing columns (not hide or white-out). TrishDB Excel Worksheet Functions 8 April 28th 05 01:24 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
Removing unused or blank rows and columns Mark F Excel Discussion (Misc queries) 2 December 23rd 04 02:39 AM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"