|
how do i increase the rows in a excel balance sheet?
i've prepare a balance sheet for my company.In the excel balance sheet i
can't enter more then 12 rows. what can i do/...
|
6 |
5/18/2007 11:40:57 AM |
|
|
For Max + Roger Govier
G'say fellas, been away, got back yesterday.
The Conditional Formatting did work after some tweaking.
Many thanks for your input,
Regards Pete
...
|
2 |
5/18/2007 5:33:17 AM |
|
|
Formulas
what is the formula for calculating GST and deducting this amount at the same
time from the total - getting the net value is what I want to achieve with
one formula...
|
5 |
5/17/2007 11:26:05 PM |
|
|
inserting a pattern fill in a chart in excel2007
how do u insert a pattern fill into a chart with the new excel 2007?...
|
5 |
5/17/2007 8:53:45 PM |
|
|
How do I automatically move down to the next row?
For example, I only need my spreadsheet to go to column H. Is there a way I
can get it to jump down a row and to column A every time I hit tab after
column H? I saw one question that had some really complicated macro
thingamahoozer that I didn't understand at all. Is there a simpler way?...
|
3 |
5/17/2007 5:42:23 PM |
|
|
If statement
I'm trying to use "IF" to do a calculation. What I need to do is run one of
two calculations based on the contents of a cell. Example: If A1="Salary"
Sum(B1*12). If A1="Hourly" Sum(B1*2080). A1 is always going to be either
Salary or Hourly and B1 is the rate of Pay. This is to calculate an annual
salary. Please help...
|
3 |
5/17/2007 2:46:01 PM |
|
|
Copy and Paste
On my worksheet in Col.F I have the result of (C+E)-D and currently I repeat
that formula by Copy & Paste on each new line of entries. Is there a formula
to get an automatic result in Col.F on new line of entries, to avoid the
Copy & Paste routine?
...
|
3 |
5/17/2007 12:49:27 PM |
|
|
Automatic Totals
How do I arrange for the sum totals in the last line on a worksheet with
several columns of figures will automatically adjust itself when I enter an
additional line or lines of figures, so that I do not have to use the
totalling tool every time I make entries on the worksheet.
...
|
10 |
5/17/2007 7:24:38 AM |
|
|
Date format
Hello,
When I enter the date format of choice 051607 and hit the return tab I get
this format 17-Apr-45
How could I fix this format, I have over 300+ days to correct
--
Please advise ---- Thanks for your help.
Sallie
...
|
2 |
5/17/2007 2:15:39 AM |
|
|
grid lines do not print (box is checked)
I have the grid box checked in print set up
print preview and printing will not include color or gridlines???
thank you for your time ;-)...
|
10 |
5/16/2007 11:05:34 PM |
|
|
can I lock a spreadsheet so if any changes are made must be save with new name?
I'm building a spreadsheet but when I get done I don't want anyone to change
it or fill it with data and then can't use it again later. What's the best
way to do that?
Brad
...
|
5 |
5/16/2007 9:26:55 PM |
|
|
I need a formula to calculate 2-3 columns but skip a column if it has a zero
I'm building a Golf League spreadsheet and we want to calculate handicaps
starting with the second week (calculates 2 weeks) and then after the 3rd
week calculates every 3 weeks.
Columns B-S are the individual weeks scores for each golfer (golfers listed
by row 4-33), each column (b-s) has a formula which pulls the golfers score
from the input worksheet(weekly input) to this worksheet(scoreca...
|
7 |
5/16/2007 8:08:05 PM |
|
|
calculating overtime
This is a multi-part message in MIME format.
------=_NextPart_000_001D_01C79713.596013B0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=original
Content-Transfer-Encoding: 7bit
Startime: 6:00 Endtime: 22:00
up to 8 hours Reg hours = 8
8.1 to 12 hrs 1.5x ot = 4
12.1 to 14 2x ot = 2
14.1 and up 2.5x ot = 4
if they work 6 days straight up to 8 hrs is ...
|
2 |
5/16/2007 3:43:03 PM |
|
|
how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
0.58
-1.22
1.79
-0.56
-0.92
the output would look something like
0.58 0.58
-1.22 -0.64
1.79 1.15
-0.56 0.59
-0.92 -0.33
...
|
2 |
5/16/2007 4:11:37 AM |
|
|
Maximunm # of Spreadsheets in any Workbook
Folks:
What is the maximum number of spreadsheets that can be opened in any
workbook.
I am using the Excel 2000 platform
Thanks,
John.
...
|
9 |
5/15/2007 11:23:52 PM |
|
|
Locking a row
I have data at a specific row at the bottom of the worksheet that I want to
stay in that row. However, when I add new data above it to a blank row and
tab past the end of the last cell to bring me down to the next row, the row
I want fixed (totals) also moves down one row.
Would someone mind telling me how I keep that totals row (last row) fixed
and allow new data to be entered into bla...
|
3 |
5/15/2007 9:30:32 PM |
|
|
Table of Routes
I am trying to produce a vessel route sheet
You would enter Route No, Date, From, To, ETD, ETD
Click "Add Leg" and keep adding legs until the vessel route is complete eg
Leg1 - 2 May - From A To B, 1200 - 1600
Leg 2 - 2 May - From B to C, 1800 - 2300
Leg 3 - 3 May - From C to A. 0100 - 0300
At some stage the route may change so the legs would have to be amended
Is this possible to do ...
|
5 |
5/15/2007 6:45:01 PM |
|
|
How do I label a column?
I am creating a sheet to keep track of my organization's volunteers and their
specific skills, and will often have to sort the chart, in case we need
people for certain duties. I want to re-label my columns, so that when I go
to sort the data, it allows me to sort by "Baking", or "Cleanup" instead of
"Column A", "Column B" and so on. There must be some way to do this, as I've
seen column...
|
8 |
5/15/2007 5:31:59 PM |
|
|
Why can't I do a "basic search" of my computer in Excel 2007
I can do a search of entire computer for info in Excel worksheets with older
versions of Excel. In 2007 I can only search withing on sheet at a time....
|
1 |
5/15/2007 5:11:03 PM |
|
|
Excel 2007 crashes after viewing property sheet in Data Connection
I have been using Excel 2007 to import comma delimited text (csv) files
stored on my local hard disk into my personal finance spreadsheet. The
Data>Get External Data>From Text wizard works fine and have had no trouble
using the Refresh function. The problem comes from accessing a Connection
Properties Box from the Data>Connections Box. If I select OK after viewing
the Properties...
|
11 |
5/15/2007 12:46:01 PM |
|
|
Conditional Formatting query
Hi all,
I need to place conditions on a spreadsheet dealing with dates.
In a column I have dates eg 28 Aug 07, 15 May 07, 20 Jun 08 etc
Lets say they are in cells B3, B4 and B5 respectively.
At cell A1 there is a date =TODAY()
In the B column I have placed conditional formatting as
Cell Value Is: Equal or greater than $A$1 - it returns a cell coloured RED
I'm at a loss to place a v...
|
6 |
5/15/2007 8:45:59 AM |
|
|
I need a formula
I have a table with 5 columns with each column being totaled. I also total
the totals. My problem is not all 5 columns are used all the time but i
still need to add the columns that are used. I know there is a formula to do
that. Some one pls help me....
|
2 |
5/15/2007 8:10:18 AM |
|
|
Stopping a constant variable cell from being copied.
Let's say I have a constant variable in cell A1
Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1.
Well if I want to copy C3 and paste it into C4 to C50, Excel will add to the
A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant variable (like
an interest rate).
How can I 'lock it in' so that when a reference of it is copied, the
reference remains the same?
An...
|
4 |
5/15/2007 2:35:55 AM |
|
|
Worksheet slow after printing
I have a worksheet with a number of command buttons to execute VBA commands.
Everything runs fast until I print the worksheet--then everything is in slow
motion.
I do not have to run any code. I can enter data manually & then print--then
it even takes a long time to delete the data.
Would be happy to send file.
--
Jim Morris...
|
2 |
5/15/2007 12:49:00 AM |
|
|
RE: Can I create a command box fora macro to be stored on my toolbar
You may want to check here for more information.
http://www.cpearson.com/Excel/menus.htm
In the future, please post more information in the message section when you
post your question.
HTH,
Barb Reinhardt...
|
1 |
5/15/2007 12:24:01 AM |