I have 8 sheets of relative references that I need to change to
absolute references. Can I change these in one go please?
Thanks
Brian

I am trying to reference a cell in another sheet by clicking on the
cell
='[Labour Variance Report wk01.xls]Summary'!$BA$44:$BC$44
The cell is actually BB44 but is spread across 3 columns and when i

I am a little new to formulas in excel and I need some help.
I have a large spreadsheet with about a hundred tabs.  The first 30 or so
tabs are individual info. then after that the tabs are grouped into accounts.
Meaning although they are still different tabs there are groups ...

I have limited data:
2006 annual sales by customer
Dec. 2007 sales by customer
sales margin by customer

I have this spreadsheet with a calendar for a whole year.
Each month is on a separate tab and covers a whole page when printed.
I would like these features if they are possible.
1- have a button on each page that prints the actual month (page that

On a monthly basis, I recieve about 30 workbooks and have to consolidate
them into a single workbook to forward to my prime contractor.  This
involves copying subsections of each of these workbooks into the same
location (sheet/rows) in my consolidated workbook.  I've got code ...

I have a speadsheet with 390 rows and 80 columns. For each column, I
wish to copy a range of cells and place them in rows so I can create a
separate table for each item represented by the column.
For instance, I would like to take the data from the range B10:B15 and

How can I get rid of the template task pane in Excel.

I can't get my array formula to work properly.  I see this problem in both
Excel 2003 and 2007.
The data fields are as follows:
A1: 1

I have exported a table from Access for repairs on various types of
equipment.  I want to calculate the reapirs for each unit (each has a
specific unit number) for each year of its existance.There are three
columns: ReapirDate, UnitNumber, Cost.  I have named these three

Can anybody tell me how to select a cell using a keyboard shortcut. I dont
wanna double click everytime I have to type in something. So thanks in
advance for your suggestions.
Trying2Learn

Good day all,
I am an Excel novice and would really appreciate assistance in regard
to the following:
I have a worksheet with employee names and employee no's each with

Using Office 2003.
I have an Excel data table that includes a column of dollar amounts.  Some
of these amounts are four or five digits and are formatted in Excel to use
the comma separator for thousands.

I am building a standard report template where the format does not
alter. I pull information from another table into this standard
report. The trouble is that the report I pull from changes so when I
have a formula =VLOOKUP(A674,B11:AW673,11,0) and there is no

Whenever excel shows a window to ask me something the text appears as black
on gray and the rest of the inside of the window is white. This makes the
window look wrong. This only appears in excel 2002 and not in word or
powerpoint. If I login as another user of the same computer ...