Another Excel Question - Help Please

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Kammmie

Thread Starter
Joined
Aug 14, 2001
Messages
132
If I have 10 worksheets in a workbook and I only want to save the first worksheet how would I do that ? Is their a way or would I have to link the information ? Could someone tell me what to do please ?
 
Joined
Oct 29, 2001
Messages
2,056
not sure what you have or want to do

1. separate sheets, no links between them
- right click on each sheet tab and delete - long and tedious method OR
- right click on sheet you want to save, copy or move to new book, save the new book

2. sheets are linked, final/results sheet to be saved separately

- right click on sheet you want to save, copy or move to new book, save the new book
- when you open it, it will ask if you want to open the linked sheet also for update, changes

- changes need to be made on the source sheet to show up on the final/results sheet
 

Kammmie

Thread Starter
Joined
Aug 14, 2001
Messages
132
The first sheet is designed to pull information off the 9 other sheets ... the other 9 sheets have tables, etc.

In the end, only the first sheet needs to be saved once information is entered on it. I want to see if their is a way just to save that sheet. Did I explain it better ?
 
Joined
Oct 29, 2001
Messages
2,056
2 scenarios

static (use once, no updating) vs dynamic (always adding info to sheets 2-10, but want a "picture" of sheet 1)

- right click on sheet 1, copy, place before sheet 1 (you'll get a copy_sheet 1 name)
- highlight the sheet (grey cell, 0,0 left of a and above 1)
- copy
- paste special - values
- (you may need to paste special - format also)

now you have a copy_sheet 1 which has all your results but is no longer linked to sheets 2-10

- right click on copy_sheet 1, copy or move to new book, save the new book
- delete the old book if need be.

or you can save the whole thing, keep updating data, then repeat the copy sheet, copy/paste special routine to get a static sheet for printing etc
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Click on the TAB of the first unwanted sheet.

Holding your ctrl key down, click on each tab of all the unwanted sheets.

When all the sheets you want to delete have white-background tabs, let go of the shift key.

From the menu, choose Edit-Delete sheet.

Hope it helps.
 
Joined
Oct 29, 2001
Messages
2,056
Originally posted by Dreamboat
Click on the TAB of the first unwanted sheet...
oh yeah, keyboard/mouse commands
forgot about those, usually using the left hand to drink coffee LOL

they work fast - but still not sure if kammmie is using linked sheets or not to get his/her results into sheet 1 and needs the sheet references
 

Kammmie

Thread Starter
Joined
Aug 14, 2001
Messages
132
The sheets do contain information that links back into the first worksheet. How would I go about sheet references ??
 
Joined
Oct 29, 2001
Messages
2,056
Originally posted by Kammmie
The sheets do contain information that links back into the first worksheet. How would I go about sheet references ??
kammie

to keep the sheet references, do nothing, they are there and will stay there until you change something. the cell references are made automatically when you copy cells from one worksheet and place them in another.

if you want a 'static' (reference removed) sheet, then:
refer to my earlier post headed by 2 scenarios where i describe how you can add a static sheet to your workbook and then leave it in the workbook, or copy it to a new workbook.

basically you copy the sheet, then use the paste special, values command to remove the references, leaving the values only.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top