Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
excel question
Old 12-20-2008, 11:33 AM   #1
Thinks s/he gets paid by the post
simple girl's Avatar
 
Join Date: Sep 2006
Posts: 2,505
excel question

OK, I know there are a lot of computer gurus on here, so I thought I'd ask for some help with an excel problem I'm having.

I have made a sheet up ("sheet 1") the way I want it. I used the Page Break Preview to get it set up the way I want (ie. column width and moving the blue lines to get everything to fit on one page). I saved it.

However, when I copy and paste Sheet 1 into a blank Sheet 2, my column settings get screwed up, and it presents it as 2 pages. I have to manually readjust everything. Is there something I can do to just get it to paste perfectly?
__________________

__________________
simple girl
less stuff, more time

(49, married; DH 53. I am fully retired as of 2015 (well ok, I still work part-time but only because I love the job and have complete freedom to call off if I want to travel with hubby for work), DH hopes to fully retire 2018 when he turns 55 to access 401K penalty-free...although he may decide to do part-time consulting)
simple girl is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 12-20-2008, 12:05 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,264
Two options (at least in my old version of excel - 2004 for the Mac):

1) Click the upper left corner of the sheet ( a diamond shaped thing like this: <> ). This should select the entire sheet. Copy, PAste to new sheet.


2) Right (or control) click on the sheet tab on the bottom. Choose 'Move or copy". This will bring up a dialog, check 'create a copy', and also select 'new book' from the menu. This should copy the sheet entirely.

I will skip the rant on all the poor user interface design choices that Microsoft made for this simple task....


-ERD50
__________________

__________________
ERD50 is offline   Reply With Quote
Old 12-20-2008, 12:08 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,964
Quote:
Originally Posted by simple girl View Post
OK, I know there are a lot of computer gurus on here, so I thought I'd ask for some help with an excel problem I'm having.

I have made a sheet up ("sheet 1") the way I want it. I used the Page Break Preview to get it set up the way I want (ie. column width and moving the blue lines to get everything to fit on one page). I saved it.

However, when I copy and paste Sheet 1 into a blank Sheet 2, my column settings get screwed up, and it presents it as 2 pages. I have to manually readjust everything. Is there something I can do to just get it to paste perfectly?
You might also try "paste special" instead of "paste", if the "copy sheet" doesn't work as expected.
__________________
Have Funds, Will Retire

...not doing anything of true substance...
HFWR is offline   Reply With Quote
Old 12-20-2008, 12:16 PM   #4
Thinks s/he gets paid by the post
simple girl's Avatar
 
Join Date: Sep 2006
Posts: 2,505
Quote:
Originally Posted by ERD50 View Post
Two options (at least in my old version of excel - 2004 for the Mac):

1) Click the upper left corner of the sheet ( a diamond shaped thing like this: <> ). This should select the entire sheet. Copy, PAste to new sheet.


2) Right (or control) click on the sheet tab on the bottom. Choose 'Move or copy". This will bring up a dialog, check 'create a copy', and also select 'new book' from the menu. This should copy the sheet entirely.

I will skip the rant on all the poor user interface design choices that Microsoft made for this simple task....


-ERD50

#1 didn't work since the <> apparently isn't in my 2002 version. But #2 worked! (I selected "create a copy" and "move to end" to keep it in the same book.) THANK YOU!!

I would concur that they did not make this a simple task!
__________________
simple girl
less stuff, more time

(49, married; DH 53. I am fully retired as of 2015 (well ok, I still work part-time but only because I love the job and have complete freedom to call off if I want to travel with hubby for work), DH hopes to fully retire 2018 when he turns 55 to access 401K penalty-free...although he may decide to do part-time consulting)
simple girl is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charting Question Telly Other topics 2 04-23-2007 12:00 PM
How can I post an Excel file? accountingsucks FIRE and Money 4 07-10-2006 09:23 AM
Monte Carlo Excel Add-In haha FIRE and Money 4 05-23-2006 11:51 AM

 

 
All times are GMT -6. The time now is 01:22 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.