I want to copy all 25 worksheets to a new file and don't know how to do this easily.
I want to copy all 25 worksheets to a new file and don't know how to do this easily.
If your workbook consists of just the 25 sheets then you can do a save as and create a new workbook.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
assume you know how do do it for one sheet with the move or copy feature
if your workbook has more than 25 sheets, you can press CTRL + left click every sheet you want to move/copy
after you have selected all that you want you can right click (on the sheetname) and select move or copy
alternatively you can select and delete every other sheet that you dont want and use alans SAVEAS method mentioned above
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks