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: show 2 excel files at same time

07 Jan 2010   #1
kimig1

windows 7 ultimate
 
 
show 2 excel files at same time

Some data from Excel sheets is missing. I want to open older, accurate sheet, in order to correct newer version which has lost data. the files are similar, but not identical, and have different names. I can't find a way of having both files open on screen at same time. Sure there is some simple solution to this, but can't work it out! Duh...probably more stupid than usual today.
Help, please?


My System SpecsSystem Spec
.
07 Jan 2010   #2
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there

why not SPLIT vertical or Horizontally

Here's a screenshot --it's excel 2010 but earlier versions have the same option -- you need to arrange windows - you can do it vertically / horizontally etc etc.

Open both worksheets and then arrange the windows

Screenshot shown (remember thougfh this is from EXCEL 2010)

Cheers
jimbo


Attached Thumbnails
-excel.png  
My System SpecsSystem Spec
Reply

 show 2 excel files at same time




Thread Tools






Similar help and support threads
Thread Forum
Excel does not show gridlines on both monitors in a dual monitor setup
Interesting problem, I have a AMD Radeon HD 6300 series adapter, running windows 7 x64. I have a dual monitor setup, the same monitor on each port an Acer S230hl. One port is an HDMI the other is a VGA. the issue i have is that when i have a worksheet open i can see the gridlines to the...
Microsoft Office
Inspect document doesn't show anything, Excel 2010
In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why? Thanks in advance.
Microsoft Office
backup files will only show up if i click show hidden files and folder
Hey Guys, I cannot find a soultion to this problem. I was using my desktop like normal then an error came up saying that there was a hdd failure, and that i needed to scan for errors. all my files disappeared and only this error would come up. There would be hundreds of the same msg spamed on my...
Backup and Restore
Excel 2007: a question about date and time manipulation
I have pasted data in to Excel that is in two columns Col A contains a list of dates, dd/mm/yy; col B times hh/mm/yy. How do I set about calculating and displaying the period in dd/hh/mm/ss that elapsed between col A row B with col B row B, and col A row C with col B row C ?
Software
MPG files don't show accurate time [and resolution]
When I am using Windows Explorer, recently I've noticed that MPG files are showing inaccurate length of time and resolution. As an example, I have a 1 hour MPG and Windows Explorer says the length is 173 hours, 37 minutes and 16 seconds! If I go into the Details tab from the Properties of the...
Music, Pictures & Video
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
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 23:40.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App