New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Operating System General OS operation information and support

Tracking Changes


Post Reply New Thread Subscribe

 
Thread Tools
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
Is it possible to go back and track the changes I have made to an Excel database say for the past week or two? I have a rather large database that I am constantly updating and I would now like to add those changes to a newer version of the same database. Or do I have to do a split screen and scan eack and every line to see any changes (some 19,000 lines)?
QUOTE Thanks
lclev

 
lclev's Avatar
 
Member Since: Jul 24, 2013
Location: Lewisburg, Ohio
Posts: 245
lclev is a jewel in the roughlclev is a jewel in the rough
Mac Specs: MBP 15" Early 2011, i7, 16GB mem, 1TB HD; MB Air 13", Mid 2013, i5, 4GB mem, 250GB HD

lclev is offline
If you have turned on "track changes", yes. Here is a link on how to do that.

Turn change tracking on or off - mac excel

If you have not turned tracking on previously I believe you are out of luck.

Lisa
QUOTE Thanks
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
I guess I should have mentioned that have Excel 2008 and when I just now found "Track Changes" it only offers to track my changes in color and I am supposing that it would only track the changes I make henseforth not changes I have already made, am I right?
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,648
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
That's right. As Lisa pointed out, the "Track Changes" option would have had to be turned on previously. In other words, unless you turned it on when you first edited the sheet, those changes will not be shown. It's the same for Office 2008 Excel as well as 2011 Excel.
QUOTE Thanks
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
Well, it looks like I've got some work ahead.

While I have you here, the last time I used the split screen I could not remember how to sync the two so they move together, what is the command for this feature?

Thank you both for the help!
QUOTE Thanks
lclev

 
lclev's Avatar
 
Member Since: Jul 24, 2013
Location: Lewisburg, Ohio
Posts: 245
lclev is a jewel in the roughlclev is a jewel in the rough
Mac Specs: MBP 15" Early 2011, i7, 16GB mem, 1TB HD; MB Air 13", Mid 2013, i5, 4GB mem, 250GB HD

lclev is offline
If I am understanding you correctly you want to split the screen and be able to scroll both at the same time in sync. In the 2011 version you click on the layout tab. On the right side of that ribbon is the Window section. In that section their are five buttons. You are looking for the button with the pop up that says: "Divide the current window into multiple resizable panes." Click that button and you should see a verticle and a horizontal gray bar appear on your spread sheet. You can grab the gray bars and it will allow you to resize the windows or move the bar off the spreadsheet if you don't want it. Once the bar is in place the scroll will sync automatically.

I hope this is clear. If not let me know and I will try to clarify.

Lisa
QUOTE Thanks
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
Lisa,
I have 2008 Excel and I hit 'Windows' / 'Arrange' say 'horizontal' and I get my two databases in a split screen for mat. One is highlighted and that one scrolls, when I click on the other sheet, it is highlighted and scrolls but both are independent. There is/was a button to hit that would lock the two together and they would scroll at the same rate, so I can CK info from one to the other.

I just tried it but cannot find the magic button to lock them. And "grab" does nothing at all!
QUOTE Thanks
lclev

 
lclev's Avatar
 
Member Since: Jul 24, 2013
Location: Lewisburg, Ohio
Posts: 245
lclev is a jewel in the roughlclev is a jewel in the rough
Mac Specs: MBP 15" Early 2011, i7, 16GB mem, 1TB HD; MB Air 13", Mid 2013, i5, 4GB mem, 250GB HD

lclev is offline
Ok, I admit to being unfamiliar with 2008 so I have found a link that might help. Scroll to the bottom of the article and it talks about spitting the screen. It seems the process is different in 2008 as compared to 2011.

https://www.uwec.edu/help/excel07/ws-nav-m.htm

Hope this helps.

Lisa
QUOTE Thanks
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
Lisa,

There is a difference between "Split Screen" and "Arrange" altho they do similar things. Split Chops the screen into smaller bites to give a close-up look at one section of a large file. While "Arrange" allows one to see two different files at the same time and compare one to the other. I have used "Arrange" many times to do this same procedure, but it has been (fortunately) several years since I did it last.

I looked at the URL you added but it dealt with "Split" and did not help. But I do thank you for the effort.
QUOTE Thanks
lclev

 
lclev's Avatar
 
Member Since: Jul 24, 2013
Location: Lewisburg, Ohio
Posts: 245
lclev is a jewel in the roughlclev is a jewel in the rough
Mac Specs: MBP 15" Early 2011, i7, 16GB mem, 1TB HD; MB Air 13", Mid 2013, i5, 4GB mem, 250GB HD

lclev is offline
I guess I am not understanding what you need. Here is another suggestion for scrolling two different spreadsheets side by side in sync. Not quite sure it is the right version of office:

View Two Excel Spreadsheets at Once | the MOST

I also found Office for 2008 the missing manual on google books and it is searchable. Maybe this can help:

Office 2008 for Macintosh: The Missing Manual: The Missing Manual - Jim Elferdink - Google Books

Lisa
QUOTE Thanks
Roger442

 
Member Since: Apr 16, 2013
Posts: 27
Roger442 is on a distinguished road

Roger442 is offline
Lisa,

I took a look at the book you showed me and I think that it would be a good buy for me. I didn't know that anything like this existed and I think it wii do the job.

Thanks again for all your help and patience with me.
QUOTE Thanks

Post Reply New Thread Subscribe


« HELP! OSX Mavericks problems | Import Contacts to 10.9 »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

All times are GMT -4. The time now is 11:56 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?