I have multiple tabs in a excel
How do I highlight the entire workbook instead of just the tab I'm on
Thanks in Advance
I have multiple tabs in a excel
How do I highlight the entire workbook instead of just the tab I'm on
Thanks in Advance
To select all worksheets in one go, select the first sheet, hold down the Shift key, then select the last sheet. This will group the sheets.
If you provided a better explanation with more details about what you are doing there may be a better solution to accomplish your task.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thanks for the reply,
I'm having problems with the spreadsheet opening up and saving.
It's taking real long to open up & when I try to save it it freezes up sometimes
I'm hoping if I save it to a new excel sheet that might fix the problem
I see how to highlight the whole spreadsheet, but while it is highlighted how do I copy all the tabs at once
Once you have all of the desired sheets selected:
1. Right click on any sheet tab and choose "Move or copy" from the pop up menu
2. In the dialog box, in the "To Book" section, click the drop down and choose "New Book"
3. At the bottom of the dialog make sure "Create a copy" is checked.
For a quick VBA copy solution, you can run this bit of code which will copy all sheets to a new workbook, but you don't get to pick and choose which ones.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks