extra columns

L

lpeterson

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?
 
S

sb1920alk

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.
 
G

Gord Dibben

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

You can hide them by selecting and Format>Hide.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I cannot delete the extra rows or columns in Excel 2007 2
IF Statement Problem 4
lookup row number 3
autofill variable lenght column w/ sequential numbers using VBA 2
Vertical scroll bar length 1
Deleting unneeded rows and columns 1
Extra Space With Buttons 2
stop sorting titles please 3

Top