Negative Number column
I am trying to make a column product negative numbers when I manually enter
them in a spreadsheet. I am using a simple sum formula to add across rows
(10 columns) and the first column should always be a negative number i.e
credit and the rest positive.
I am real new to excel so I must be doing something wrong.
Assuming the 10 cols are A to J,
maybe a simpler way would be to use something like ..
In K1: =SUM(B1:J1)-A1
Or, in K1: =SUM(B1:J1,-A1)
with K1 copied down
Then you could just enter the credit numbers
in the first column "as-is",
w/o worrying about making these nega...Assign a Value to a Duplicate Entry Within the Same Column
Within a single worksheet I have thousand-plus rows of data and one of the
columns within that worksheet I have a series of numbers. After I've
identified the duplicates within that column I want to assign a value based
on the first time that number shows up (in this case by I'v sorted by date),
so the first duplicate would have a value like "1." I then want to assign
the next duplicate(s) sequentially (2, 3, 4, etc.) When finished I would
want a new column of data that would have far more "1s" than "2s," more "2s"
than "3s,"...Column and line information in Word
I have my cursor in a Word document and want to see which column it's in and
which line it's on. How do I view those details?
In 2007, right-click over the Status Bar at the bottom of the Word window,
and choose the options you wish to see, including Line Number and Column.
Hope this helps
> I have my cursor in a Word document and want to see which column it's in and
> which line it's on. How do I view those details?
...Name ranges and columns
I'm using MS Office Excel 2003. I'd like to be able to refer to a column by
a name so that I could use 'Price'23 instead of C23 and so forth. I thought
that I'd be able to do that by highlighting the column and then using
Insert->Name->Define or similar (I can't figure out the difference between
the Name->Create, Name->Define and Name->Label variations.
In any case, none of them seem to allow the kind of construction I'd like.
Do I have the syntax wrong in Price23 (for example ... how to separate
column and row parts) or is the whole thing impo...How do I rearrange (switch) the information in my columns to rows
Copy the data out of Publisher and into Excel. You can swap it out there
with the Paste Special (transpose) command.
MVP Microsoft [Publisher]
How to ask a question
"larrey" <firstname.lastname@example.org> wrote in message
The dirty way in Publisher, high-light the table, format menu, table, cell
properties tab, check *rotate text within AutoShape by 90 degrees* Rotate the
entire table 90 degrees.
Mary Sauer MSFT MVP
http://office.m...Hiding Columns In Excel
When I try to hide too many columns in Excell I get the
following message and it won't let me hide the
columns, "Cannot Shift Objects off Sheet.".
Is there a workaround? What am I doing wrong?
The following MSKB article may help:
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
Also, Dave Peterson recently posted this advice:
Someone with the same problem posted back that their comments were
getting resized causing the trouble.
Maybe enabling: Tools|Options|View|Comment and ...hiding columns
I have a report that has 17 fields. Therefore, it has two pages when I print
Is there a way that I can squeeze the 17 fields in one page report?
In Excel, we can hide or show columns when we need them or not. Can I
hide/show the fields on report?
Reports in Access are based on queries (ideally), or on tables. If your
report is based on a table with 17 fields, you are still not required to
include all the fields/controls on your report.
A preferable approach would be to create a query that only returns the
fields/columns of data you need in you...Marginal Abatement Cost
I want to create a marginal abatement cost (MAC) column chart in Excel 2003.
The data I am using is sorted for cost ($/tonne/year). Then I have a
marginal abatement (tonnes of CO2-e) and cumulative marginal abatement (also
tonnes of CO2-e).
On the x axis I will have cost.
The y axis shall be marginal abatement, the width of the columns shall
represent the marginal abatement, and their location on the axis will be
determined by the cumulative marginal abatement. Since the data is sorted for
cost, the chart shall show increasing cost with an increasing cumulative
...Column Graphs #2
I am having trouble with the scaling of my X axis (catagory axis) for a
column chart that I have created. It is a series of numbers from 0 to 55. I
need the graph to have a linear scale at the bottom and the columns to be
distributed accordingly. Any suggestions? Thanks
What data are you using for your X values?
A column chart does not have a numerical axis. The axis is comprised of a
set of labels, or placeholders. Do you need columns, or would another chart
Information on chart types and axis types:
http://pu...calculating subtotals for sequential blank cells in 1 column
if i had a column of data and i need to group/subtotal any cells containing
zeros or isolated zeros, wat formula do i put in
0 ) subtotal = 4 (so i know it was a group of four cells)
0 ) subtotal = 3
0 ) subtotal = 1
basically the data shows steps and rests, and we need to know how long the
rest periods are. single steps surrounded by rest (0) need to be counted as
Here is one way. Assuming your data starts in A1...
In B1 enter =--(A1=0)
In B2 enter =IF(A2=0,B1+1,IF(AND(A1=0,A3=...Renaming columns #2
I'd like to rename the A B C D at the top to the name of my columns, o
at least leave the column headings at the top of my screen.
Does anyone know how
Message posted from http://www.ExcelForum.com
Tools>Options>View, uncheck "Row and column headers".
You can insert a row and a column with your own names, but they will not be
recognized in formulas the same way as "A1". But you can define row and
column names and use the intersection as an address in a formula. The
intersection operator is a space. So if you defined the name "Material" for
column ...Macro to find the first cell in a column with different data
I really could use some of your expert and excellent help with a problem I
am having in creating a macro to perform a search in "Column A" to locate a
change in the data in that column and then move one column to the right and
one row down and type "1" in that cell.
I really appreciate your help, and Have a Blessed Holiday Season.
Perhaps this might also do it here ..
Assuming data is in A1 down, of the structure as below:
Put in B2: =IF(A2<>A1,1,"")
Kill the formulas in col B with an in-place:
Copy > Paste spe...hiding columns, error message says cannot shift objects off sheet
Hiding columns on a spreadsheet ( which we do frequently). Error message
says: 'cannot shift objects off spreadsheet'.
WHat does this mean and how do I work around it?
excel thinks that there is data in column IV. excel by
default cannot shift data off the sheet ie beyound column
IV or below row 65536.
solution. highlight all the column to the right of your
data and hit the delete key. that should fix it.
>Hiding columns on a spreadsheet ( which we do
frequently). Error message
>says: 'cannot shift objects off spreadsheet&...What is the limit size for columns in Excel???
Hi, I am trying to paste some information on a sheet, but I see that columns
have a limit size....Is there any "plug in" or some kind of feature to
increase the column number???
On Thu, 27 Jan 2005 10:49:02 -0800, "Melissa"
>Hi, I am trying to paste some information on a sheet, but I see that columns
>have a limit size....Is there any "plug in" or some kind of feature to
>increase the column number???
A sheet is limited to 256 columns. As far as I know there is no way to get
around ...Adjust scales automatically
How can I arrange it so that the x and y axis scales
automatically adjust to different data within the same
Eg say I make a chart that has the x axis (A1:A10) going
from 1 to ten. If I paste in an x axis range going from
100 to 1000 how can i get the scale to adjust
Thanks for help,
Jon Peltier has instructions for linking the axis scale to formulas on a
> How can I arrange it so that the x and y axis scales
> automatically adjust to different data within t...Can one adjust Format Row Autofit to ensure WYSIWYG when printing
Does anyone know if you can adjust Format Rows Autofit to ensure WYSIWYG when
printing. I am continually frustrated that when I print after using the
autofit function that I get text cut in half and underlines missing. Autofit
does not seem to work properly. Can it be set to slightly overcompensate
Hi Gray, this problem only happens when you're working in a zoo
different from 100%; so if you're working with 115% and autofit th
rows they won't show up properly when you print (they will be cutted)
Also there is a problem you have to consider is when you use Bold o...sort column by last digit
Lets say I have a column like:
etc etc etc
...and I want to sort it so that the ones that end with the letter G
are isolated. Is there a way to do this?
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=502969
In a helper column, add
then sort by the helper column.
(remove nothere from...CListCtrl question: dock columns to right
I have a CListCtrl which is a child of a resizable dialog. (The list control
changes its size when the dialog is resizing).
I need that the columns of the list will always be aligned to the right.
All the columns (accept the first) have a fixed size.
In order to achieve this behaviour I catch the WM_SIZE event of the list
control and call to SetColumnWidth of the first column.
The width that I set to the first column is the width of the list control
minus the sum of the width of all other columns. (see code at
the end of the question).
Generally it works fine, but I get the most strange be...Prior Period adjustments
I need to post a headcount entry in a prior year (closed) to use in a
headcount report as an opening balance (YTD/BB) in FRx
Is this possible?
You should be able to post without any issues, or I should say, as long as
you have Post to History enabled in your GL Setup screen.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> I need to post a headcount entry in a prior year (closed) to use in a
> headcount report as an opening balance (YTD/BB) in FRx
> Is this p...Printing the last column on every page printed.
I want to be able to print the last column of my spreadsheet (Total column)
on every page that is printed from this workbook. How can I do this? I'm
Thanks for your help!
Are all the last columns in the same location (column X for example)?
If yes, you could group all the sheets (click on the first, ctrl-click on
then select column X
File|print|Select (bottom left corner)
Do a preview first.
But this prints each worksheet (column) on a different sheet.
You could have a macro that built a new worksheet and just copy|pastes values|
that last column ...Move Partial Data from One Column to Another
I am looking for a way to take 5000 lines of data in Excel and take th
last 6 digits of the data and move it into another column.
For Example: Take the last 6 digits and move to next column
Data 1 Data 2
435490870985430984 | 430984
234083209842309820 | 309820
432958739287193872 | 193872
542389034098430945 | 430945
With over 5000 lines to move I need an automated process so that i
does not need to be done manually, any help or ideas would be greatl
Message posted from http://www.ExcelForum.com
Are the numbers of the same length (...Name a Column
Is it possible to put a name in place of the "A" at the top of the column? How do I do it?
"DaveB" <email@example.com> wrote in message
> Is it possible to put a name in place of the "A" at the top of the column?
How do I do it?
No, is not possible.
Place names/titles in Row 1 then select A2 and Window>Freeze Panes to keep
these in view as yoi scroll down.
Tools>Options>View. Uncheck "R...Auto-adjust column width
Is there a way to set a column width so that it auto-adjusts to the widest
entry in the column? And what about the widest numerical entry, excluding
word-wrapped cells containing text?
I realise that I can double-click on the edge of the column header to
achieve most of the desired result passively, but this does not work if the
worksheet is protected.
Return email address is not as DEEP as it appears
depending on your Excel version you can allow formating columns in the
protection dialog. (I think starting with Excel 2002). In all other
cases no chance but to remo...viewing printing report project tells me to adjust margins and sca
I'm just posting this solution since it took me soooo long to figure it out.
When you get an error when printing or viewing a repot that tells you to
adjust your margins and scaling because the page is too small in project
2007, just ensure that your page size and orientation is all the same across
the board (in your print setup, in your printer's finishing page, et cetera)
and that your page size is big enough (e.g. moving from letter to legal to
make more room). My page size and orientation was mis-matched, and once I
corrected it, I could view/print the reports.
...Matching data in columns
I hope somebody can help me.
I have a list in column C of 13000 names with a reference number against
each of them in column D. The reference numbers are between 1 and 760 and
each of the 13,000 names in column C has one of the 760 numbers against it in
column D. In column F, I have the list of 760 numbers with text for each of
these numbers in column G.
I need to correctly insert the text for all these 760 names against my main
list of 13,000 names. To try to explain it I want to:
If number in any cell in column D equals the same number in any cell column
F, then paste the text in...