Excel 2007 question

  • Thread starter Thread starter nip
  • Start date Start date
N

nip

How do you make row one appear the same on each worksheet in a
workbook? and how can you add a column and have it appear on all the
sheets?
 
Enter the common information in Row 1 of, say, Sheet 1.
Then in cell A1 of each subsequent worksheet, enter:
=Sheet1!A1
Copy across as many columns as desired
If you want to change the common Row 1information, do it ONLY on Sheet 1.
 
It might depend on what you mean by "appear" and "add". You could try this
and see if it does what you want. Click on the tab for the first sheet, hold
down the Shift key and click the tab for the last sheet. All the sheets are
now selected. Try doing whatever you were referring to on the displayed
worksheet and, depending on what you are doing, it should be repeated on all
the other selected worksheets.
 
How do you make row one appear the same on each worksheet in a
workbook?  and how can you add a column and have it appear on all the
sheets?
Click to expand...

I wish to make a master worksheet. Across row one will be column
headings. About row 100 I will have 3 or 4 rows where in certain
columns there will be some simple math formulas.
What I would like to do is have this master open when a new worksheet
is added. is this possible? without simply select and copy to new
sheet?
 
You would have to create a workbook with one sheet in it..........your
Master sheet with its formatting etc.

Save As>File Type>MS Excel Template(*.xlt)

Name it SHEET and store it in your XLSTART folder.

This will be the default Insert>New Worksheet.


Gord Dibben MS Excel MVP
 
You would have to create a workbook with one sheet in it..........your
Master sheet with its formatting etc.

Save As>File Type>MS Excel Template(*.xlt)

Name it SHEET and store it in your XLSTART folder.

This will be the default Insert>New Worksheet.

Gord Dibben  MS Excel MVP






- Show quoted text -
Click to expand...

How do you save it to the XLStar folder?
When you say it will be the default insert>new worksheet does this
mean it will be for all workbooks a person opens?
 
Hi,

You choose File, Save As,
Name the file Book
Change the Files of Type to Template "*.XLT"
Navigate to the C:\Program Files\Microsoft Office\Office11\XLStart

Your Office # may be Office10 or Office12.

This is the blank file that is opened when you first Excel and when you
click the New button.

It does not affect old files. It must be done on each computer, because it
is for that computer from the C:\ drive.

Cheers,
Shane
 
Hi,

You choose File, Save As,
Name the file Book
Change the Files of Type to Template "*.XLT"
Navigate to the C:\Program Files\Microsoft Office\Office11\XLStart

Your Office # may be Office10 or Office12.

This is the blank file that is opened when you first Excel and when you
click the New button.

It does not affect old files.  It must be done on each computer, because it
is for that computer from the C:\ drive.

Cheers,
Shane







- Show quoted text -
Click to expand...

So it will be the default new worksheet for all of excel on the
computer then.
Is there not a way or a macro to insert in a particular workbook to
have the same effect but only in that workbook?
 
You could just create your "master" worksheet, and then every time you
need a new worksheet based on that "master" you copy it.
-- Right-click on sheet tab
-- Select Move ro Copy
-- In dialog, select (move to end) and check Create a copy
-- Click OK
-- Rename new sheet

Ed
 
Back
Top