Excel Move or Copy

%3CLINGO-SUB%20id%3D%22lingo-sub-2027230%22%20slang%3D%22en-US%22%3EExcel%20Move%20or%20Copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EOK%20I'm%20sure%20this%20is%20simple...BUT...I've%20been%20using%20Microsoft%20365%20Family%20for%20a%20couple%20of%20years%20now.%20Excel%20user%20for%20over%2025%20years.%20Usually%20able%20to%20figure%20out%20%22user%20error%22%20myself%2C%20this%20time%20I'm%20stumped.%20I%20have%20a%20family%20bill%20sheet%20in%20excel%20I%20have%20used%20for%20over%2012%20years.%20I%20recently%20added%20some%20features%20to%20track%20expense%20categories.%20Copied%20it%20to%20another%20worksheet%20as%20a%20version%202%20to%20make%20additional%20changes.%20I%20have%20now%20finished%20version%202%20to%20its%20final%20state.%20But%20when%20I%20went%20to%20make%20a%20copy%20for%20the%20next%20month%2C%20right%20click%2C%20and%20options%20Insert%2C%20Delete%20Rename%2C%20Move%20or%20Copy%2C%20Tab%20Color%2C%20Hide%2C%20Unhide%20are%20not%20available%20to%20choose%20from%2C%20the%20only%20choices%20are%2C%20View%20Code%2C%20Protect%20Sheet%20or%20Select%20all%20Sheets.%20I%20am%20missing%20something%20simple%2C%20and%20after%20many%20wasted%20hours%20spent%20trying%20to%20figure%20it%20out%2C%20I%20need%20your%20expert%20advice.%20PLEASE%20HELP.%20Bob%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2027230%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027510%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Move%20or%20Copy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027510%22%20slang%3D%22en-US%22%3EJust%20a%20guess%2C%20are%20the%20sheets%20grouped%3F%3C%2FLINGO-BODY%3E
New Contributor

OK I'm sure this is simple...BUT...I've been using Microsoft 365 Family for a couple of years now. Excel user for over 25 years. Usually able to figure out "user error" myself, this time I'm stumped. I have a family bill sheet in excel I have used for over 12 years. I recently added some features to track expense categories. Copied it to another worksheet as a version 2 to make additional changes. I have now finished version 2 to its final state. But when I went to make a copy for the next month, right click, and options Insert, Delete Rename, Move or Copy, Tab Color, Hide, Unhide are not available to choose from, the only choices are, View Code, Protect Sheet or Select all Sheets. I am missing something simple, and after many wasted hours spent trying to figure it out, I need your expert advice. PLEASE HELP. Bob

3 Replies
Just a guess, are the sheets grouped?

@BradD Yes they are.  Cannot make changes to any of them

Then they need to be ungrouped before you can do anything regarding moving and copying.