ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Instead of one by one Undo (https://www.excelbanter.com/excel-discussion-misc-queries/219230-instead-one-one-undo.html)

karthikbalaguru

Instead of one by one Undo
 
Hi,

I created a workbook using excel 2003 .
I was modifying various sheets. But, i want to revert the changes.
But, i am unable to do for more than few operations.

How is it possible to Undo the changes done over the contents of only
one complete
sheet alone instead of Undo'ing one by one ?

Thx in advans,
Karthik Balaguru

Kevin B

Instead of one by one Undo
 
I would suggest that you look up the TRACK CHANGES topic in Help. It enable
to control which changes to accept and which ones to reject over time.

Hope this helps...


--
Kevin Backmann


"karthikbalaguru" wrote:

Hi,

I created a workbook using excel 2003 .
I was modifying various sheets. But, i want to revert the changes.
But, i am unable to do for more than few operations.

How is it possible to Undo the changes done over the contents of only
one complete
sheet alone instead of Undo'ing one by one ?

Thx in advans,
Karthik Balaguru


Stefi

Instead of one by one Undo
 
Backup and restore file copies!

Regards,
Stefi

€˛karthikbalaguru€¯ ezt Ć*rta:

Hi,

I created a workbook using excel 2003 .
I was modifying various sheets. But, i want to revert the changes.
But, i am unable to do for more than few operations.

How is it possible to Undo the changes done over the contents of only
one complete
sheet alone instead of Undo'ing one by one ?

Thx in advans,
Karthik Balaguru


Khoshravan

Instead of one by one Undo
 
As far as I know they will be done in sequential order. So for ordinary undo
you can not force Excel to do only in a specified sheet, unless you write a
Macro for this.
Also keep in mind that if you save the worksheet during your work, undo will
be unavailable.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"karthikbalaguru" wrote:

Hi,

I created a workbook using excel 2003 .
I was modifying various sheets. But, i want to revert the changes.
But, i am unable to do for more than few operations.

How is it possible to Undo the changes done over the contents of only
one complete
sheet alone instead of Undo'ing one by one ?

Thx in advans,
Karthik Balaguru


karthikbalaguru

Instead of one by one Undo
 
On Feb 5, 6:53*pm, Khoshravan
wrote:
As far as I know they will be done in sequential order. So for ordinary undo
you can not force Excel to do only in a specified sheet, unless you write a
Macro for this.


Is it available online ? Can you pls share the link as it would be
very helpful
for various excel sheet dependent activities.

Thx in advans,
Karthik Balaguru


All times are GMT +1. The time now is 04:19 AM.

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