Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: excel spreadsheet shorted column by mistake

23 Jun 2015   #1
messalion

Windows 7 Ultimate x64
 
 
excel spreadsheet shorted column by mistake

Hello there !!!
I am in a bad situation having made this mistake.
I have a client list with names/dates/purchases/phone numbers etc,my nephew was fooling around and he shorted the phone number list and now ALL the numbers are shorted with the names still intact.

I cant undo that cause its been saved.....i have a backup but without the phone numbers (witch i want VERY MUCH).

Is there anyway i can find a previous version or any other suggestion would be perfect

Thnx a lot and please excuse my bad english


My System SpecsSystem Spec
.
23 Jun 2015   #2
GokAy

Windows 7 Ultimate x64 SP1
 
 

Can you post a screenshot please? Screenshots and Files - Upload and Post in Seven Forums

Did you hide the column or just change formatting perhaps?
My System SpecsSystem Spec
23 Jun 2015   #3
messalion

Windows 7 Ultimate x64
 
 

the column that is messed up is the green one......as you can see the numbers go from 0 to higher.Before the mistake all had the correct numbers inside the green column


Attached Thumbnails
excel spreadsheet shorted column by mistake-manolada.jpg  
My System SpecsSystem Spec
.

23 Jun 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

I don't think there is much you can do about it. Once the spreadsheet has been changed & saved that is it. I know it's a bit late now but it explains how important having back ups is.
My System SpecsSystem Spec
23 Jun 2015   #5
messalion

Windows 7 Ultimate x64
 
 

i "almost" convinced theres no backing up to my problem...but...is there any other way to........."recover" a previous version of the same document ? lets say a save before that has happend ? i remember i have pressed the save button 30 minutes-+ before that happend......
1 more detail.Thats a file from my computer.The file iam managing all the time is from my android tablet (i use it cause of mobility).is there a way to get something out of it ?
My System SpecsSystem Spec
23 Jun 2015   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

If you have a duplicate spreadsheet on your Android Tablet you should be able to copy it back to your computer. I do not copy files from my computer to my phone so I don't know if the websites listed below will work in your case, but it has to be worth trying.

Transfer files, apps & media from Android phone or tablet to microSD - How-To - PC Advisor

https://motorola-global-portal.custh...om-my-computer

How To Transfer Files From Android To PC

Do you use a cloud service such as OneDrive to store some files so you can get access to them remotely, if so then there could be a copy stored there.
My System SpecsSystem Spec
24 Jun 2015   #7
GokAy

Windows 7 Ultimate x64 SP1
 
 

Maybe Shadow copies have backed up that one. Try "shadow explorer" software.
My System SpecsSystem Spec
24 Jun 2015   #8
messalion

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
If you have a duplicate spreadsheet on your Android Tablet you should be able to copy it back to your computer.
how can i have a duplicate in my tablet ?
Quote   Quote: Originally Posted by Ranger4 View Post
Do you use a cloud service such as OneDrive to store some files so you can get access to them remotely, if so then there could be a copy stored there.
No...unfortunately i copy my files using usb cable

Quote   Quote: Originally Posted by GokAy View Post
Maybe Shadow copies have backed up that one. Try "shadow explorer" software.
i think your suggestion is my only option.....ill get back with more details after i used "shadow explorer"

Thnx
My System SpecsSystem Spec
24 Jun 2015   #9
messalion

Windows 7 Ultimate x64
 
 

umm....a little help about "shadow explorer" ? Doesn't seems to find my tablet in its list of drives...it only sees my C drive
My System SpecsSystem Spec
24 Jun 2015   #10
GokAy

Windows 7 Ultimate x64 SP1
 
 

Eh, sorry I haven't followed this thread after I went to sleep last night and there was no mention of the file being on a tablet

Shadow Explorer is only good for files on the PC.

Can you try something? Check the fields in that green column, and see if the values have changed? Maybe it was only the formatting? Check those that are 0 and also ones which have a number showing.
My System SpecsSystem Spec
Reply

 excel spreadsheet shorted column by mistake




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Windows 7 wont allow me to open an Excel spreadsheet
Hi, I've got a similar problem. W7 wont allow me to open an Excel spreadsheet because it says it's already running. But it isnt. It's not shown in the task manager either. How can I find it and close it apart from rebooting? This came about after I copied the the spreadsheet from a backup copy...
Microsoft Office
Display not refreshed when scrolling excel spreadsheet
Help, my excel spreadsheets (not large) do not display properly when I scroll. Some lines repeat, other do not refresh. I minimize the window then maximize it, and it displays OK, but after when I scroll, Excel does not refresh or update the cells properly. The worst case is having a screen...
Graphic Cards
How do I make an Excel Spreadsheet my desktop wallpaper
Hello, I use a simple spreadsheet as a Job Control/Job Progress report in my business. I would like to make it the desktop wallpaper on all of our workstation desktops and my laptop. We run 4 workstation computers (all W7 Professional) off of our server (Windows small business 2003). The...
Themes and Styles
Excel 2010 spreadsheet taking up almost 1gb of memory
So I have a .xlsx spreadsheet of about 1.5mb taking up nearly 1gb of memory. Simple workbook consisting of about 5 sheets with standard formatting and some colors. I deleted all unnecessary rows and columns, ran 449898_intl_x64_zip hotfix, and rebuilt Excel registry and managed to get down...
Microsoft Office
Problem with Excel Spreadsheet
I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to...
Microsoft Office
PDF File data into Excel Spreadsheet ?
I have WIN 7 with Excel 2003. Is it possible to transfer data contained in a .pdf file onto an Ecel spreadsheet ? If it is possible what is the procedure ?
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:37.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App