#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default extra columns

i have an infinite # of extra columns (clicking on a row number and giving it
a border). how can i delete all the extra columns?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default extra columns

You can't delete the extra columns, but you can hide them. Click the column
header of the first column you would like to hide, then while holding Ctrl
and Shift, press the Right Arrow key. This will select all of the columns you
want to hide. Right-click on this selection and choose Hide.

"lpeterson" wrote:

i have an infinite # of extra columns (clicking on a row number and giving it
a border). how can i delete all the extra columns?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default extra columns

You cannot delete the columns and rows Excel has given you on a worksheet.

You can hide them by selecting and FormatHide.


Gord Dibben MS Excel MVP

On Fri, 30 May 2008 12:24:01 -0700, lpeterson
wrote:

i have an infinite # of extra columns (clicking on a row number and giving it
a border). how can i delete all the extra columns?


Reply
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
Excel 2007 - extra columns [email protected] Charts and Charting in Excel 2 July 28th 07 02:41 PM
adding extra digits to columns Graham at Mac's Excel Discussion (Misc queries) 2 August 21st 06 11:24 AM
adding extra digits to columns Muhammed Rafeek M Excel Discussion (Misc queries) 0 August 21st 06 10:35 AM
extra rows and columns Wooster New Users to Excel 3 December 4th 05 01:45 AM
Extra Columns Peco Worker Excel Discussion (Misc queries) 3 May 23rd 05 01:17 PM


All times are GMT +1. The time now is 10:36 AM.

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

About Us

"It's about Microsoft Excel"