Share via

Splitting Excel Online Document

Anonymous
2016-09-14T21:36:45+00:00

I am using Excel Online for work and I have a template that I enter new figures into and the formulas calculate new totals. It is a 2 page workbook and when I enter new totals I want to be able to save one copy with both pages and one copy with only the first page. I cannot figure out how to save just the first page in its own file. Is this possible in the excel online app or do I have to be using the Microsoft Excel program? I am working on a Mac and saving to Onedrive.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Bob Jones AKA CyberTaz MVP 436K Reputation points
2016-09-15T11:36:33+00:00

The desktop versions of Excel provide a Move or Copy feature which enables 1 or more selected sheets to be saved to a new or to a different workbook file. AFAICT, Excel Online does not have a comparable capability... According to the Excel Online Help:

Can I copy a worksheet to another workbook?

Copying a worksheet to another workbook isn’t supported in Excel Online. Learn more about doing this or about using Excel desktop application instead.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest