ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   deleting columns on multiple sheets (https://www.excelbanter.com/excel-discussion-misc-queries/188811-deleting-columns-multiple-sheets.html)

school counselor

deleting columns on multiple sheets
 
I have 330 sheets and need to delete the same columns on all of the sheets.
How can I do this without clicking on each page? Thanks!

Norman Jones[_2_]

deleting columns on multiple sheets
 
Hi Counselor,

Try selecting the first sheet and then, to
select all sheets, shift-click the last sheet.

Then delete the offending column.


---
Regards.
Norman

"school counselor" <school wrote in
message ...
I have 330 sheets and need to delete the same columns on all of the sheets.
How can I do this without clicking on each page? Thanks!



school counselor[_2_]

deleting columns on multiple sheets
 


"school counselor" wrote:

I have 330 sheets and need to delete the same columns on all of the sheets.
How can I do this without clicking on each page? Thanks!


school counselor[_2_]

deleting columns on multiple sheets
 
Thanks! That made it so much faster! I appreciate your help!

"Norman Jones" wrote:

Hi Counselor,

Try selecting the first sheet and then, to
select all sheets, shift-click the last sheet.

Then delete the offending column.


---
Regards.
Norman

"school counselor" <school wrote in
message ...
I have 330 sheets and need to delete the same columns on all of the sheets.
How can I do this without clicking on each page? Thanks!



The Rain

deleting columns on multiple sheets
 
Right click in any sheet tabselect all sheetsDo your assignment.
--
Can''''t hear the Rain ?
Then listen to it.


"school counselor" wrote:



"school counselor" wrote:

I have 330 sheets and need to delete the same columns on all of the sheets.
How can I do this without clicking on each page? Thanks!



All times are GMT +1. The time now is 10:03 PM.

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