Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-04-2013, 04:50 AM   #1
Daemon Poster
 
ja6on's Avatar
 
Join Date: Oct 2011
Location: Wales, UK.
Posts: 544
Default Any Excel wizards?

Im using office excel 2003 but i do have 2010 starter.

Im trying to have two excel spreadsheets open at the same time.

so i can copy an paste details from one to the other as i go through my customer list, a sort of list of customers iv done, and list of what needs to be done.

However you can only have one excel displayed at a time, soo i have two books open. But everything i write on book one is also being written to book two, can this be changed to accomplish what i want?
__________________

__________________
I5 3570k oc'd 4.3Ghz, CM hyper 212+cooler, Gskill 8gb 1600Mhz, Gigabyte 7970hd oc edition, msi z77a-g45. Samsung 830 256gb SSD, WD cavier black Hdds
ja6on is offline   Reply With Quote
Old 09-04-2013, 05:05 AM   #2
Daemon Poster
 
ja6on's Avatar
 
Join Date: Oct 2011
Location: Wales, UK.
Posts: 544
Default Re: Any Excel wizards?

forgot to mention, i want the books separate as each will have a different save.

---------- Post added at 10:05 AM ---------- Previous post was at 10:00 AM ----------

also i cant seem to put a phone no in a cell as all uk no. start with a zero an it deletes the zero?



edit, sorted the phone no. issue
__________________

__________________
I5 3570k oc'd 4.3Ghz, CM hyper 212+cooler, Gskill 8gb 1600Mhz, Gigabyte 7970hd oc edition, msi z77a-g45. Samsung 830 256gb SSD, WD cavier black Hdds
ja6on is offline   Reply With Quote
Old 09-04-2013, 07:16 AM   #3
Daemon Poster
 
dale's Avatar
 
Join Date: Mar 2012
Location: Taiwan
Posts: 1,008
Default Re: Any Excel wizards?

You could use external reference [office.microsoft.com].
__________________
distrACT -- an open community
● It helps to ask questions effectively
● Please join Server admins social group if you are into servers
dale is offline   Reply With Quote
Old 09-04-2013, 08:59 AM   #4
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Any Excel wizards?

Hi,

Try opening two Excel programs.
Sounds like launch Excel 2003, open speadsheet 1, launch Excel 2003 again then open spreadsheet 2.

That should work as it opens 2 Excel instances and NOT 1 instance that loads 2 worksheets.
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-04-2013, 09:24 AM   #5
Daemon Poster
 
ja6on's Avatar
 
Join Date: Oct 2011
Location: Wales, UK.
Posts: 544
Default Re: Any Excel wizards?

nope as u can only view one at a time, so both would be open in the taskbar but cant see both at same time.
__________________
I5 3570k oc'd 4.3Ghz, CM hyper 212+cooler, Gskill 8gb 1600Mhz, Gigabyte 7970hd oc edition, msi z77a-g45. Samsung 830 256gb SSD, WD cavier black Hdds
ja6on is offline   Reply With Quote
Old 09-04-2013, 12:41 PM   #6
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,940
Default Re: Any Excel wizards?

You certainly can see 2 workbooks open at the same time but you need to resize the Excel windows to be able to do it. Hopefully you have enough screen real estate to do what you want.

They could be displayed one above and one below or side by side.
strollin is offline   Reply With Quote
Old 09-04-2013, 02:53 PM   #7
Beta Member
 
Join Date: Sep 2013
Location: Romanie
Posts: 1
Default Re: Any Excel wizards?

I'm due for release in 2013, al excel I have a problem. Is there a way to get back to the old look?
ht.george is offline   Reply With Quote
Old 09-04-2013, 09:05 PM   #8
Daemon Poster
 
dale's Avatar
 
Join Date: Mar 2012
Location: Taiwan
Posts: 1,008
Default Re: Any Excel wizards?

If you mean the oversized top menu panel, you could always collapse it. But no, no going back to the old look otherwise.
__________________
distrACT -- an open community
● It helps to ask questions effectively
● Please join Server admins social group if you are into servers
dale is offline   Reply With Quote
Old 09-05-2013, 06:34 AM   #9
Daemon Poster
 
ja6on's Avatar
 
Join Date: Oct 2011
Location: Wales, UK.
Posts: 544
Default Re: Any Excel wizards?

Quote:
Originally Posted by strollin View Post
You certainly can see 2 workbooks open at the same time but you need to resize the Excel windows to be able to do it. Hopefully you have enough screen real estate to do what you want.

They could be displayed one above and one below or side by side.

Aaaahh thanks strollin. get what you mean now. exactly what i was looking for.
__________________
I5 3570k oc'd 4.3Ghz, CM hyper 212+cooler, Gskill 8gb 1600Mhz, Gigabyte 7970hd oc edition, msi z77a-g45. Samsung 830 256gb SSD, WD cavier black Hdds
ja6on is offline   Reply With Quote
Old 09-05-2013, 02:43 PM   #10
Daemon Poster
 
ja6on's Avatar
 
Join Date: Oct 2011
Location: Wales, UK.
Posts: 544
Default Re: Any Excel wizards?

Quote:
Originally Posted by Santa Clause View Post
excel is the worst system ever created... window 95 is the best by far.
Lol wtf? Excel is a program? not a system. And no just no, win 95 is not the best by any stretch of the imagination..

(Im guessing you're a troll, but i bit anyway)
__________________

__________________
I5 3570k oc'd 4.3Ghz, CM hyper 212+cooler, Gskill 8gb 1600Mhz, Gigabyte 7970hd oc edition, msi z77a-g45. Samsung 830 256gb SSD, WD cavier black Hdds
ja6on is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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



All times are GMT -5. The time now is 05:52 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0