ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   extra columns (https://www.excelbanter.com/excel-discussion-misc-queries/189447-extra-columns.html)

lpeterson

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?

sb1920alk

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?


Gord Dibben

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?




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com